GROUPING SETS lets me choose independent subtotal combinations instead of assuming one hierarchy. I list the groups the report needs explicitly. That can exclude detail rows while retaining summaries across different dimensions.
SQL SERVER – TRUNCATE Can’t be Rolled Back Using Log Files After Transaction Session Is Closed
Can TRUNCATE be rolled back? Inside an open transaction yes, but once the session is closed TRUNCATE can’t be rolled back using log files, while DELETE can.
EXP and LOG: Read Approximate Inverse Calculations
EXP and LOG can undo each other mathematically, but their SQL float calculations remain approximate. Keep a deliberate display scale and test only the permitted logarithm domain.
SQL SERVER – 2008 – New DataTypes DATE and TIME
SQL Server 2008 adds separate DATE and TIME datatypes, something DBAs wanted for years. I compare them with the SQL Server 2005 way of using DATETIME.
SQL SERVER – Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script
Index Rebuild drops and recreates the index, while Index Reorganize reorders the leaf nodes. Rebuild above 40% fragmentation, reorganize between 10% and 40%.
SQL SERVER – Enabling Clustered and Non-Clustered Indexes – Interesting Fact
When enabling clustered and non-clustered indexes, order matters: enabling the clustered index does not enable the others, but rebuilding all indexes does.
SQL SERVER – DISTINCT Keyword Usage and Common Discussion
Can you apply the DISTINCT keyword to only one column in a SELECT? No, it always applies to all the columns. I explain why and get the same result with GROUP BY.