SQLRNNR (2/29/2012)

---

Koen Verbeeck (2/29/2012)

---

Triple heart attack this morning when I stumbled accross this:

NOLOCK is good practice

It's even marked as answer. :crying:

What's even more unsettling, is that that a link to...

Nice question.

I think the reason for the error in the second batch is that in order to do implicit conversion for arguments of an operand the compiler must know what...

GSquared (2/28/2012)

---

I keep getting hit on by recruiters looking for .NET devs (my resume specifically says "trivial experience in .NET"), data entry clerk positions (the word "data" appears on my...

Brandie Tarvin (2/28/2012)

---

Gianluca Sartori (2/28/2012)

---

Based on the number of interview questions we see on the forums lately, we could safely say that the IT job market is quite healthier than...

Nice and straightforward.

A bit easy coming so soon after another question about relative privileges of these roles, though.

LutzM (2/27/2012)

---

Evil Kraig F (2/27/2012)

---

Jeff Moden (2/25/2012)

---

This is a YouTube video...

Good question - made me think hard.

When I first looked at it I hadn't a clue what it was doing, it took me quite a few minutes staring...

There are cases where a lot of data has to be got in quickly - for exqample I might have some measuring equipment that is giving me large numbers (say...

Oh dear, one of those times where one has to guess which is the typo: was "select 2" a typo for "select 1" or was "sys.dm_service_services" a typo for "sys.dm_server_services"....

Brandie Tarvin (2/23/2012)

---

WayneS (2/23/2012)

---

Another question related to this. Tech Support people are saying that we didn't start having this problem until the server was upgraded. It went from a 4-core...

Nice easy question, nice straightforward answer and explanation.

I guess that particular collation was chosen to demonstrate that not all T-SQL is case insensitive even when the collation is ..._CI_.. ?

GilaMonster (2/22/2012)

---

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

---

Maybe another possible alternative is to disable the index and then rebuild it; some queries may time out (because the index isn't available) but nothing will...

Maybe another possible alternative is to disable the index and then rebuild it; some queries may time out (because the index isn't available) but nothing will have any lock clash...

Too many would-be DBAs sufer from calcification (of the cranial cavity, of course).

mtassin (2/22/2012)

---

tilew-948340 (2/22/2012)

---

dawryn (2/22/2012)

---

Is there a correct answer at all :hehe:

In theory you can't set or maybe you can, depends on which article you read.

In practice you can set and...