Comparing SQL Server constraints and DML triggers
Over the years, I have witnessed many developers being confused about when to use data-manipulation language (DML) triggers vs. when to use constraints.
Virtual Conversions
Virtualization is becoming more and more popular, being implemented in many companies every day to replace the need to add more physical boxes to your data center. Steve Jones comments on some of the handy features of virtualization.
Virtual Conversions
Virtualization is becoming more and more popular, being implemented in many companies every day to replace the need to add more physical boxes to your data center. Steve Jones comments on some of the handy features of virtualization.
Virtual Conversions
Virtualization is becoming more and more popular, being implemented in many companies every day to replace the need to add more physical boxes to your data center. Steve Jones comments on some of the handy features of virtualization.
Disabling Indexes
Expert SQL Server trainer Andy Warren brings us a new article on a lesser used feature in SQL server 2005: the ability to disable an index.
How to use ranking functions in SQL Server 2005
With ranking functions in SQL Server 2005, you can rank rows in result sets. This tip defines rank functions and gives examples of how to use the four available functions.
Knock, Knock...What's Funny?
Humor in the workplace is essential for a good environment, but employees need to be careful about what they might consider sharing.
Knock, Knock...What's Funny?
Humor in the workplace is essential for a good environment, but employees need to be careful about what they might consider sharing.
Knock, Knock...What's Funny?
Humor in the workplace is essential for a good environment, but employees need to be careful about what they might consider sharing.
SQL Server Audit in SQL Server 2008 – Part 2
Learn how to monitor database-level actions and write audit results to files.
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I specify only the Resource Database?
See possible answers