That's the way I do it.

To get the datetimestamp, just incluse an extra select statement before your dbcc command, as ALL output from the job gets written to the file....

My preference is Compiled Help Files. .chm

Just the fact that I can hyperlink dependencies makes it invaluable to me, and you should see the managers eyes bug out when you...

Q1.When you say it goes off into never never land, do you mean that the process says it's running, there's no waits indicated, and query analyser shows the process is...

From what you show, I would say that the index is also a Primary Key constraint. You would have to remove this constraint in order to change the index to...

In my case, I'm hitting against 58 million rows with 2 joins, and antares686 second script with some slight mods to adjust for my case of 2 zeros, and Greg's...

It's quite easy to add asp pages to a custom MMC that includes your EM. If you want to modify EM directly, the files that make up a good portion...

I bet the excel file has a column formatted across the whole sheet as a header that's causing the overflow. You might check that, as Sql only actually samples a...

Absolutely.

Kill(spid)

of course, replace the spid with the process id of the connection you want to kill. And although EM is nice, I use QA to do it in either.

There are...

How do those compare to the Case statement? Drat it, I'm not at my test machine to check myself. I won't be able to find out till thursday at best....

When it's needed, I use a secured table in my DBA database, to hold connection information, and a dynamic properties task to pass it. On password changes, I update a...

Your reading it correctly. I think Microsoft should have put more thought into splitting the tools for working with indexes and the tools for working with statistics out seperately. I...

You cannot remove statistics for an index. You remove the index. The purpose of statistical indexes are for situations where there is no index or there are poor ones. Statistics...

Looks like in the time I used to play with it, you've come to the same conclusion I have. With a scale of ten, you get ten digits. In order...

Set up your query in QA. Such as:

Select fieldlist from remoteserver.remotedb.owner.table

Run it.

When it succeeds, place the Create View ViewName As above it in QA such as :

Create View ViewName...

In answer to landrake, In my case, I go with Procs over DTS at every opportunity, and yes it's for portability mostly, but there are definite performance gains to be...