Do you need to combine or merge two data files (MDF or NDF)? There are a number of complicated options available or you can use the two lines of code below to do the trick... It's up to you. This method works with both SQL Server 2005 and SQL Server 2008.
Want to rebuild all the indexes in your MS SQL database? The script below will rebuild all the indexes in your SQL Server 2008 or SQL Server 2005 (SP2) database and offers a number of enhancements that make this the best SQL Server index rebuild script in all the land and the first choice of… Continue reading SQL Server Rebuild Indexes – The Fastest Way
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.