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
28,677 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
28,677 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,286 reads
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Comments posted to this topic are about the item 25 Years of SQL Server...
Comments posted to this topic are about the item The Decoded Value
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers