Viewing 8 posts - 16 through 23 (of 23 total)
Rune Bivrin (1/7/2015)
Not fond of this question.COUNT(*) counts NULL:s, but COUNT(<expression>) doesn't.
select count(*), count(a)from (values (1), (NULL)) x(a)
And GROUPING most certainly considers NULL:s.
Couldn't agree more. Grouping identifies where a null...
January 7, 2015 at 8:12 am
If you haven't already you may want to disable xp_cmdshell, since your solution doesn't seem to require it. It can be a bit of a security risk. 😉
January 6, 2015 at 2:13 pm
I have used a number of different methods to secure a nice, safe recovery process before deployments, but there have been times where I have been given 5000+ lines of...
January 6, 2015 at 1:55 pm
Steve Jones - SSC Editor (5/18/2012)
sebmr2 (5/18/2012)
May 18, 2012 at 5:32 pm
Where I work, we require that a SQL login be created by the DBAs. We require that the password be 10 characters long and have 2 symbols, 2 upper case,...
May 18, 2012 at 8:45 am
You guys have all been a great help. I think the response that uk00121 is going to work out best for what I'm being asked to do. Since our standard...
May 2, 2012 at 2:36 pm
Forgot to mention when I posted this that I was able to find a way to pull the IP address by creating a stored procedure on each server. This option...
April 30, 2012 at 6:58 am
Thanks for posting this!
I ended up using this to create a stored procedure that I can put onto all of my servers. I then use a package to connect to...
March 29, 2012 at 2:01 pm
Viewing 8 posts - 16 through 23 (of 23 total)