Nice article. One question, you mention that it would be a good idea to have the database in Snapshot Isolation mode, but you don't really give any details as...

rarara (1/16/2012)

---

i have not confirmed it yet (still awaiting access to production :angry:) but i am guessing that the issue may be related to the indexes being on typically integer...

SQL Kiwi (1/14/2012)

---

This is a good option, so long as the temptation to use a scalar function in the constraint definition is resisted. Write the condition out in full...

It really depends on how it is going to be used. This one sounds like boolean check something like:

IF dbo.IsValidSSN(@SSN) = 1

BEGIN

-- Do something

END

ELSE

BEGIN

...

Okay I looked at this a couple of hours ago and decided not to post because I'm probably not the best one to answer it, but since no one has...

Duplicate post. See this thread

This is definitely a case where I'd use a function not an SP. Phil has provided the code you'd be looking for.

L' Eomot Inversé (1/13/2012)

---

Incidentally, I'm probably in a minority here but I'm reasonably happy with using RAISERROR cause a failure to raise an alert (I would put WITH LOG on...

Have you tried restoreddatabasename.sys.servers? I believe just doing sys.servers will always hit the master database for the instance.

How have you verified that the data is truncated in the destination table? I could easily see this being a display issue in SSMS, especially with carriage returns and...

Steve Jones - SSC Editor (1/13/2012)

---

Jack Corbett (1/13/2012)

---

The only team that I'd be shocked to see in the Super Bowl would be the Broncos. They have a...

Stefan Krzywicki (1/13/2012)

---

Lynn Pettis (1/13/2012)

---

Stefan Krzywicki (1/13/2012)

---

Evil Kraig F (1/13/2012)

---

L' Eomot Inversé (1/12/2012)

---

Compared to that guy you are perfect model of tact and good manners and politeness - there's just...

I'd have to agree with Remi (Ninja's_RGR'us) on this one. I'd convert any parameters that could have multiple values to varchar(max) (or a large number) and then split them...

I wouldn't delete it. I think there is some...

Stefan Krzywicki (1/13/2012)

---

Evil Kraig F (1/13/2012)

---

L' Eomot Inversé (1/12/2012)

---

Compared to that guy you are perfect model of tact and good manners and politeness - there's just no time I have...