Are the datatypes for the sample table in the original post representative of what you have for the real table in production?

Thanks, Kev but... darn it all.  I was hoping you remembered more details because it sounds like a wicked interesting problem and I was going to set something up to...

Major congrats on the "term" to "perm" thing.  They should rename the "term" position to "Damocles".

As for migrating SSIS packages, I've discovered a sure fire way to not...

Hi all,

I'm fairly new to the dba side of things, and wondered if you could give me some pointers as to a possible solution to an issue that's occurred...

Hi

Thank you for your compliment

This will encourage me writing more article 🙂

It's good question about performance in large dataset when using recursive group

It will be nice to make some...

p.s.  The questions I asked above (and possibly more) would be the kind of questions (obviously not identical because there were no deletes) that I would have asked an interviewer...

Estimating the space requirement for database restores from the backup size can be really misleading.  One of the largest problems in this area is that free space in...

This is a nice script and I thank you for taking the time to post it.

Just a couple of thoughts, though.  Your article states...

This query can be helpful for knowing...

Well, I'm becoming a happier camper...

Sunday I officially flip from being a "Term" appointment (and thus needing to essentially compete for my job every couple years,) to a "Perm"...

Missed this before... + 1 Billion!!!

I ran code that Paul posted on the Azure Feedback.  While I understand the angst there and a lot of people will argue with me about it, I would attribute...

Re Jeffs comment Did the identify any limits or extenuating circumstances?

I was tasked with importing over 15000000 rows of data, first having to delete a massive amount of existing...

And... was that all there was to the question?  Did they identify the source of the data?  Did the identify any limits or extenuating circumstances?

Better than that, did you have...

Hat's off to you.  I don't use SSRS but this looks like a really well thought out article with the correct order of revelation and all the right screen shots.

The...

To add something,

Its recommended to have all the tempdb data files the same size, that's why Microsoft have added a feature in which not only one file but all...