Hi Michelle,

Well - you do sound like you're going to be in for an interesting ride!

Can you log-ship from 3 separate servers...

Guus,

I use the following SP which I found on a forum some time ago. It relies on the data in the msdb..backupfile table, which is updated each time a...

Yes, use the OSQL command

e.g.

osql -S servername -E -i sql_script.sql -o outputfile.txt

-S = servername

-E = Windows authentication (trusted)

[-U = SQLServer username]

[-P = SQLServer password]

-i = SQL commands input...

Couldn't agree more. On Colin's recommendation a while ago, I went to one of Kimberley's seminars in Reading. Brilliant, absolutely brilliant! I've always prided myself on understanding...

Just to reinforce the importance of the ORDER BY clause ...

Even with the same query plan, there is NO guarantee that results will come out in the same order every...

If you're using local disks, then I agree that object placement can offer real benefits.

I start to doubt the effectiveness of file placement once you start working with striped disks...

Well, I think my first suggestion should work, shouldn't it? Doesn't involve touching system catalogs.

Don't forget, also, that tempdb is used by the optimizer for creating intermediate join tables, sort tables, hash tables etc whilst a query is executing, even if that query does...

Yes, that should work - I was trying to offer a solution that didn't involve messing around with system catalogs!

Depends on exactly what size information you want ...

sp_helpfile will give you the individual sizes of each file that makes up the database.

sp_helpdb will display the TOTAL size of all...

Warwick,

The ID column is the object_id of the table itself, not the indexes. The INDID column holds the unique value for the index.

Since all your indexes are created on...

Not that I've ever found. Hyperthreading is a real pain when it comes to licensing - even the Windows information makes it look like you've got twice as many...

Yeah, you're right - I'm thinking in SQL2K5 mode!

I've just tried the detach/re-attach method, and it works for me (just as it does in your test environment).

You can't delete the...

If you can't physically copy the tranlog files to the 2ary machine, then there could be any number of problems. You should not require additional ports to be opened,...