The input data has been fixed.

If this article was something you already knew, then it wasn't for you, and I'm not sure it makes sense for you to rate it...

SanDroid (2/7/2011)

---

Steve Jones - SSC Editor (2/7/2011)

---

I never said I would fire someone that asked for a raise twice. You totally misread that. I said that if you were soliciting...

Also be aware that the execution plan adds up to 100%, so something will take up resources. If you have the index on fields that the update can use, then...

Not sure what's recovered. You'd have to look further up in the log, but this instance has two startup procedures that are being executed. You can mark a stored procedure...

Doh!

It's here: http://twitpic.com/3x4s18

Brandie Tarvin (2/7/2011)

---

Oh, I...

VirtualBox.

First, do you have database files and log files separate? If so, you would typically want to back up to the log file disk, not the data file disk.

If not,...

You can just set a new size for the .mdf files with ALTER Database

USE master;

GO

ALTER DATABASE AdventureWorks2008R2

MODIFY FILE

(NAME = test1dat3,

SIZE =...

Is there a schedule set for the job? If you look in the properties, what does it say?

Is SQL Agent running?

Look at Pivot or search for crosstab queries. That's what you are trying to do.

Note that these aren't very efficient, so as long as this isn't a large set of...

kenny-892481 (2/7/2011)

---

I'm confused Steve. You would want to fire one of your employees if they asked for a raise more than once, but you would want an employee that lied...

Brandie has a great point. What you have written will move everything, but you ought to have error handling.

I might also write a "check" routine that verifies the counts of...

Thanks, everyone, and SQL Saturday #60 was great. I enjoyed Jeff's session, and conversation. Ron (bitbucket) made the hotel deals and helped ensure the event ran very smoothly, and gave...