FAQ
overflow

Great Answers to
Questions About Everything

How Far Should You Go with Normalization?

Efficency of Stored Procedures vs Raw Queries

Index Fragmentation & SSD Disks

Why Not Use a Table Instead of a Materialized View?

Why Would I NOT Use the SQL Server Option "optimize for Ad Hoc Workloads"?

What Are the pros/cons of Splitting Date & Time into Separate Fields vs. Using the Datetime Data Type & Storing the Date in a Single Field?

What Is the Fastest Way to Insert Large Numbers of Rows?

Does "WHERE 1=1" Usually Have an Impact on Query Performance?

Placing Transaction Log on Separate Volume [solid state]?

SQL Server 2008 Cross Database Performance on Same Physical Machine & Server Instance