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)='
1 DISABLE_DEF_CNST_CHK 0
2 IMPLICIT_TRANSACTIONS 0
4 CURSOR_CLOSE_ON_COMMIT 0
8 ANSI_WARNINGS 0
16 ANSI_PADDING 0
32 ANSI_NULLS 0
64 ARITHABORT 0
128 ARITHIGNORE 0
256 QUOTED_IDENTIFIER 0
512 NOCOUNT 0
1024 ANSI_NULL_DFLT_ON 0
2048 ANSI_NULL_DFLT_OFF 0
4096 CONCAT_NULL_YIELDS_NULL 0
8192 NUMERIC_ROUNDABORT 0
16384 XACT_ABORT 0
'
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)