I never thought about creating a temp table using if/else statements. Seems this is a good way. Thanks for sharing 🙂

If that was not a temp table, we can...

+1 🙂

Rich Weissler (6/20/2013)

---

My memory was that Lock Escalation from row or page level always jumps to table. I assume I'm simply misinterpreting the question, but figured I'd ask/point just...

Got to learn something. I have never looked into Lock escalation mechanism in depth. Thanks Sourav:-)

Hugo Kornelis (6/19/2013)

---

To the submitter of the question: Please don't be discouraged by my harsh tone. That's just how I tick (ask any book author who has had the bad...

Easy one for the day! Thanks Bill:-)

GilaMonster (6/17/2013)

---

Lokesh Vij (6/17/2013)

---

There is nothing called "No Logging" in SQL Server...there is something called "Minimal Logging". This can be achieved by using table locking hints.

DELETE FROM TableName with...

There is nothing called "No Logging" in SQL Server...there is something called "Minimal Logging". This can be achieved by using table locking hints.

DELETE FROM TableName with (TABLOCK) WHERE id...

Nice, easy and back-to-basics question; perfect for Monday mornings 🙂

Thanks Ismail!

Stuart Davies (6/14/2013)

---

I wonder what version of SQL this was tested against - running it against my Test box (2008 R2) all goes well until INSERT INTO [dbo].[IndexTable]

VALUES(3, 'Value3')...

My eyes winked when I looked at this code

DROP TABLE [dbo].[IndexTable]

SELECT * FROM indextable

Qotd aks about "the output of select statement", but as per the code this will give "error"...

+1

Interesting question.....completely missed and gone off-track, feeling like "pressed between the hard place and rock" 🙂

Koen Verbeeck (6/11/2013)

---

I also get that. Hugo, what is your...

Thanks Mr. Reddy!

Interesting question... I was able to solve this as I have worked such issues in the recent past.