Counters can get slightly screwy in VMs if the environment, or host, is busy. I have tended to look at a few types of counters for baselining. Batches/sec, CPU%, disk...

Because I made these during baseball season.

Hmmm, would you get a new level at 1433? Or before it? Do I change on 1434 or 1435 to something else?

I liked the Cowboy's idea of a separate database. I wouldn't use a trigger, since you could hang up a transaction, but I'd either use a Service Broker Q, which...

The log might not shrink, depending on where the active portion is. You can use this to help: http://www.sqlservercentral.com/scripts/30026/

I know you mentioned a space issue, but unless your files are...

Litespeed is not built into SQL Server.

Microsoft added backup compression to SQL Server 2008, but this is not Litespeed, SQL Backup, or some other tool. It's a simple set of...

What was funny is that my son pointed out that most football games are really 2-1 (10-7) or 4-2 (21-14). Not a ton of scoring, but the values just make...

Richard Gardner-291039 (6/10/2010)

---

Football doesn't need a new name, it has one, and has had since it was invented, giving it a new one because you've hijacked it for handegg (or...

SQL Server can't work with files directly. How is the stored procedure being called? Is there some reason you can't use SSIS and then call a job to run that...

Doesn't have to be sports. It could be some significant number from math, science, history, etc.

My ring looks surprisingly like one that came out of a cardboard box of sweet, corn based, treats :w00t:

Dan, I agree with you on one part. If you put in...

Good comments, and I completely understand if someone can't run, or volunteer. I have my reasons, similar to Grant's. However make sure they are really good reasons and that you...

The answer has been corrected to show the correct database name. Good catch, and you can submit changes to BOL through Connect.microsoft.com

If the logs didn't get restored, they wouldn't be there. Sometimes people delay logs by time, so check that first.

If log shipping is running, the changes move. No way they...

I'd agree with Jason. If you just want to get data onto the web, SSRS is probably the easiest thing to do.

I mostly do this for Grant's reasons, but nice catch Elliot on missing rows in the second table.