Forum Replies Created

Viewing 15 posts - 166 through 180 (of 5,685 total)

  • RE: SQL DBA high ended question (5+ years’ experience)

    5 years experience? I expect to hear stories, end to end solutions. I expect to hear what blew up under their fingertips when the rolled something to production...

    August 5, 2014 at 12:58 pm

    #1735347

  • RE: SSIS - Dynamic XML Configuration File Path while running the Package

    Lynn Pettis (8/1/2014)

    You could also use a system variable to contain the same information regarding the location of configuration files. We went with the XML file as it was...

    August 1, 2014 at 5:21 pm

    #1734562

  • RE: Get next primary key without identity

    A couple of questions.

    You're in SQL 2014, and want to select an INT. Have you looked at SEQUENCE? It does exactly that.

    If you want to lock rows for...

    August 1, 2014 at 3:17 pm

    #1734544

  • RE: SSIS XML import

    dan.james (8/1/2014)

    I dont generate them. I am using the XML source and it generates all the child ID's automatically. However running the same import again (say 400 records) it reuses...

    August 1, 2014 at 3:07 pm

    #1734543

  • RE: Tuning a query that takes 60 minutes to run,

    churlbut (7/31/2014)

    I do know one thing, I would rather work with someone who is willing to try new things and consider new ideas than someone who is adamant they are...

    July 31, 2014 at 2:00 pm

    #1734248

  • RE: Are the posted questions getting worse?

    Now now, there are cases where I can feel the frustration of the OP practically shouting "Just tell me the damned keywords and I'll look it up on my own!"...

    July 30, 2014 at 6:37 pm

    #1733887

  • RE: using IDENTITY INSERT

    ipisors (7/30/2014)

    Because the documentation on IDENTITY INSERT states that you have to explicitly pass the value to insert into PK field.

    Not true?

    Not true from the way you're reading...

    July 30, 2014 at 6:32 pm

    #1733885

  • RE: using IDENTITY INSERT

    ipisors (7/30/2014)

    Craig, that looks like the same solution/examples I already had.

    So you're passing values explicitly in the sql insert. I know how to do that.

    I...

    July 30, 2014 at 6:19 pm

    #1733880

  • RE: using IDENTITY INSERT

    It's that easy. Just use a column list in the INSERT INTO statement for both sides to directly control who goes in what position.

    IE:

    CREATE TABLE #tester

    (IdCol INT IDENTITY( 1,...

    July 30, 2014 at 5:08 pm

    #1733869

  • RE: Today's Humor..

    SQLRNNR (7/30/2014)

    Sadly I have heard that same recommendation from more than one vendor and it is even printed in some vendor documentation for databases on SQL Server.

    From one particular vendor,...

    July 30, 2014 at 4:35 pm

    #1733864

  • RE: Possible sub select dilemma

    I'm not even sure what you're asking, so I can't find chapter and verse to help with your other questions.

    Can you setup two actual tables with just enough data to...

    July 30, 2014 at 3:37 pm

    #1733850

  • RE: Tuning a query that takes 60 minutes to run,

    Sean Lange (7/30/2014)

    Evil Kraig F (7/30/2014)

    churlbut (7/30/2014)

    Hello,

    We just had a meeting a few months ago given by a DBA to us developers...

    Big advice to us was to take the Items...

    July 30, 2014 at 3:34 pm

    #1733847

  • RE: Tuning a query that takes 60 minutes to run,

    churlbut (7/30/2014)

    Hello,

    We just had a meeting a few months ago given by a DBA to us developers...

    Big advice to us was to take the Items in a WHERE Clause (if...

    July 30, 2014 at 2:59 pm

    #1733830

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (7/30/2014)

    Lynn Pettis (7/30/2014)

    It should be noted as well, that sometimes people come to SSC and ask question(s) and then actually get upset when we try...

    July 30, 2014 at 2:53 pm

    #1733826

  • RE: Are the posted questions getting worse?

    patrickmcginnis59 10839 (7/30/2014)

    Just wished it didn't happen because of how easy they are to find, I'm certainly not "data mining" thats for sure.

    Didn't mean to imply you were. ...

    July 30, 2014 at 1:57 pm

    #1733795

Viewing 15 posts - 166 through 180 (of 5,685 total)