I have definitely seen Profiler bring a PC to a hault and would not be at all surprised if it did the same to a server. Unless you...

Tara-1044200 (4/12/2010)

---

Here is another thing i observed the slow query has a table spool which shows actual rows=1510403515 actual rewinds=46 but i dont see any table spool for fast query....

It seems like SQLCMD or Powershell would work just fine for something like this. And really whichever you prefer, it should not make a difference.

Within...

Tara-1044200 (4/8/2010)

---

I agree you point there a logic for it but actually my query is running faster for bigger database(remote) when compared to smaller one. Both databases are on different...

Now that you point out the Remote calls, I will say that I have seen some circumstances (all have been on SQL 2000 admittedly) where the optimizer seems to lose...

Obviously there are a lot of things that this could be, but the first thing that comes to my mind when I read your original post is what exactly is...

You can definitely script out the addition of linked servers as it sounds like you are wanting to do here.

As a very basic, just to add a linked server with...

After setting up the alerts notification within the SQL Agent, did you restart the SQL Agent? If you did not, you will need to before emails will be sent...

I think that the answer here is "it depends". By adding the compression ahead of time, you will end up using more CPU during the load than you...

DBCC could be run from just about anything. You could have it run through an application, powershell script, OSQL, SSIS Package (from another machine)...pretty much anywhere that you...

Yes you would have to bring it back online to detach, however you would have the ability to bring it back online in single_user mode, which would keep those other...

You could do this by first bringing the database offline. You can see that described in this article

http://www.sqlservercentral.com/articles/Administration/deattachandreattachdatabases/646/

This seems like it should do what you are wanting done.

I am not aware of any whitepapers on the newid function and the only documentation that I have seen is in books online.

However if you want to write up your...

It is really all about managing the risk. We keep maintenance renewed on Litespeed (and you are right it is expensive) mainly because our backups are too important for...

Using your basic script you can just add this to it:

SELECT jobs.name as 'JOB_NAME',his.message as 'MESSAGE',SUBSTRING(cast(his.run_date as varchar(9)),7,2) + '/' + SUBSTRING(cast(his.run_date as varchar(9)),5,2) + '/' + SUBSTRING(cast(his.run_date as varchar(9)),1,4)...