Thanks for posting this question. I would consider it a more subjective question since it could be used to judge your skills, a best guess taken and then read...

ScottPletcher (7/10/2012)

---

Jeff Moden (7/9/2012)

---

ScottPletcher (7/9/2012)

---

SELECT

(ident - 1) % 3,

MAX(CASE WHEN (ident - 1) % 3 = 0 THEN value ELSE 0 END)...

Can you post the full table definition? If that one column is all that's in the table there's no reliable way to do this. I'm making the assumption...

Two thoughts. Is the DB in use at the time the copy is run? If it's using nolock (or something is disabling the foreign key) that would explain...

Hugo Kornelis (7/9/2012)

---

And that is really a loss. I can understand yoour feelings. Sometimes, the comments are fair. Sometimes, they are far-fetched....

It depends on what application the server is running. I work at a hospital so some apps are extremely critical and are set up in an HA configuration. ...

Drenlin (6/28/2012)

---

I have been looking at log backups this week so I was glad for this question to confirm what I have been reading and my understanding.

However, there was no...

I don't expect this to be a major improvement but you never know. Instead of checking the count you can just check to see if something exists:

WHILE EXISTS (select...

I actually just dealt with this in a slightly different way. We're doing a purge on a large DB and the app owner wanted a quick way to roll...

I haven't used application roles before. Hopefully someone that has will take a look and help out.

Take a look at the last two posts. Can you answer those questions? And what I said applies to Server 2008 too, not just Win7.

GSquared (6/27/2012)

---

There's a big difference between telling a user "don't try to service your TV yourself, there are parts in there that can kill you, and you don't know which...

GSquared (6/26/2012)

---

Imagine if you bought a toolkit from, for example, Sears, and it had some tools in it that you had never seen before. So you ask them what...

Paul Randal (6/25/2012)

---

Be careful though because SQL Agent will only capture the first X bytes of the output (unless that changed in recent versions). You may want to go the...

Toreador (6/25/2012)

---

I took a risk and made the correct assumptions, so guessed the right answer 🙂

But strictly speaking, the answer should be "false, false".

A Temporary Table can have primary keys...