Based on feedback, I have submitted an updated version that uses tempdb (lowercase) to compensate for servers with case sensitivity enabled. Also I have extended it to include additional columns...

I don't think you've posted the SQL select statement, but even though the final returned result is only 300k rows, just looking at the execution plan, I'm seeing table spool...

I guess everyone has their own coding standard, but I prefer to place most NOLOCK hints I see between two asterisk / backslash like this:

/* NOLOCK */

😉

I'd like to renew my Microsoft certification. I routinely work on everything from SQL Server 2005 - 2016 and Azure on a daily basis, but it's hard to believe my...

Steve Jones - SSC Editor (1/5/2017)

---

Eric M Russell (1/5/2017)

---

Broadly speaking, I'm free market and libertarian when it comes to cultural freedom and limiting government. However, when it comes to privacy...

Yeah, go under Help.. About.. menu to see the version of SSMS you're running.

null

null

It's unclear whether "City, Country" refers to the location of the employer or the employee /...

See if the solution mentioned in this post, about setting default program for .sql files, also solves your problem.

.. Installation of SSMS 2012 alongside any other existing SSMS installation, such...

I try to minimize the amount of complexity within the CATCH block of an error handler. According to MSDN there is no technical reason to explicitly close or deallocate a...

David.Poole (1/5/2017)

---

There's a challenge in balancing security with accessibility.

In the UK just because a company holds data for one purpose it cannot legally decide to use that data for any...

Similar in concept to Oracle [DUAL] table, it would be useful if SQL Server had a system tally table, perhaps containing only a single INT column with rows from -2,147,483,648...

Ugh... I've actually never worked with a server that has case sensitivity enabled....

Starting with 2016, all editions of SQL Server (including Express Edition) are essentially feature complete, so there is no reason for this new sample database to leverage only a least...