Viewing 15 posts - 2,041 through 2,055 (of 6,041 total)
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 15, 2016 at 10:10 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 15, 2016 at 8:56 am
Gary Varga (11/15/2016)
Eric M Russell (11/15/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 15, 2016 at 8:36 am
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"...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 15, 2016 at 8:16 am
Surprise!
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 15, 2016 at 8:06 am
Eirikur Eiriksson (11/15/2016)
...You better start a new thread with your question, not many are going to be watching this one.
😎
Too late, it's sitting in the 'Active Threads' queue, so everyone...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 15, 2016 at 8:02 am
...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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 15, 2016 at 7:41 am
If the goal is the prevent stored procedure recompilations, then I'd suggest using table variables instead of temporary tables.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 14, 2016 at 3:12 pm
lassell (11/14/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 14, 2016 at 3:06 pm
Gary Varga (11/14/2016)
Eric M Russell (11/11/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 14, 2016 at 12:00 pm
David.Poole (11/12/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 14, 2016 at 9:25 am
SQL Server, the full stack multi-engine platform, is evolving into a one-stop shop for all your database needs.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 14, 2016 at 8:56 am
Also, you can google "online t-sql formatter" and try out the features of various implementations with downloading and installing anything.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 11, 2016 at 3:23 pm
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 11, 2016 at 2:09 pm
Jeff Moden (11/11/2016)
Eric Mamet (11/10/2016)
Ideally, it should be something working in both SSMS and Visual Studio (SSDT) as we use...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 11, 2016 at 1:54 pm
Viewing 15 posts - 2,041 through 2,055 (of 6,041 total)