Aksheela,

Nice description of the problem and the code, thanks. However, the one thing you left out was the delete statement, so I have a few questions.

Do your deletes occur...

*sighs* Can't really blame you Grant.

GSquared (2/9/2011)

---

It's a pretty standard mindset and handling. Fits right into the behavior-prediction algorithms I was writing about last week. There are two...

nzngh (2/8/2011)

---

Your comment about Job for Bob is really strange to me for it never ever occurred to me to work in a company whose their people compromise a...

Lynn Pettis (2/8/2011)

---

One...

Tom.Thomson (2/8/2011)

---

I've joined...

nadabadan (2/8/2011)

---

... Snip ...

Computer science theory background? What the hell is bubble tree logic? Hardware buffer usage? You are just writing nonsense to sound intelligent. The algorithm I was referring...

One important thing I didn't see mentioned here as I breezed through was Disk I/O and SAN organization.

For example, your TempDB is about to be shared to multiple reporting applications,...

*sighs* I've failed sainthood. I leave this gentleman in your hands, he can't even debate well, and my patience is stretching to the unprofessional realms.

http://www.sqlservercentral.com/Forums/Topic1059167-145-1.aspx

nadabadan (2/8/2011)

---

The only reason I'm up-in-arms is because others( you and GSquared mainly ) are up-in-arms about a simple interview question. To me, this interview question is a simple benign...

nadabadan (2/8/2011)

---

The interviewer wasn't asking what is the best or even a good way to find the min/max value. When you are forced to use a CASE statement, you have...

A way we used to deal with this on some critical systems, specifically the reindexing, was object swaps.

Copy the table in question, make sure it's auditing so you can re-process...

nadabadan (2/8/2011)

---

Right and if you have 10 years of experience with T-SQL, this question would have been a breeze and you would understand the REASON for the question. And since...

:Wow::blink:

Nice idea Lowell... faster by a magnitude of nearly 10. (Edit: Heh, whoops, sorry. Faster 10x at the CPU level, 50% of time at the final timing. I...

nadabadan (2/8/2011)

---

Or how about if you want to see how much a person REALLY knows about T-SQL or want to see their thought process. I doubt these people actually use...

Well, you could open...