Showing posts from March, 2012

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…

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 i…

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…
Subscribe Our Newsletter