The following script is the fastest way to update stats on all your tables with the FULLSCAN option. Developed and tested by SQL Server Consultants.
SQL script to find all the tables in a database which are missing a primary key.
Need a list of Foreign Keys in your database. This simple query will deliver quickly and efficiently.
How do you check whether read committed snapshot is on or off for a particular SQL Server database using SQL Server Management Studio? We’ve never been able to find it but this quick T-SQL query will show you the answer. (Also check out our post on checking whether Snapshot Isolation is on):
How do you know whether snapshot isolation is on in SQL Server? A quick T-SQL query will show you the answer.
What’s the fastest way to get the number of rows in a table on SQL Server 2005 or SQL Server 2008? Use the code the pros use.