Viewing 15 posts - 31 through 45 (of 49 total)
It is interesting to see cursors compared to GOTO statements, as both are bad primarily because they make it easy to be a lazy programmer, instead of encouraging better habits....
June 1, 2015 at 9:00 am
I paid for my own TechNet once, very early in my career; but otherwise, I've been lucky that employers have usually bought me any software tool I can justify.
But outside...
February 19, 2015 at 8:33 am
This all brings up the question of copyright of work. If done on company time then they will claim it, however, it is a generic script then there is the...
February 13, 2015 at 8:11 am
Steve Jones - SSC Editor (2/12/2015)
Brian J. Parker (2/12/2015)
February 12, 2015 at 2:30 pm
Gosh, I'd be surprised if any DBA or database developer did NOT have a folder full of T-SQL scripts they carried from job to job. Common metadata queries, a few...
February 12, 2015 at 10:44 am
A few changes and tools, but the indispensable one I'd recommend to almost everybody: make Ctrl+F1 sp_helptext. (Tools > Customize, "Keyboard")
I appreciate this thread because I knew about and use...
January 23, 2015 at 8:14 am
A few changes and tools, but the indispensable one I'd recommend to almost everybody: make Ctrl+F1 sp_helptext. (Tools > Customize, "Keyboard")
I appreciate this thread because I knew about and use...
January 23, 2015 at 8:13 am
Eric M Russell (1/21/2015)
January 21, 2015 at 11:24 am
Steve Jones - SSC Editor (1/21/2015)
Brian J. Parker (1/21/2015)
January 21, 2015 at 10:51 am
This particular law may or may not help, but arguably legislation can make a difference. A culture of 40 hour weeks would have seemed like a blessing once (not to...
January 21, 2015 at 8:58 am
lduvall (10/31/2014)
So, my...
October 31, 2014 at 10:17 am
I had the same problem. Besides a large enough tally table, I think you need to change "Number BETWEEN 2 AND 200" to "Number BETWEEN 2 AND 1000" for three-digit...
April 29, 2014 at 10:30 am
This is a feature added in SQL Server 2012; that might be the problem for pawel.sowka.
March 24, 2014 at 3:58 pm
Thank you for sharing this! I created a T-SQL improvement to sp_help_revlogin to do several of these things, but not all of them. It's incredibly useful and I'm surprised Microsoft's...
November 26, 2013 at 9:07 am
Thank you for sharing this! Perhaps I misunderstand intent, but if you are trying to move small amounts of data, may I suggest my script to generate INSERT statements (with...
November 14, 2013 at 8:42 am
Viewing 15 posts - 31 through 45 (of 49 total)