It is alarming to think that Spotify could (inadvertently or even willingly) fill the hard disk of 40 million users worldwide.

However, this can be mitigated by setting "Maximum Database Size"...

Surprise!

Too late, it's sitting in the 'Active Threads' queue, so everyone...

...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.