Re-size TempDB files
Managing TempDB can be a bit tricky at times. Most people know how to increase the size, but what about reducing it? New author Amar Pogaku brings us two techniques for shrinking tempdb.
2009-04-03
17,652 reads
Managing TempDB can be a bit tricky at times. Most people know how to increase the size, but what about reducing it? New author Amar Pogaku brings us two techniques for shrinking tempdb.
2009-04-03
17,652 reads
This SP gives you most of the detail you need on a long running query. Simply pass the SPID.
2009-01-12 (first published: 2008-12-31)
2,104 reads
By kleegeek
We’ve been tracking a weird state with SQL Server virtual machines on VMware and...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
A client of ours is upgrading their database to SQL Server 2019. The edition...
Hi, I need to perform backup and save it in network drive. I have...
Hello Group, Do you have any available extended events to capture the queries run...