Forum Replies Created

Viewing 15 posts - 5,926 through 5,940 (of 7,164 total)

  • RE: How to catch error messages

    Yes there are certainly ways. SSIS error handling and logging is robust but I have found the bar to be high to get a simple solution in place...which I guess...

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

    June 22, 2011 at 8:55 am

    #1342461

  • RE: Does anyone have a good reason to run xp_CmdShell?

    Jeff Moden (6/21/2011)

    BWAA-HAAA!!!! I just got this very funny image of a kid picking up the bazooka backwards and Dad's brand new car is right behind him and... boy,...

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

    June 22, 2011 at 7:42 am

    #1342379

  • RE: Help with formating a QUERY ???

    opc.three (6/21/2011)

    Yes it can be done using a Cross Tab Query or the PIVOT operator.

    The fact that they are aggregations is a distraction. Concentrate on the shape of the resultset,...

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

    June 22, 2011 at 7:30 am

    #1342369

  • RE: Indexing: How will you index this query??

    GilaMonster (6/22/2011)

    Both of them.

    🙂

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

    June 22, 2011 at 6:40 am

    #1342340

  • RE: Error in pulling Chinese Characters in Table

    Knowledge Hunter (6/21/2011)

    Even when inserting data in the table manually without 'N" as prefix to the data, the data inserted is junk character. (It is not possible to use N...

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

    June 22, 2011 at 6:38 am

    #1342338

  • RE: Indexing: How will you index this query??

    Not a picture...please provide the actual execution plan saved as a .sqlplan file.

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

    June 22, 2011 at 6:05 am

    #1342324

  • RE: Which one is better select * into # temp from tableA Vs create #temp table insert into...

    Craig Farrell (6/22/2011)

    Yeeps, sorry Orlando, I fear you may have taken me the wrong way. I meant to add to your commentary, not abuse it. Apologies.

    No...

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

    June 22, 2011 at 5:59 am

    #1342321

  • RE: Does anyone have a good reason to run xp_CmdShell?

    Craig Farrell (6/22/2011)

    For anyone following along with the Level II masquerading as a III, here's my next hint for research:

    With Sommarskog's help

    Hey, I resemble that remark 😀 and if that's...

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

    June 22, 2011 at 5:38 am

    #1342318

  • RE: Does anyone have a good reason to run xp_CmdShell?

    Craig Farrell (6/21/2011)

    opc.three (6/21/2011)

    I won't let the cat out of the bag as to how I think you're planning to create the misdirection necessary to accomplish a secure xp_cmdshell environments...

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

    June 21, 2011 at 10:31 pm

    #1342225

  • RE: Does anyone have a good reason to run xp_CmdShell?

    Jeff Moden (6/21/2011)

    opc.three (6/21/2011)

    I won't let the cat out of the bag as to how I think you're planning to create the misdirection necessary to accomplish a secure xp_cmdshell environments...

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

    June 21, 2011 at 10:29 pm

    #1342224

  • RE: Which one is better select * into # temp from tableA Vs create #temp table insert into...

    Craig Farrell (6/21/2011)

    opc.three (6/21/2011)

    Whether supplying an explicit column list or a * SELECT...INTO generates a table with no clustered index, i.e. a HEAP. If you're managing large quantities of data...

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

    June 21, 2011 at 10:09 pm

    #1342220

  • RE: Does anyone have a good reason to run xp_CmdShell?

    Jeff Moden (6/21/2011)

    opc.three (6/21/2011)

    Jeff Moden (6/21/2011)

    Craig Farrell (6/20/2011)

    I know I'm personally horrified at the idea of having my devs write up their own xp_cmdshell with EXECUTE AS permissions as a...

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

    June 21, 2011 at 5:02 pm

    #1342180

  • RE: Which one is better select * into # temp from tableA Vs create #temp table insert into...

    sqldba_icon (6/21/2011)

    GSquared (6/21/2011)

    I prefer Select Into, because in performance tests I've done it's slightly faster, and because it will preserve DDL changes in the source Select between iterations.

    E.g.: If you...

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

    June 21, 2011 at 4:22 pm

    #1342165

  • RE: Does anyone have a good reason to run xp_CmdShell?

    Jeff Moden (6/21/2011)

    Craig Farrell (6/20/2011)

    I know I'm personally horrified at the idea of having my devs write up their own xp_cmdshell with EXECUTE AS permissions as a proc for usage...

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

    June 21, 2011 at 3:50 pm

    #1342159

  • RE: batch insert question- One Transaction?

    Heh, yeah, tell 'em I sent ya 😉

    Out of curiosity brought about by something you said about "bulk", what's the client language? There may be a better way than any...

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

    June 21, 2011 at 2:58 pm

    #1342146

Viewing 15 posts - 5,926 through 5,940 (of 7,164 total)