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,853 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,836 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,787 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,488 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,865 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,693 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,104 reads
Microsoft has released Service Pack 3 for SQL Server 2008 yesterday. You can read this blog post from SQL Server...
2011-10-07
882 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,726 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,329 reads
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Hub Via Wa:628218200233 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
Hub Via Wa:628218200174 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
Comments posted to this topic are about the item A Challenge of Our Knowledge
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers