Hi Lynn

Very rightly pointed out that my table is actually a heap, without clustered index (I should have been more specific earlier). Just to add on, the transaction table does...

Thanks Naseer...a very easy question to conclude this week 🙂

Hi Lynn

I am using table locking option TABLOCK, this support minimal logging.

Cool...good question Naseer. Thanks for posting.

Sean Lange (9/18/2012)

---

Nice back to basics question. I am astounded that at the time of my posting there are 111 (14%) that answered this wrong. I can understand those that...

Hey Stewart/Hugo

Taken your words. Will be more specific with the explanation hereon.

Thanks...

Got into the trap...thought query may return 1 or 2....overlooked the primary key factor :w00t:

A good question though. Thanks for posting.

Glad to know that Raghu..sometimes we are so engrossed in the perplexities of complex issues...

Please be clear and specific. If you are new to this forum, its worth looking at best practices to...

You are welcome Avi:-)

You are welcome Divine 🙂

Me too got this question wrong...

Took a wrong turn on...

Wonderful question Divine. I would recommend taking a look at the following link as well:

http://msdn.microsoft.com/en-us/library/ms178062.aspx

It talks about Media Sets, Media Families, and Backup Sets in SQL Server.

Raghavendra Mudugal (9/14/2012)

---

demonfox (9/13/2012)

---

Lokesh Vij (9/13/2012)

---

An easy one for Friday!

I love using Rollback [after specified time].....to warn developers to log-off from the database otherwise they will automatically be logged-off...

An easy one for Friday!

I love using Rollback [after specified time].....to warn developers to log-off from the database otherwise they will automatically be logged-off after specified time 🙂

Thanks for...