Forum Replies Created

Viewing 15 posts - 18,721 through 18,735 (of 49,552 total)

  • RE: Microsoft Certified Master

    Jeff Moden (4/27/2012)

    And contrary to what I see many people leaning towards on these problems, it's not just Prometric's fault... where the heck was MSL for UAT and FAT testing...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 28, 2012 at 4:53 am

    #1480835

  • RE: Changing Filegroup names and Filegroup files - midstream. . .

    Rich Yarger (4/27/2012)

    And Gail - also and lastly - if my previous question turns out to be a yes, can I then reconstruct a partition scheme without having to drop...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 27, 2012 at 4:12 pm

    #1480764

  • RE: Changing Filegroup names and Filegroup files - midstream. . .

    Rich Yarger (4/27/2012)

    Awesome...So I should just be able to take the database offline, deattach it, change my Filegroup Directory names, and Filegroup File names, bring it back up online, and...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 27, 2012 at 4:10 pm

    #1480762

  • RE: Changing Filegroup names and Filegroup files - midstream. . .

    Filegroup and file names are completely irrelevant when inserting into tables. All that inserts need is the database name, the schema name (if not default) and the table name.

    This is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 27, 2012 at 3:36 pm

    #1480750

  • RE: insert into table variable

    What first two?

    Group by is for aggregation (sum, min, max, etc), not ordering.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 27, 2012 at 3:31 pm

    #1480749

  • RE: Microsoft Certified Master

    Just to be clear, it's not MS Learning's fault. Prometric has seriously dropped the ball here, there are at least 3 people now who they've messed around on the MCM...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 27, 2012 at 3:29 pm

    #1480748

  • RE: How to write a query to find Invalid SSN numbers using a JOIN!!

    Please don't start multiple threads for the same problem.

    No further replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1289821-1292-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 27, 2012 at 3:27 pm

    #1480747

  • RE: insert into table variable

    ORDER BY CASE WHEN <whatever the column name is> LIKE 'Performance%' then 1 ELSE 0 END

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 27, 2012 at 3:25 pm

    #1480744

  • RE: insert into table variable

    Sure

    EXEC StoredProcName @Parameter1

    EXEC StoredProcName @Parameter2

    Just like that.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 27, 2012 at 2:30 pm

    #1480694

  • RE: insert into table variable

    Not without running the procedure.

    I suggest you investigate why the procedure is slow. Grant Frichey's book on performance tuning is good (just search for Grant Frichey on Amazon)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 27, 2012 at 2:22 pm

    #1480682

  • RE: insert into table variable

    It will insert.

    What's likely happening is that the procedure takes over 7 minutes to complete and only starts retuning data in seconds. since the insert can't complete until the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 27, 2012 at 1:52 pm

    #1480665

  • RE: insert into table variable

    Just means you have a very slow query. Nothing else wrong.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 27, 2012 at 1:11 pm

    #1480642

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/27/2012)

    Gail, without really digging into this, isn't this just an expensive NOP?

    Yup.

    On the plus side, SQL's smart enough not to log the update.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 27, 2012 at 1:04 pm

    #1480635

  • RE: insert into table variable

    Define 'not working'

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 27, 2012 at 1:02 pm

    #1480631

  • RE: Are the posted questions getting worse?

    Evil Kraig F (4/27/2012)

    If you put an infinite number of monkeys at an infinite number of computers, one of them will design the perfect application.

    If you use 10,000 monkeys, your...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 27, 2012 at 12:59 pm

    #1480627

Viewing 15 posts - 18,721 through 18,735 (of 49,552 total)