Raghavendra Mudugal (1/23/2013)

---

Koen Verbeeck (1/23/2013)

---

I'd like to see the performance of the XML solution.

Also, I would think the structure of your website is known, so a relational model is preferred.

Curious...

Happy New Year

Koen Verbeeck (12/11/2012)

---

Are you sure a log backup is needed? Quoting from BOL:

Typically, you need to take at least one log backup on the principal database. However, a log backup...

Lokesh Vij (12/7/2012)

---

What would happen, if the current user is mapped to any one of the two schema's by default? Last statement would always throw an error!!

As this option was...

Hugo Kornelis (11/28/2012)

---

Dave62 (11/28/2012)

---

I came across this odd behavior in SSMS the other day when I was looking at estimated execution plans and thought I'd share it with the community.

Sorry...

Koen Verbeeck (11/28/2012)

---

The only correct answer is 0.

There are 8 statements in the estimated execution plan, but no queries.

From BOL:

A query is a request for data that is stored in...

Happy Thanksgiving.

COUNT carefully the turkeys!

Ross.M (11/1/2012)

---

honza.mf (11/1/2012)

---

Ross.M (11/1/2012)

---

... however for the sake of understanding string comparisons, we have no use for knowing how many characters are between 0 and Z, we just need to...

Ross.M (11/1/2012)

---

... however for the sake of understanding string comparisons, we have no use for knowing how many characters are between 0 and Z, we just need to know the...

derek.colley (11/1/2012)

---

I'm afraid this question was just too obscure for me. It's a good question, sure, but why would I need to know this or reference it in any...

My first estimate was something near 75 (10 digits, 26 uppercase, 26 lowercase) but then I remembered the accents and found a table.

Toreador (10/23/2012)

---

In the UK at least, such processes work entirely in the bank's favour. Transaction...

WayneS (10/11/2012)

---

honza.mf (10/11/2012)

---

Hugo Kornelis (10/11/2012)

Transactions (that's what "TRAN" is short for) are primarily used to ensure that a series of statements that form a single unit of work are either...

Hugo Kornelis (10/11/2012)

Transactions (that's what "TRAN" is short for) are primarily used to ensure that a series of statements that form a single unit of work are either completely executed,...

Hugo Kornelis (10/10/2012)

---

You can read about TRY ... CATCH here: http://msdn.microsoft.com/en-us/library/ms175976.aspx

In T-SQL, "Try Except" is...