How to get the current Database and Log Filesize using MSSQL
To get the current Database and Log Filesize using MSSQL you can use the snippet below. Tested using SQL Server 2012. Sample MSSQL Sample Output
All the Code Snippets and Samples you need
To get the current Database and Log Filesize using MSSQL you can use the snippet below. Tested using SQL Server 2012. Sample MSSQL Sample Output
To drop Primary Key of a Table using MSSQL you can use the snippet below. http://youtu.be/0kfyw8M83bA Sample MSSQL
To search stored procedures using MS-SQL you can use the snippet below. https://www.youtube.com/watch?v=qbHT5HYyTKg Sample MSSQL
To split a delimited string to multiple rows using MSSQL you can use the snippet below. Sample MSSQL
To use select statement in a delete statement using MSSQL you can use the snippet below. Sample MSSQL
To get the size of all tables using MSSQL you can use the snippet below. Sample MSSQL
To get the Monday date of the current week you can use the snippet below.
To delete duplicate records using MSSQL you can use the following snippet. The table must have identity column, which will be used to identify the duplicate records.
In MSSQL IF ELSE is not supported inside the SQL-Query. For a similiar behaviour you should use CASE WHEN keyword. Sample Query
To list all Databases in MSSQL you can use the following snippet. Sample MSSQL SQL Server Version newer than MS SQL 2000 also support these StoredProcedures. or