Edit:...

Just to do a syntax confirmation, it's DBCC CHECKIDENT ( table1, reseed, 0). You have that flipped above.

Is the table truncated, or are there rows in it?

Hey Gus,

Late to the party, I know, but you referenced this in another thread and I had a curiousity. Could you discuss the 'lazy updater' component a bit more....

WayneS (11/19/2010)

---

LutzM (11/19/2010)

---

WayneS (11/19/2010)

---

:crazy::crying::Whistling:

Why me? :sick:

The...

Bwahahaha, Celko, you actually DO have a sense of humor!

This poor guy popped into existence without being properly born , committed bigamy and died twice. And you think your life...

chulheekim (11/19/2010)

---

I'm sorry. But I don't quite understand what you mean by two processes in one. The new sql server will take the old one's name once the old one...

Heh, cause Larry's cool? 😉

Yeah, I thought about that one when I saw yours, but it's a bit... graphic.

Wayne, Lutz and I are volunteering you for Larry. Well, I am, Lutz isn't convinced your current avatar is less appropriate. 😀

Denise McMillan (11/19/2010)

---

One of the final steps after upgrading SQL Server from 2005 to 2008 says to register your servers. Can someone help me with how to do that. I...

chulheekim (11/19/2010)

---

Oh I see. What you're saying is that if you move those system databases along with user databases, you don't have to manually move the logins, dts, and other...

In this case,...

:blink:

When an operator is executed multiple times as part of the query execution, the estimated row count refers to the number of rows that the optimiser estimates will be...

GilaMonster (11/19/2010)

---

Not common, but possible. Depends whether optimiser thinks that the multiple seeks + joins will be better than a table scan.

As for reading, I put the link to...

GilaMonster (11/18/2010)

---

Depending on the number of rows that need key lookups. Lookups are done one row at a time and can get very slow if the optimiser misguesses the number...

Hm, probably same as me then, somewhere on the West Coast. 🙂

On a side note, can one of you folks take a swing through this book we're calling a...