A reader’s job failed after upgrading to SQL Server 2008 because TRUNCATE_ONLY is gone. My notes on SHRINKFILE and TRUNCATE Log File, and what to watch for.
SQL SERVER – The Difference between Dual Core vs. Core 2 Duo
Dual Core was a brand, not a core count. What actually matters for SQL Server is cores, clock speed and licensing. How to see what you really have.
SQL SERVER – What is AdventureWorks?
What is AdventureWorks? Why I use this SQL Server sample database in my examples, how it replaced Northwind and Pubs, and where to get it.
SQLAuthority News – TechEd India – April 12-14, 2010 Bangalore – An Unforgettable Experience
TechEd India 2010 in Bangalore drew over 3,000 people, the biggest tech event I have seen here. I presented three sessions and joined a panel. My full report.
SQL SERVER – Disable Clustered Index and Data Insert
A client’s DBA disabled every clustered index before a bulk insert, and the application stopped working. What happens when you disable clustered index?
SQL SERVER – GUID vs INT – Your Opinion
GUID vs INT as a primary key or clustered index: I list one advantage and one disadvantage of each and ask you to add yours in the comments.
Storing Percentages: 0.15 or 15, and How to Tell Them Apart
Storing percentages starts with a declared unit. Fractional rates and percentage points require different conversions, even when both pass a range check. Use named columns, explicit boundaries and a guarded disposable fixture.