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...

Gus has a good explanation. shared locks are compatible with other shared locks. It's exclusive locks that block, or Intent Exclusive locks.

You can see lock compatibility here: http://msdn.microsoft.com/en-us/library/ms186396.aspx

CirquedeSQLeil (4/15/2011)

---

Jeff Moden (4/10/2011)

---

How about spending more time and dollars on really cool stuff like designing a 350HP engine that gets 50MPG without batteries? You see that kind of...

It's not clear what you mean with your backup schedule. You need to specifically state when you have an NT backup running and when you have a SQL backup running...