CELKO (5/16/2012)

---

The best article on this issue is "Let's deprecate UPDATE FROM!" by Hugo Kornelis.. but it is not the only voice http://sqlblog.com/blogs/hugo_kornelis/archive/2008/03/10/lets-deprecate-update-from.aspx%5B/quote%5D

Great link, thanks for...

Good question, I learned something. I got it wrong -- I don't use ISNULL() at all, b/c it seems to me redundant to COALESCE for no added benefit. ...

peter-757102 (5/3/2012)

---

They are unable to model their data properly and often do not handle escaping well, causing errors in individual elements. But XML escaping is extremely simple and requires only...

Brent Ozar (5/1/2012)

---

rmechaber (5/1/2012)

---

So, while I've got your attention: is there any? miniscule? significant? write-performance hit in writing to a 2-drive mirror compared to writing the same data to a...

Brent Ozar (5/1/2012)

---

rmechaber (5/1/2012)

---

But I don't understand why a hardware-based RAID controller doesn't simply pipe the same data off to 2 disks simultaneously, reducing the write-time penalty to something much...

Nice article, thank you.

I have a question about the write penalty for RAID 1 (mirror). You write: "RAID 1 does have a performance penalty for writes. Each write IOP...

PaulB-TheOneAndOnly (4/29/2012)

---

Cloud computing does not refers to distributed computing - even when you can have distributed resources to source your pool of computing resources - but to the ability to...

See http://www.simple-talk.com/content/print.aspx?article=783, Item #1, "NULLS and the NOT IN Predicate".

Rich

Hugo Kornelis (4/13/2012)

---

Toreador (4/13/2012)

---

Is it definitely deprecated? The help page doesn't say so, just that the parentheses are optional for backward...

Jack Corbett (4/10/2012)

---

SQLRNNR (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

SQLRNNR (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

I just registered for the SQL Server Saturday in Waltham in May. At the end is the ubiquitous "captcha" to...

Jim I appreciate the reply, thanks.

My solution works OK, and it runs pretty fast. The slow part is the VB script to query LDAP and dump the results to...

Jim, thanks very much. I also have faced this problem. I have a nightly agent job that runs a vbs script (yeah, I know, very old school) to...

One way to deal with this is to add a NULL to your parameter's dataset (if it's a stored proc, put a UNION into it) and make sure that the...

L' Eomot Inversé (4/2/2012)

---

rmechaber (4/2/2012)

---

codebyo (3/31/2012)

---

L' Eomot Inversé (3/29/2012)

---

the solution is (a) make views schema bound and (b) test the apps properly if you change the schema. Doing either...

codebyo (3/31/2012)

---

L' Eomot Inversé (3/29/2012)

---

the solution is (a) make views schema bound and (b) test the apps properly if you change the schema. Doing either will prevent the particular...