reto.eggenberger (3/29/2011)

---

Hi all

I was able to dramatically improve the procedure. But I had to rewrite the whole section. I didn't want to do this (since it's not an application we...

CirquedeSQLeil (3/28/2011)

---

It looks like somebody needs an errata submission for this book. Table variables are not entirely memory resident. They do incur IO cost and can be quite...

jeedee (3/28/2011)

---

May I ask why you prefer temporary tables above table variables?

Almost all the books I have read about SQL Server state that it's better to use table variables than...

Kiara (3/29/2011)

---

I'm going to take a moment and thank you all yet again for help that you didn't know you just provided.

I just spent about 45 minutes writing out a...

Those selects are doing a "select top 30" - do you have an order by on this query? If so, check to see if you have index(es) that will cover...

Can you post the deadlock xml information?

If you're having a romantic...

Sachin Nandanwar (3/27/2011)

---

Wayne now your explanation is exactly SPOT ON.Now the whole process has become crystal clear to me just like the cookie analogy Brandie had posted earlier.

Thanks to you...

You might also want to take a look at this BOL entry: Checkpoints and the Active Portion of the Log

Grant Fritchey (3/27/2011)

---

Jeff Moden (3/26/2011)

---

Koen Verbeeck (3/25/2011)

---

Maybe an article on why it is not necessary to maintain indexes. Who needs them right?

(but maybe again, someone picks this up not realizing...

Those videos will really explain how, internally, the log file works.

I'm going to attempt to explain it here, with the caveat that if what I say happens to be different...

Sachin Nandanwar (3/27/2011)

---

GilaMonster (3/25/2011)

---

No.

SQL writes data modifications to data pages in the data cache. It writes the log records to disk at the point the transaction is committed (or sometimes...

srividyakudumula (3/27/2011)

---

Can you take these dates and check :

@date1 = 2011-03-27 20:13:31.640

@date2 = '2011-05-27 00:00:00'

using sql server 2008

Output:

DaysHoursMinutesSeconds

6034629

can you explain me how this is correct for (hrs,mins and secs)..

May be...

No problem - I figured I'd have a little fun...

Brandie Tarvin (3/25/2011)

---

GilaMonster (3/25/2011)

---

The IO docs I referred you to should make it clear that SQL does not move data from log to data file during a checkpoint, and given...