What is in your memory cache? A query on sys.dm_os_buffer_descriptors shows the data pages in buffer pool for each table and index.
SQL SERVER – Find Largest Supported DML Operation – Question to You
Best practice says the log should be twice the size of the largest supported DML operation. But how do you measure that? Share your ideas with me.
SQL SERVER – Shrinking Database NDF and MDF Files
Previously, I had written a blog post about SQL SERVER. I am posting this blog post here about Shrinking Database.
SQLAuthority News – Author Visit – SQL Server 2008 R2 Launch
I traveled from Ahmedabad to Mumbai for the SQL Server 2008 R2 Launch event on June 11, 2010, with a laser show, PowerPivot demos and great networking.
SQL Server 2025 Editions: What Express and Standard Can Do Now
Compare SQL Server 2025 editions, inspect Express and Standard limits, identify the installed edition, and review database portability.
SQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATE
I repeat my DATETIME and DATETIME2 test with GETDATE instead of SYSDATETIME. See how the distinct values in each column compare this time.
SQL SERVER – Difference Between DATETIME and DATETIME2
A developer filled a DATETIME and a DATETIME2 column with the same value and got different results. Here is the difference between DATETIME and DATETIME2.