SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: September 2010

Index Operations Showdown: Drop & Create vs. Create With Drop_Existing vs. Rebuild

Every now and then you may have had to move nonclustered indexes between filegroups. There are two ways it can be done: drop the existing indexes first then create new ones or execute a create statement with the DROP_EXISTING = ON option. At face value it may appear that SQL… Read more

2 comments, 4,311 reads

Posted in Kendal Van Dyke on 29 September 2010

Presenting At Sarasota SQL Server Users Group On Sept. 21

On Tuesday, September 21, I'll be at the Sarasota SQL Server Users Group to present Paging DR Availability, You're Wanted in the Recovery Room. This is my first time at the Sarasota UG and I'm excited to meet new people, share something useful, and sneak in a word about… Read more

0 comments, 409 reads

Posted in Kendal Van Dyke on 15 September 2010

PASS Summit Logo Design Contest

It appears our success with the SQLRally Logo Design Contest has struck a chord with PASS HQ. This morning Rick Heiges (Blog | Twitter) made an announcement on Twitter:

I'm absolutely thrilled that PASS thought highly enough of our SQLRally contest results to run the same kind of… Read more

0 comments, 799 reads

Posted in Kendal Van Dyke on 10 September 2010

More On Overlapping Statistics

In my last post I provided a script to identify overlapping statistics but realized afterwards that I left out a few points that complete the big picture about why overlapping statistics matter.

What Causes Overlapping Statistics
Boiling this down to basics, here's how it happens: AUTO_CREATE_STATISTICS is set to ON,… Read more

0 comments, 833 reads

Posted in Kendal Van Dyke on 9 September 2010

Tuning Tip: Identifying Overlapping Statistics

Statistics are used by SQL Server's query optimizer to help determine the most efficient execution plan for a query. When the option to automatically create statistics is enabled (which it is by default) SQL Server will create statistics on columns used in a query's predicate as necessary, which usually means… Read more

2 comments, 1,611 reads

Posted in Kendal Van Dyke on 8 September 2010