Check the alert, and see what it is configured for. This ought to be under SQL Agent in Enterprise Manager.

As far as limiting memory, Jack is correct. You need to...

What do you mean with client_host? do you mean the host name sent through the connection? That's completely arbitrary. It defaults to the windows host, but someone can fake that....

I'd also reboot and try it again. If you downloaded the media or burned it, double check this isn't a corrupt file by installing on another machine

Look at Target Server Memory for each instance. This is what each SQL instance would like to have. Chances are it will be high, but you might get a proportional...

I haven't heard of any good ones. It's a hard problem to solve visually and most vendors have avoided it.

the storage format isn't really important. The display is what is important. Display formatting is separate from how the data is stored.

AFAIK, you will have to convert this hours to...

First, always back up locally. this ought to be scheduled and not a big deal.

If you are looking to transfer them to a central location, that's a copy function. Across...

What I'd recommend is that you shrink it a little, perhaps 25GB, then the do an index rebuild. So schedule those operations together, in that order.

Once that's done, check free...

The problem with multi-connect scripts is that they sometimes fail and blow up. What I might look to do is have each server execute the query and store the results...

It will work, but this isn't a great way to store and query this data. You ought to look at refactoring this over time and storing those "slots" in another...

You might look at some of these.

http://www.sqlservercentral.com/search/?q=restore+backup&t=s

And if you've received a kick, you...

Can you define what is "slower"? Is it specific queries? Do you still have the old server and can you check specific items to see if they are really slower?

Gail...

Right click the folder, properties, select security. Look for the account or a group.

http://technet.microsoft.com/en-us/library/cc757520%28WS.10%29.aspx

blandry (4/20/2011)

---

I think what you and Andy are doing is simply great. I am a little confused because your mentoring web says that you are taking only SQL professionals...