Viewing 15 posts - 1 through 15 (of 49 total)
@mmartin1 - Most of the flamers selectively read the article(s). In this case, they don't understand that you were demonstrating best practices of defense against worst practices of...
May 26, 2021 at 7:14 pm
Dang - things weren't so complicated for us ground-pounders.
February 24, 2020 at 2:26 pm
But T/SQL *sucks* as a language, and having to learn two distinct languages to do a single project is insane.
Wow. One can do nearly everything except build windows (forms)...
November 19, 2019 at 2:53 pm
Thank you, @jonfrisbee, for sharing. Based on your article, I whipped up this quickie:
declare @SepRepl char(1)=''
declare @ColNums int=3
declare @ArgValList varchar(max)='
1DISABLE_DEF_CNST_CHK0
2IMPLICIT_TRANSACTIONS0
4CURSOR_CLOSE_ON_COMMIT0
8ANSI_WARNINGS0
16ANSI_PADDING0
32ANSI_NULLS0
64ARITHABORT0
128ARITHIGNORE0
256QUOTED_IDENTIFIER0
512NOCOUNT0
1024ANSI_NULL_DFLT_ON0
2048ANSI_NULL_DFLT_OFF0
4096CONCAT_NULL_YIELDS_NULL0
8192NUMERIC_ROUNDABORT0
16384XACT_ABORT0
'
declare @RowDelim char(2)=char(13)+char(10)
,@ColDelim char(1)=char(9)
,@Sep char(1)=','
set @ArgValList=replace(@ArgValList,@Sep,@SepRepl)
set...
November 14, 2019 at 3:07 pm
Thanks, aveek22.
I, too, use NOT EXISTS but I wonder if by using a co-related subquery we are doing a performance no-no...
November 4, 2019 at 7:54 pm
November 21, 2017 at 6:08 pm
Although I disagree with your solution, I appreciate that you took the time and spent the effort to write this article.
I do agree with John Rees in how...
November 6, 2017 at 3:59 pm
I am sorry that I didn't see this last year - great article!
October 13, 2017 at 11:22 am
Also, my apologies, Jason! The first line of my previous was supposed to resemble, "Great article, I gave you 5 orbs!" Again, sorry.
August 25, 2017 at 9:38 pm
I once wrote a Powershell script to release multiple files into several environments and log messages and errors. I requires creating some text files with run-time arguments (so you don't...
August 25, 2017 at 10:17 am
Thanks for the article! I've never run into the situation, but it is very good to know.
July 24, 2017 at 3:48 pm
Thank you for sharing this. I would personally add one more step to this extensive list: take the db offline for a few months (13 ?) and wait for the...
March 10, 2017 at 2:37 pm
January 27, 2017 at 8:12 am
Viewing 15 posts - 1 through 15 (of 49 total)