This link (one of the ones returned from the first one above) shows how to do this.

Did you check out SQL Source Control from Redgate? (Note: I haven't used it; I've just seen it advertised a bit lately...)

@paul-2 - did you see your blog plug from Brent Ozar in his daily email?

Inside the Optimiser: Constructing a Plan – Paul White is writing some of the best SQL...

And we know that Jeff doesn't want any pork chops aimed at him! :w00t:

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL...

One thing that all of the above are assuming is that the freedate column contains only dates, with the times set to 00:00:00.000. If this is not the case, then...

RBarryYoung (3/8/2010)

You mean like:

GRANT SELECT ON dbo.MyProc TO user1,user2

You might want to check out this BOL link.

I thing that I've noticed from the recommended indexes, is that there will be some very similar indexes.

i.e. it might recommend both of the following indexes

CREATE NONCLUSTERED INDEX [IX1] ON...

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

In BOL (From Clause):

In Deprecated Database Engine...

This link has some useful tips for how to accomplish this.

I agree with Lutz... we need the Table DDL and sample data (in the form on insert statements) to see what's going on. Just be sure that you sanitize the...

You might want to check out the white paper SQL 2008 Technical Reference Guide

Yes, I assumed that a table with a million records would already have a clustered index. That's why we pull the data into a #temp table, and throw the index...