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
20,022 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
20,022 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,202 reads
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
Always Encrypted was a new encryption feature added to SQL Server with the 2016...
By DataOnWheels
Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...
Make your arrival in Mauritius hassle-free with our efficient airport transfer service. Our experienced...
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...