Tired - watched some of the SQL Pass webmeetings until the early hours :doze:

Last time I had to do something like this I needed to change the properties of the distributor too. Easy enough though.

snickers

The link provided by Gail is exactly what you need. The Syngress book is very good, I used it and passed with a good score. Make sure you take the...

It just so happens that today is T-SQL Tuesday and the theme is indexes, you may want to look here. The book that Steve recommended was written by Grant and...

Baggy Trousers

Hi,

It appears that there is a parenthesis ")" missing after DATA_COMPRESSION = PAGE

Rich

Hi all,

Thanks for your replies, I've not been able to respond before due to illness.

Matt: That's really interesting, I'll bear that in mind, thanks.

Pei Zhu: This is the way...

I'm a big fan of SSIS (SQL Server Integration Services). You'll find that you can do a lot more with the data in terms of cleansing and logging exactly what...

The following in theory should work.

Find out the 0 date in Excel, for this example let's assume it's the same 0 date as the datetime data type 1/1/1900.

If the Excel...

That's really interesting, have you tried doing a restore with verifyonly?

Real world database errors on a SQL forum - you gotta love that 😀

Really you should be using the new DMV's rather than the old system style tables.

One that you might be interested in is: Sys.DM_Exec_Query_Stats

you can link this dmv to sys.dm_exec_sql_text and...

What details are you trying to collect exactly?

You say that you're going to collect it on every database on the domain, if you're going to do this I would suggest...

There are lots of opinions on how TempDB should be set. Some people show metrics on how much quicker it is when split across multiple files whilst others have shown...