Forum Replies Created

Viewing 15 posts - 36,571 through 36,585 (of 49,552 total)

  • RE: Unique Index Causing Slow Read Performance

    ben.mcintyre (9/3/2009)

    Hmmm ....

    The silence in this thread is almost deafening.

    I was going to dig into this over the weekend. Been rather busy prepping and delivering a presentation and then catching...

    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

    September 4, 2009 at 1:02 am

    #1049230

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/3/2009)Is BOL translated to languages other than English? That's the kindest explanation I can come up with.

    It is, but not having a clue what his native language 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

    September 3, 2009 at 4:37 pm

    #1049126

  • RE: Raising Error from Procedure

    jmiaebrown (9/3/2009)

    Is there a way to evaluate the number of rows from the update and then explicitly go to the catch block?

    It's easy to evaluate the number of rows...

    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

    September 3, 2009 at 4:34 pm

    #1049124

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (9/3/2009)

    does that mean he has learned how to research the issue and troubleshoot?

    Based on this I have to say 'No'

    http://www.sqlservercentral.com/Forums/Topic782601-5-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

    September 3, 2009 at 4:08 pm

    #1049115

  • RE: Raising Error from Procedure

    It won't go to the error handler if you pass a userID that affects no rows. Updating 0 rows is not an error. Something like a constraint violation, data conversion...

    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

    September 3, 2009 at 4:04 pm

    #1049114

  • RE: add the space for db

    Look up ALTER DATABASE in Books Online

    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

    September 3, 2009 at 4:02 pm

    #1049113

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (9/3/2009)

    hmmm - guess he didn't want to post his code

    http://www.sqlservercentral.com/Forums/Topic782432-146-1.aspx

    does that mean he has learned how to research the issue and troubleshoot?

    Well, he posted it then deleted it.

    I...

    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

    September 3, 2009 at 3:45 pm

    #1049112

  • RE: Strange Process Wait on a small table for a Select statement

    What's the wait_type and wait_resource?

    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

    September 3, 2009 at 2:25 pm

    #1049078

  • RE: Passed 70-432

    Pass mark is 700, number of questions can vary.

    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

    September 3, 2009 at 2:24 pm

    #1049077

  • RE: logspaceused

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic782432-146-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

    September 3, 2009 at 2:23 pm

    #1049076

  • RE: If you weren't a DBA what would you be doing?

    WayneS (9/3/2009)

    GilaMonster (9/3/2009)

    Probably as a web or front-end developer. I still enjoy coding. I was half-planning some years back on going back to dev. A friend that I was 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

    September 3, 2009 at 2:13 pm

    #1049072

  • RE: How often is a stored procedure run?

    It's not pretty, but it's not too bad. After all, SQL 2005 has a permanently running trace of its own. Trick is to keep the events and the columns to...

    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

    September 3, 2009 at 1:04 pm

    #1049028

  • RE: How often is a stored procedure run?

    Best thing would be SQLTrace. Set up a server-side trace and run it for as long as necessary.

    p.s. Sure you want your email address and phone no visible on a...

    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

    September 3, 2009 at 12:55 pm

    #1049020

  • RE: Stored procedures fine tuning

    Dave Ballantyne (9/3/2009)

    Try Clearing sqlserver's cache by using DBCC DROPCLEANBUFFERS.

    Only if it's a dev/test server. Emptying the data cache on a busy production server's likely to cause performance problems 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

    September 3, 2009 at 12:46 pm

    #1049014

  • RE: temp db size

    George Nak (9/3/2009)

    Actually the size has never grown above 4 Gbs for this db.

    If that's the case, make the starting size 4 GB, the growth around 100MB and change 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

    September 3, 2009 at 10:21 am

    #1048894

Viewing 15 posts - 36,571 through 36,585 (of 49,552 total)