Dineshbabu (1/28/2013)

---

Thanks Tom for spending your most valuable time and preparing such a detailed article.

I need to go through it twice or thrice and to test with samples to understand...

Sean Lange (1/28/2013)

---

Lowell (1/28/2013)

---

in our case, we have a config file that has the connection string information, and a single row table that contains a lot of settings relevant to...

noodles

Dineshbabu (1/24/2013)

---

Tom,

Can you explain actually what is happening in background while executing DBCC Checkident(). How identity values are maintained by sql server?

It will be very useful for everyone to understand...

wolfkillj (1/25/2013)

---

I hesitate to argue maths with one whose understanding of the topic dwarfs mine, so let's agree right off the bat that this is a discussion with the goal...

SQLRNNR (1/24/2013)

---

ChrisM@home (1/24/2013)

---

SQLRNNR (1/24/2013)

---

ChrisM@home (1/24/2013)

---

SQLRNNR (1/24/2013)

---

john.arnott (1/24/2013)

---

Am waiting with bated breath to see if "Saint" Lynn lives up to his kind and understanding reputation. Someone stumbled on an...

Dineshbabu (1/24/2013)

---

Thanks Roddy and Tom..

Tom,

Can you explain actually what is happening in background while executing DBCC Checkident(). How identity values are maintained by sql server?

It will be very useful...

crore

wolfkillj (1/25/2013)

---

Sean Pearce (1/24/2013)

---

I am getting myself confused with some simple maths :crazy:

Answer 1

Coalesce can take more than two parameters, and IsNULL takes exactly two parameters

97%

Answer 5

Coalesce takes exactly two...

Hugo Kornelis (1/25/2013)

---

L' Eomot Inversé (1/25/2013)

---

....

Or always have little enough data and low enough performance requirements to be able to eliminate nulls by using a separate table for each attribute...

But what, then, will you use for an RDBMS? I'm not aware of any that conforms to...

Good question.

I'm very surprised that more than half (113 people out of 218) so far have got it wrong. Maybe people don't use coalesce? Are that many...

Revenant (1/24/2013)

---

I would like to see the performance of an XML database on the day when the course registrations open. Not speaking about the absence of native views and sprocs...

pseudorandom chance

Nils Gustav Stråbø (1/24/2013)

---

You live in the US and need to attend a meeting in Europe. What do you do?

1. Buy a plane ticket?

2. Buy a canoo and paddle across...