That estimated cost isn't in real "seconds." It's just a number used for the internal calculations.

You just need to run an ALTER TABLE script. Here's an article from Microsoft on how to do it.

I don't agree that it's spam, but you're right, no sense in reinforcing any kind of clicks to bad info like that.

Why run snapshots over and over. What purpose is it serving?

Just bumped by Gus on the Total Points board. Still behind him on the forum posts count.

Tough situation. I can't tell you that you made the right call. But, if you put yourself in what you think is the right situation, then you did the right...

enrique.mallon (7/12/2014)

---

Hi tommy

Such condition arises when SQL Server database becomes deadlock and you are unable to perform action or transaction on it. It means that your SQL database got...

hoa.nguyen 64423 (7/11/2014)

---

Thank you everyone for your time and the good comments. They are all valid.

At this writing, I have 2 environments DEV and QA. In QA...

Adding the file is going to be a logged operation. The restore will include it.

Deadlocks are fundamentally a performance problem. What's the situation with the server? How are the waits and queues? Are you running out of memory, I/O, or CPU? You may need...

GilaMonster (7/11/2014)

---

Not really, because SQL stores the columns on the page that way no...

If you were down to trying squeeze the last microsecond of performance by increasing the efficiency of performance, yes, this would matter. You would want the fixed length columns stored...

Take a look at the book in my signature line. Get the 2012 version. It's still applicable to 2008 and it fixes some errors.

You have to restart. There's no way to recover in place once the chain is broken.

Generally you need to have the latest version of SSMS to access the latest version of SQL Server. You can access earlier versions from the latest one, but I've always...