This is a follow up post from a comment on my blog.
Earlier I posted about using xp_instance_regread to get default...
2012-01-10 (first published: 2012-01-05)
2,822 reads
Getting row count for all tables in a database is straight forward. You can display row count for all tables...
2011-12-28
2,823 reads
Identifying current service pack installed for SQL Server can be difficult if you don’t know which command to use! Most...
2011-12-25
2,775 reads
The sys.dm_exec_requests is a great way to find out how long the BACKUP will take to complete. If you are...
2011-11-18
3,473 reads
You run into this error when using sys.dm_db_index_physical_stats DMV on a database which is running under SQL Server 2000 (80)...
2011-11-14
1,846 reads
Last week, i posted about moving tables to different file groups by recreating indexes. However, this method does not *work*...
2011-10-19
2,670 reads
Well, it can’t be done. You cannot move a table to a particular file in database.
What you can do is...
2011-10-13
2,089 reads
Microsoft has released Service Pack 3 for SQL Server 2008 yesterday. You can read this blog post from SQL Server...
2011-10-07
865 reads
Marking a stored procedure as system object allows to run the procedure in a user database context. There are two...
2011-10-03
2,688 reads
A dump device is simply a logical device which redirects to a specified physical device. The main advantage of using...
2011-09-26
1,312 reads
I was sick of changing context in Azure Data Studio while cleaning up things...
By Zikato
The crime spree in Digitown is not ending. This time 20 cars have been...
By Steve Jones
One of our mission statements in the Book of Redgate says: attempt to do...
In today’s business world, Environmental, Social, and Governance (ESG) criteria are no longer optional. Customers, investors,...
Comments posted to this topic are about the item Shining a Light on Shadow...
Hi, I would love to hear if anyone can tell me why a CAST...
In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?
See possible answers