...Have you ever updated every row of a table to the same value because of a poorly written query? I have. A temporal table would have been handy in this...

If the goal is the prevent stored procedure recompilations, then I'd suggest using table variables instead of temporary tables.

lassell (11/14/2016)

---

Thanks guys, Sorry for the delay in replying but the country I live in has suffered a few 'shakes' recently and as a consequence I've had an intermittent internet...

Gary Varga (11/14/2016)

---

Eric M Russell (11/11/2016)

---

...My belief is that IoT (at least at the consumer product level), Big Data (with the exception of big science applications like weather and genetics),...

David.Poole (11/12/2016)

---

Some years ago I went through an HR initiative where we graded ourselves on our skills with the aim of various employees being able to tap into the expertise...

SQL Server, the full stack multi-engine platform, is evolving into a one-stop shop for all your database needs.

Also, you can google "online t-sql formatter" and try out the features of various implementations with downloading and installing anything.

http://poorsql.com/

Starting with SQL Server 2012, we can create user defined server roles.

For example:

CREATE SERVER ROLE [ReadOnlyAdmin];

Next grant all the necessary permissions and additional role membership to [ReadOnlyAdmin], and then add...

Jeff Moden (11/11/2016)

---

Eric Mamet (11/10/2016)

---

Can someone recommend a (free?) tool to format TSQL Code.

Ideally, it should be something working in both SSMS and Visual Studio (SSDT) as we use...

homebrew01 (11/10/2016)

---

Doesn't cost any money ?? $10,000 to...

skeleton567 (11/11/2016)

---

Eric M Russell (11/11/2016)

---

Despite working in IT as both a software developer and database administrator, I'm not a big fan of consumer gadgets or other technology that involves a...

If you don't like the 2 year cycle of releases, you always just sit every other one out. However, I'd recommend v2016.

Despite working in IT as both a software developer and database administrator, I'm not a big fan of consumer gadgets or other technology that involves a lot of user interactivity....

homebrew01 (11/10/2016)

---

I'm sure it's a long list, but what are the "Top 10" list of improvements I can take to management to help justify spending the $$ to upgrade ??...

Asking your customers to restore a .BAK file or attach an .MDF file will not be possible if they are not on the same version of SQL Server. For that...