Steve Jones - Editor (8/23/2010)

---

I saw that from Brent. Paul is garnering lots of respect from the other gurus.

We need to get Paul out here in the US for some...

chinn (8/23/2010)

---

DECLARE complex_cursor CURSOR FORWARD_ONLY FOR

SELECT name from master..sysdatabases where name not in('Tempdb')

order by name

Open complex_cursor;

FETCH next from complex_cursor into @dbname

WHILE @@fetch_status = 0

BEGIN

set @dbname = upper(@dbname)

set @backupname =...

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 should be aware that although no City in the U.S. that I know of crosses state lines, some may effectively cross county lines, and many cover more than...

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...