Easy and nice question to end the week. Thanks!

Easy one. Revision of basics 🙂

Thanks Ron!

Nice Question. Thanks!

Very nice question Tom. Learnt something new today:-)

Ah! Easy one to start the week. Thanks Ron 🙂

Sean Lange (1/4/2013)

---

SQLRNNR (1/3/2013)

---

I have to disagree with the correct answer(s). The question asks for 4 correct answers yet 5 are presented. This causes a bit of a...

Happy New Year to all 🙂

Nice and easy question Dave.

Thanks Ron for posting the correct link. I was about to do the same 🙂

Thanks Ron for another one on SS-2012. Keep them pouring 🙂

Very good question. Thanks!

vinu512 (12/26/2012)

---

This would do what you are looking for:

Select p.Month, SUM(p.cramount) As Credit, SUM(q.dramount) As Debit From

(

Select b.voucherno, DATENAME(MM, a.dt) As Month, SUM(b.cramount) As cramount From voucher As...

As per the requirements, here is my query:

SELECT Month(v.dt) [Month],

Sum(vc.cramount) Credit,

Sum(vd.dramount)...

Eric M Russell (12/25/2012)

---

The reason why SELECT INTO <new table> is faster than INSERT INTO <existing table> is because SELECT INTO doesn't transaction log the data pages being inserted. In...

Bhuvnesh (12/25/2012)

---

Eric M Russell (12/25/2012)

---

The reason why SELECT INTO <new table> is faster than INSERT INTO <existing table> is because SELECT INTO doesn't transaction log the data pages being inserted....

There are two ways (apart from BULK insert) which creates minimal transaction logs

1) SELECT INTO

2) using TABLOCK hint