Forum Replies Created

Viewing 15 posts - 38,431 through 38,445 (of 49,552 total)

  • RE: Comparing Table Variables with Temporary Tables

    RBarryYoung (6/15/2009)

    GilaMonster (6/15/2009)...No one I've spoken with knows exactly where the estimate is coming from. It's not the 30% of the table that's used with inequalities when a estimate can't...

    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

    June 15, 2009 at 7:23 am

    #1009633

  • RE: How do i get clients who have been enrolled for 12 months continously.

    And the expected results from that sample data?

    Please can you take a read through the article I referenced?

    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

    June 15, 2009 at 7:22 am

    #1009629

  • RE: Are the posted questions getting worse?

    Grant Fritchey (6/15/2009)

    GilaMonster (6/15/2009)

    Any thoughts on who's going to take the FIFA Confederations Cup this year?

    I seriously doubt it'll be the US, but I always hold on to the hope....

    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

    June 15, 2009 at 7:19 am

    #1009627

  • RE: Are the posted questions getting worse?

    I thought Rockies were mountains.

    Any thoughts on who's going to take the FIFA Confederations Cup this year?

    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

    June 15, 2009 at 7:11 am

    #1009613

  • RE: How do i get clients who have been enrolled for 12 months continously.

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    June 15, 2009 at 7:09 am

    #1009610

  • RE: How to write Conditional Where Clause

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    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

    June 15, 2009 at 6:05 am

    #1009578

  • RE: Populating a SP variable from the value returned by a select statement

    jpalmer (6/15/2009)

    I was treating the SP variables like ASP variables - didn't know that my "custom" variable had to be "DECLARE"ed instead of just listing it at the top...

    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

    June 15, 2009 at 6:04 am

    #1009576

  • RE: system database backup

    ps (6/15/2009)

    model - this is the template for new databases, if you're making any change to this template, you should back it up. This also stores job histories, including backup/restore...

    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

    June 15, 2009 at 5:58 am

    #1009570

  • RE: Is this Maintenance plan ok?

    Do the update stats before the rebuild/reorg. Reason is that an index rebuild will update stats will full scan, so if you do a sampled update after that you 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

    June 15, 2009 at 5:58 am

    #1009569

  • RE: system database backup

    Personally I'd just back the system databases up once a week and leave it at 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

    June 15, 2009 at 5:54 am

    #1009567

  • RE: Comparing Table Variables with Temporary Tables

    Ewald Cress (6/14/2009)

    Gail, this is a shot in the dark, but have a look at the relationship between the actual (17134) and estimate (5623). This is roughly 30%, which corresponds...

    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

    June 15, 2009 at 3:02 am

    #1009513

  • RE: updating item postions in a folder table

    Not sure if I'm understanding you clearly. You want to increase all of the itempositions by 1? If so a simple update will work.

    UPDATE SomeTable SET ItemPosition = ItemPosition+1

    That won't...

    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

    June 14, 2009 at 2:08 pm

    #1009388

  • RE: Need to Know about Logspace

    Please read through this - Managing Transaction Logs[/url]

    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

    June 14, 2009 at 2:06 pm

    #1009387

  • RE: Are the posted questions getting worse?

    ubernoob (6/14/2009)

    So it looks like there are cliques on this site.

    I thought you wanted your account removing because you didn't want to read or post here any longer.

    In my...

    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

    June 14, 2009 at 1:59 pm

    #1009386

  • RE: Are the posted questions getting worse?

    Jeff Moden (6/14/2009)"Regular Sessions"? Are you talking about "general" sessions?

    Would assume so. The spotlights were picked weeks back. General sessions are the only ones remaining.

    I've not received anything...

    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

    June 14, 2009 at 11:58 am

    #1009347

Viewing 15 posts - 38,431 through 38,445 (of 49,552 total)