Forum Replies Created

Viewing 15 posts - 2,821 through 2,835 (of 7,164 total)

  • RE: Determining a database's completed restore date and time...

    I guess I would ask...why is it so critical to know?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 9, 2012 at 4:08 pm

    #1557844

  • RE: Determining a database's completed restore date and time...

    The 2008 (non R2) docs say exactly what the 2005 docs say. I would venture a guess that 2005 - 2008 R2 hold the logical same value per the 2008...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 9, 2012 at 4:08 pm

    #1557843

  • RE: Custom Aggregate Causing Issues Sometimes

    Good to know, you're welcome. Thanks for posting back that you found a path forward!

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 9, 2012 at 2:41 pm

    #1557810

  • RE: Creating a comma-separated list (SQL Spackle)

    cs_troyk (11/9/2012)

    opc.three (11/8/2012)

    cs_troyk (11/8/2012)

    opc.three (11/8/2012)

    cs_troyk (10/29/2012)

    Not that I advocate switching to a "toy" RDBMS, but MySQL does have the GROUP_CONCAT operator which makes this type of thing a little more...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 9, 2012 at 1:45 pm

    #1557794

  • RE: avg disk queue length - how do i know how many disks i have? & their raid config.

    snomad (11/8/2012)

    Would still be interested in the answers wrt physical drives & raid config. I've tried all the Powershell commands that look likely and am afraid there may be...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 9, 2012 at 11:55 am

    #1557762

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    There is merit to your approach Jeff, namely keeping all database code transactionally consistent along with the data it operates on, but we do diverge when it comes to security....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 9, 2012 at 9:25 am

    #1557678

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    Heh, well, if the developer baked the use of xp_cmdshell directly into the T-SQL process then yes, it will take a bit of work to refactor the call to the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 9, 2012 at 8:22 am

    #1557636

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    mike.renwick-894639 (11/9/2012)

    Okay, that's interesting. So literally instead of using a cmdshell, initiate a powershell, even for running an executable off the command line?

    Precisely, and a Remote PowerShell session at...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 9, 2012 at 7:59 am

    #1557621

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    mike.renwick-894639 (11/9/2012)

    Once you've gone through the trouble of securing xp_cmdshell, setting up a proxy etc, in my view, one of its biggest benefits, is plain old simplicity.

    In our case, we...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 9, 2012 at 7:34 am

    #1557604

  • RE: Creating a comma-separated list (SQL Spackle)

    cs_troyk (11/8/2012)

    opc.three (11/8/2012)

    cs_troyk (10/29/2012)

    Not that I advocate switching to a "toy" RDBMS, but MySQL does have the GROUP_CONCAT operator which makes this type of thing a little more elegant. It's...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 8, 2012 at 11:33 pm

    #1557452

  • RE: windows server 2008R2 SQL SERVER-2008 64 bit

    Here is a pretty complete walk-through implementing the Oracle OLE DB driver on 64-bit SQL 2005 connecting to Oracle 10g via a Linked Server. I would expect the steps to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 8, 2012 at 11:20 pm

    #1557451

  • RE: windows server 2008R2 SQL SERVER-2008 64 bit

    Sorry, I am not sure why I mentioned it at all for since you are on 64-bit, I wasn't paying close attention and only picked up on "32" being discussed...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 8, 2012 at 11:16 pm

    #1557448

  • RE: Creating a comma-separated list (SQL Spackle)

    cs_troyk (10/29/2012)

    Not that I advocate switching to a "toy" RDBMS, but MySQL does have the GROUP_CONCAT operator which makes this type of thing a little more elegant. It's something to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 8, 2012 at 3:32 pm

    #1557388

  • RE: windows server 2008R2 SQL SERVER-2008 64 bit

    Have you tried using the MSDAORA provider instead of MSDASQL?

    Here is a tutorial from 2006 that should still be relevant for SQL 2008.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 8, 2012 at 9:10 am

    #1557233

  • RE: Today's Random Word!

    Ground Game

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 7, 2012 at 9:47 am

    #1556849

Viewing 15 posts - 2,821 through 2,835 (of 7,164 total)