Bad Idea Jeans Archives - Page 2 of 2 - Brent Ozar Unlimited®

News & Opinion

Brent’s Bad Idea Jeans [Video]

December 1, 2014

Over the years, I've come up with some rather “interesting” answers to SQL Server problems including:

Warming up SQL Server's buffer pool by selecting all the data from all the tables
Creating indexes with triggers
Adding nonclustered indexes to clustered columnstore indexes
Compressing backups the hard way
Putting databases on a RAM drive

Performance Tuning

Using Triggers to Automatically Add Indexes

July 30, 2014

Let's say you've got a vendor application that creates tables, loads them, queries them, and drops them all the time. You can't change the code.

The tables involved desperately need an index in order to go faster, and they're your biggest performance bottleneck.

Performance Tuning

How to Add Nonclustered Indexes to Clustered Columnstore Indexes

March 25, 2014

SQL Server 2012 introduced nonclustered columnstore indexes, but I never saw them used in the wild simply because once created, they made the underlying table read-only. Not a lot of folks like read-only tables. (Bad news, by the way - that limitation hasn't disappeared in 2014.) SQL Server 2014 brings clustered columnstore indexes, and they're…