Lowell (3/14/2011)

---

I sat thru a Webinar on SQL server ; the presenter was raving about how Twitter was the best thing to learn about SQL, so easy to ask a...

Have you checked out this book on PBM?

Using the DMVs in that manner is fine. You just need to know, and be aware, that they only reflect what is in cache when you run them. If stuff...

Pay no attention to the Luddite. 😀

I've been using Tweetdeck for a quite a while on both my PC and my Droid. I tried it on the iPad, but it...

It looks like you've got the basics well covered. One thing I would add for sure is the ability to capture wait states on the servers. You're going to want...

Lynn already answered. It depends on the data involved and the fill factor on your indexes. simply a count of rows and columns doesn't tell us anything. You can have...

You might want to take a look at the book "Beginning SQL Server 2008 Administration." I wrote the chapters on backup, restore, and performance tuning. It covers everything in SQL...

If the most frequently used columns to retrieve the data is all three that you listed, that might make a better choice for the clustered index. Testing is the key...

If the goal is to identify which servers or databases have a failed backup, instead of running reports, I'd suggest taking a look at setting up Policy Based Management. You...

musa 84273 (3/14/2011)

---

:w00t:thanks guys for the swift and efficient help you just gave me there, am in the process of downloading the software then give it a go, can you...

The message is pretty clear. Something is holding a lock on that file.

I used to get that at my old job when the process that copied our backups off to...

On the performance end, follow Jeff's advice. I usually do. On the coding side, you can tell just looking at it that the parameter sizes are based on the values,...

I'm misunderstanding what you're asking for here. Do you want a script that performs backups or do you want a script that reports on what backups have been completed?

so you need to attack this from two fronts. Yes, you need to work...

took a stab at it.