Next year, the 1st of January occurs on a Monday.  What do you want to do with the previous Sunday, which is from the previous year?

Sorry... posted to the wrong question and removed this post.  See the next post down for my answer on this posted problem.

"The damned recruiter gave the candidates both the questions and the answers.  I know this because I added a "hairball" question with a totally made up answer and when...

First, nice article.  It appears well written, is in a good "order of revelation", and includes the code in an easy to read format.  Kudos for all that and thank...

Duration only identifies how long something has been running.  It is possible that a SPID was running something with many queries for a long period and, when it finally got...

I wouldn't rebuild indexes that don't need it.  I'm...

Post withdrawn.

I've been through that with a recruiter before.  The recruiter wanted the questions and the answers so that they could do the filtering.

The damned recruiter gave the candidates both the...

With the understanding that this is nothing against you, if we posted such questions and the answers here, that would eventually render them useless in interviews because people will do...

Maybe the most efficient way to mockup 100 million rows of randomized test data would be to leverage PowerShell or Python to create text files and then BCP them...

• This reply was modified 2 years, 4 months ago by Jeff Moden.

On a personal note, I just don't understand companies that post a webinar and, to register, they REQUIRE you have to provide your phone number and, frequently, a...

Here is another way.

If you do something like this in PoSh, to create a delimited text file, it is then very easy to import the results in tabular form.

@Brian,

It's not as rare as you might think in production code if you use TempDB or a "scratch/working" database to get "balls-out" ( https://en.wiktionary.org/wiki/balls-out ) performance in code, especially when...

Thank you for the feedback, Lisa.  You're absolutely correct about the labels and fervor and, especially, the changes from what I believe the original intent was for a whole lot...

I don't and haven't used any of this sort of thing.  "Bumping" this for you and, because I'm interested, for me as well.