Forum Replies Created

Viewing 15 posts - 136 through 150 (of 458 total)

  • RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

    Jeff Moden (10/7/2012)

    rmechaber (10/6/2012)

    Hi, Jeff, thanks very much for digging up and posting this. I think I follow the logic here, but I'm getting errors.

    First off, I did enable...

    November 5, 2012 at 6:19 pm

    #1556263

  • RE: Want to add Recordcount in Flat File output

    I had a similar requirement to create a header line in a CSV output file, where the header line contained a total record count, sum($), etc.

    I wound up dumping the...

    November 2, 2012 at 10:12 am

    #1555577

  • RE: Table Variables

    Nils Gustav Stråbø (10/19/2012)

    Aaaaarg!!! Got it wrong because of the unclustered index options.

    I know that SQL Server enforces unique constraints by creating unique indexs, but I wasn't sure if this...

    October 19, 2012 at 6:34 am

    #1550833

  • RE: Windows Server 2012 and Hyper-V

    Brandon Leach (10/18/2012)

    rmechaber (10/18/2012)

    Brandon Leach (10/18/2012)

    We have learned however that in a virtual environment best practices are even more important. It's important to build the VM with performance...

    October 19, 2012 at 6:16 am

    #1550828

  • RE: Windows Server 2012 and Hyper-V

    Brandon Leach (10/18/2012)

    We have learned however that in a virtual environment best practices are even more important. It's important to build the VM with performance in mind. ...

    October 18, 2012 at 7:39 am

    #1550485

  • RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

    Hi, Jeff, thanks very much for digging up and posting this. I think I follow the logic here, but I'm getting errors.

    First off, I did enable xp_cmdshell on the...

    October 6, 2012 at 4:34 pm

    #1546451

  • RE: What SQl Agent Jobs Should I set up?

    You're welcome, and thanks for replying!

    Nadrek's suggestion to look for untrusted FK constraints is a very good one. An untrusted FK constraint will be a performance killer, and they...

    October 4, 2012 at 7:02 am

    #1545510

  • RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

    Jeff, I (and many others) have said it before, and I'll say it again: your generosity is much appreciated! Thanks, I'm looking forward to digging through this!

    Rich

    October 4, 2012 at 6:00 am

    #1545467

  • RE: DECLARE - 1

    bitbucket-25253 (10/3/2012)

    rmechaber (10/3/2012)

    L' Eomot Inversé (10/3/2012)

    rmechaber (10/3/2012)

    Per BOL:

    length

    Is an optional parameter of nchar, nvarchar, char, varchar, binary, or varbinary data types. For CONVERT, if length...

    October 3, 2012 at 12:06 pm

    #1545118

  • RE: DECLARE - 1

    L' Eomot Inversé (10/3/2012)

    rmechaber (10/3/2012)

    Per BOL:

    length

    Is an optional parameter of nchar, nvarchar, char, varchar, binary, or varbinary data types. For CONVERT, if length is not...

    October 3, 2012 at 10:57 am

    #1545070

  • RE: DECLARE - 1

    Kevin Gill (10/3/2012)

    rmechaber (10/3/2012)

    The CAST('xyz' AS VARCHAR) works the same as the initial DECLARE: if no length is specified for a VARCHAR, it defaults to 1.

    Rich

    But that suggests that running...

    October 3, 2012 at 8:33 am

    #1544956

  • RE: DECLARE - 1

    Dave62 (10/3/2012)

    kapil190588 (10/3/2012)

    how Casting or converting a string literal behaves returning 30 characters.

    this is the only thing on which am stuck..

    plz explain

    I think it has to do with "SET...

    October 3, 2012 at 7:27 am

    #1544905

  • RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

    Jeff Moden (8/24/2012)

    rmechaber (8/24/2012)

    Jeff Moden (8/23/2012)

    As a bit of a sidebar, I use XP_CmdShell to run PowerShell. 😀 It's quite safe to do if the system is properly locked...

    October 3, 2012 at 6:19 am

    #1544850

  • RE: What SQl Agent Jobs Should I set up?

    Well that's pretty open-ended....

    In no particular order, here's some of what I like to run:

    > You list "backups", but that will likely be at least 3 different jobs/schedules for...

    October 2, 2012 at 7:51 am

    #1544383

  • RE: The Importance of Validating Backups

    Paul Randal (9/28/2012)

    It's nothing to do with DBCC - it's the try/catch eating the errors being printed. No idea how to use that correctly - it has some weird behavior.

    Nothing...

    September 28, 2012 at 12:45 pm

    #1543588

Viewing 15 posts - 136 through 150 (of 458 total)