Great question to brush up on Transactions. One thing that I tend to forget about, that I brushed up on before answering, is the behavior of transaction_name parameter of...

Funny, I initially chose the Resource database cannot be moved, but then after checking my local BOL I changed to all can be moved. If you check the online...

Thanks for the question Hugo and the practical application example. Your explanation of the QOTD from two days ago provided a great refresher and helped me get it right.

In...

Doh, I choose 0 because I miscounted the number of partitions, I thought there were 21 instead of 28. Anyways, for those interested in a full executable test of...

UMG Developer (8/3/2010)

---

So it would be perfectly reasonable for a single COALESCE statement to return 5 or more different types depending on the inputs. (Well maybe not reasonable, but certainly...

Hey Scott, thanks for the article. Florian, thanks for the blog links those were great.

I'm curious how the XML method would perform when used with XML Schema Collections. ...

Good question. Here's an alternative method as an FYI.

sp_msforeachtable "DISABLE TRIGGER ALL ON ?"

chris.fauvel (6/30/2010)

---

Bradley Deem (6/29/2010)

---

I recommend using a CLR for this. Microsoft has a great example here http://msdn.microsoft.com/en-us/library/ms131056.aspx. I'm curious what the performance differences are. Admittedly, I have...

Thanks for the question, I needed to brush up on my TDE knowledge. Admittedly, the "great" caused me to pause, but I still got it right. As Hugo...

I recommend using a CLR for this. Microsoft has a great example here http://msdn.microsoft.com/en-us/library/ms131056.aspx. I'm curious what the performance differences are. Admittedly, I have not compared the...

We use SQL Assistant http://www.softtreetech.com for multiple functions among them code formatting. SQL Assistant uses formatting templates that can be tailored for each user. This allows us to...

Good question, I learned something too. For those looking to reproduce the error run the following.

select 1 as col1, col2, col3 into #mytmp

from (select 1 col1,2 col2,3 col3) myothertab

insert...

I think it is a good question, thank you. I had to read up on the identity and select into before making my choice so I learned something and...

Toreador (5/13/2010)

---

Interesting - it never occurred to me that the identity values wouldn't be available in the inserted table!

So how would you get the identity values of the rows you'd...

dgabele (5/6/2010)

---

Good question, got tripped up on:

"All nonclustered indexes include the clustered index columns in their index pages"

I thought this was not true for the mere point that a table...