I've been working with SQL Server for over 15 years and I have never seen this syntax used before. Interesting behavior and something I hope to never deal with in...

I had a discussion about this sort of scenario with my boss a while back when we started getting some odd disk errors. Luckily it was on our test server...

Had a feeling I would get this one wrong. 🙂 It makes perfect sense that view server state would be redundant. Think I need more coffee! Thanks Steve.

Nice and easy way to start the week. Thanks Steve.

I really liked the setup for this question as it can be easily translated for real world scenarios. I found it fun to test the different options on the tables...

I was wondering...

Nice question. Thanks Steve.

m mcdonald (11/28/2016)

---

Interesting...

This article https://msdn.microsoft.com/en-us/library/hh231286.aspx

updated 8/1/16 does not indicate the deprecation and states

Use the Import-Module cmdlet to import the sqlps module. Specify the DisableNameChecking parameter if you want...

I've had to use similar methods to do this exact same thing before. Nice real world example Mike. There are multiple ways to do this without using the OVER() clause...

Ouch. Fair, but still ouch.

I never use XML at work so these QODs are always a struggle. Need to find some...

I only remembered this because of some index maintenance scripts that exclude heaps. Thanks for the refresher.

Should have gone with my gut. I had only HEARD of R being supported but I was being optimistic that there were more. 🙂

Excellent write up!

Cool function. Thanks for the question Steve!

Nice question. Totally makes sense to not allow a FK constraint using a temp table. I would have never thought to even attempt that. 😀