My Adventures with the SQL 2005 Security Cache
Introduction
For that past couple of months I have been chasing performance issues with one of the most high profile servers...
2010-03-09
489 reads
Introduction
For that past couple of months I have been chasing performance issues with one of the most high profile servers...
2010-03-09
489 reads
Introduction
Recently a coworker was doing some research with SQL 2008 Backup Compression on a very large database. During the testing...
2010-02-25
412 reads
Introduction
I am frequently getting requests for a new server to do this or that. Running through the usual questions to...
2010-02-23
463 reads
Introduction
Here is another one of my utility scripts. Lately it seems like all I am blogging about is utility scripts,...
2010-02-01
2,390 reads
Introduction
Ever need a programmatic way to figure out if a SQL Agent job is running? I did. After spending a...
2010-01-31
2,490 reads
Introduction
Lately it seems like I am being bombarded by Dynamic SQL and people who insist it is the only way...
2010-01-21
625 reads
Introduction
Traditionally when doing a restore, moving a database, etc. a DBA would simply go into Management Studio and use the...
2009-12-31
1,756 reads
Introduction
Tonight on Twitter the call went out on #SqlHelp looking for a way to script just database permissions for a...
2009-12-31
1,420 reads
Introduction
Properly managing VLFs can make or break the performance of your databases. There is a ton of information out there...
2009-12-21
857 reads
Introduction
From time to time you find yourself needing to shrink some space out of TempDB. Shrinking database files is never...
2009-12-17
3,018 reads
By Kevin3NF
The Two-Layer Model Explained “We added them to the database, but they still can’t...
By Steve Jones
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER...
Wondering which database to tackle first? I’ve got the lowdown on the top free...
Hi we often use non expiring windows and sql accounts to actually run (credential...
Comments posted to this topic are about the item Changing the Paradigm of Work
Comments posted to this topic are about the item Removing a File
I attempted to use ALTER DATABASE to remove a file from my filegroup in SQL Server 2022. There are 4 files in this filegroup, but I don't need them all. However, I received a message that the file was not empty. How do I empty this file so it can be removed?
See possible answers