It has not been clear to what extent fragmentation, either internal or external, truly affects the performance of your SQL Server 2000 databases. New author Koby Biller discusses some of the impacts that it could have and has a free tool for download that can help you determine how fragmented your disk truly is.
2005-08-16
9,641 reads
When Covid took out the PASS organization, I had someone say to me, “Well,...
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I have a SSRS report for which users are complaining to be slow, but...
Hi I set this up today. I wanted to get some feedback. I have...
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint))
, BIT_COUNT (CAST (-1 as bigint))
See possible answers