Forum Replies Created

Viewing 15 posts - 5,461 through 5,475 (of 7,168 total)

  • RE: Dynamic CTE?

    PS This could also be done, albeit with a lot more coding and testing, using a variation of the "Quirky Update" or the CLR (as noted) to get you a...

  • RE: Dynamic CTE?

    It isn't pretty (in form or potential performance impact) but it gives the proper result.

    CAUTION: a query like this is laced with costly sorts and loops (hidden RBAR) and can...

  • RE: Bulk Update

    Some inline comments...

    bpw (7/16/2011)


    Hi,

    This is my first post here - I’m hoping someone can give me some advice. I've included the procedure code along with definitions and execution plan, but...

  • RE: Query Help

    Note that osql.exe is deprecated as of SQL 2005. The recommended replacement is sqlcmd.exe. Consider using sqlcmd for new development. The command line options are very similar so converting to...

  • RE: Full, Diff & Inc backups in a log shipping environment

    chris.downes (7/18/2011)Is it possible to use log shipping for reporting and still tun transaction log backups on the prod server?

    The point is, you don't need to take additional log backups...

  • RE: Log query errors

    You can setup a trace to do that. Look into the Errors and Warnings Event Category:

    http://technet.microsoft.com/en-us/library/ms177448.aspx

  • RE: Copy from a folder to an other

    abdielmomo (7/18/2011)


    Please,

    Is there any transact SQL Command which allows me to copy files from one folder to another on the same computer?

    Thanks!

    I would recommend PowerShell for this task. Chances...

  • RE: Error while creat the text file using SQL server 2005

    To put it another way, are you sure you (or your client) chose the right tool for the job?

    If not SSIS, then why not bcp, sqlcmd or even PowerShell via...

  • RE: Hi to all

    In order for a person to retrieve the Actual Execution Plan the login must be granted the SHOWPLAN permission. sysadmin's, database owners and members of the db_owner role have this...

  • RE: Filtered OUTPUT Clause

    Option 2...down the drain. I completely spaced on the limitation re: triggers on the target table.

    Option 4: issue two inserts where neither uses the OUTPUT clause

    - Insert 1: insert into...

  • RE: A Little Interviewing Advice

    TravisDBA (7/17/2011)


    I agree that being able to write decent queries and to read others' code is #2 on the list of talent for System DBA's... it's just a mandatory item...

  • RE: Create View- T-SQL Syntax error

    Jeff Moden (7/17/2011)


    opc.three...

    IIRC, in the "CREATE or REPLACE" in Oracle (and, I believe, in the ANSI standard), the "REPLACE" is equivalent to an "ALTER".

    You're right. IMHO though REPLACE is ambiguous...

  • RE: Filtered OUTPUT Clause

    SQLkiwi (7/17/2011)


    I forgot you could use OUTPUT in a derived table but I think there are some restrictions in some scenarios (Adam Machanic's blog on MERGE comes to mind).

    There are...

  • RE: SSIS: What's New in Denali

    Welsh Corgi (7/17/2011)


    opc.three (7/17/2011)


    Reading Jamie's blog has sent my brain's CPU to 100% at times (so has reading Paul's for that matter) but my computer has never had an issue...

Viewing 15 posts - 5,461 through 5,475 (of 7,168 total)