Insert multiple records with one INSERT statement by combining SELECT and UNION ALL, instead of a separate INSERT for every row. SQL Server 2008 has a newer way.
SQLAuthority News – Author Visit – Meeting with Readers – Top Three Features of SQL SERVER 2005
Over dinner in Las Vegas, two readers asked me to pick my top three features of SQL Server 2005 out of Microsoft’s top 30. Here is what I picked and why.
What Is NULL in SQL Server? The Value That Isn’t a Value
NULL in SQL Server is not zero and not an empty string. It means the value is unknown, and that changes every comparison you write. Why equals never matches, the NOT IN trap that returns nothing, and where NULL is allowed to live.
Data Types That Waste Space
Data types that waste space include oversized integers, blanket nvarchar(max), and unnecessary datetime2 precision; measure before changing.
Index Optimization Checklist: A Printable One-Page Guide
The twelve things I ask a junior DBA to check before I touch a slow query, with three quick proofs you can run yourself.
What Is a Heap in SQL Server?
A heap in SQL Server is a table with no clustered index. Forwarded records pushed one count from 11,113 reads to 199,844, and a single REBUILD put it back. When a heap is fine and when it is not.






