Forum Replies Created

Viewing 8 posts - 16 through 23 (of 23 total)

  • RE: NULL Aggregates

    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...

  • RE: How to capture subfolders' path as variable and import them into database

    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. 😉

  • RE: Recovering from Bad Deployments

    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...

  • RE: Password Handling

    Steve Jones - SSC Editor (5/18/2012)


    sebmr2 (5/18/2012)


    All in all, this has worked well for us. Only problem is it leaves a physical copy of the password in the hands of...

  • RE: Password Handling

    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,...

  • RE: Server IP Address

    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...

  • RE: Server IP Address

    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...

  • RE: Audit All Permissions

    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...

Viewing 8 posts - 16 through 23 (of 23 total)