Explain sequence gaps, inspect cached values, test rollback behavior, and separate SQL Server identifiers from gapless numbering.
SQLAuthority News – Interview with SQL Server MVP Madhivanan – A Real Problem Solver
SQL Server MVP Madhivanan has left over 1000 helpful comments on this blog. In this interview he talks about his work and his life outside SQL.
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.
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 GETDATE and SYSDATETIME
What is the difference between GETDATE and SYSDATETIME? GETDATE stops at milliseconds, while SYSDATETIME in SQL Server 2008 goes much finer.