SQL formatting tools are very useful when you have a new coding standard applied to legacy databases and applications or when there are other developers writing code outside the core...

One useful new feature for SQL Server would be something like "declarative table level DML assertions". Basically this would be sort of like a trigger that intercepts a DML operation...

Gary Varga (11/15/2016)

---

Eric M Russell (11/15/2016)

---

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

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