How to disable constraints on a table
Sometimes it's useful to disable one or more constraints on a table, do something significant like a BULK INSERT / DELETE, and then re-enable the constraint(s) once you're done. You can dis…
Showing posts from March, 2012
Script to find the size of an Index
Simple query to find the size of the indexes SELECT OBJECT_NAME(i.OBJECT_ID) AS TableName, i.name AS IndexName, i.index_id AS IndexID, 8 * SUM (a.used_pages)/1024 AS ' IndexSize in…
SQL Server 2012 Virtual launch event
Finally.. the most anticipated version of sql server is ready for launch. Just few more hours..want to register for the virtual launch, click the below link Experience the excitement of the SQL Ser…