Forum Replies Created

Viewing 15 posts - 39,316 through 39,330 (of 49,552 total)

  • RE: Deadlocks CleanCnt

    zach_john (5/4/2009)

    My object Id is a very high number 72057594870497280 and i cant find it in that db, perhaps a temp table?

    That's not an objectid. It's...

    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

    May 4, 2009 at 1:49 pm

    #988339

  • RE: NON-Clustered Indexes on table but no Clustered Indexes

    Mohit (5/4/2009)

    I understand your points, I think the Microsoft consultant was just suggesting I should seriously look at the fields in questions because there is no doubt for room for...

    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

    May 4, 2009 at 1:43 pm

    #988335

  • RE: Are the posted questions getting worse?

    Luke L (5/4/2009)

    Or perhaps that seeing the name might be enough to jog your memory, although I wasn't sure since you're from South Africa. Not sure how much...

    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

    May 4, 2009 at 12:18 pm

    #988287

  • RE: Filtered index with IS NULL predicate

    No, it is covering and the optimiser should, theoretically, be picking it. Might be a bug, might be something subtle that we've missed.

    If we flip the query and the index...

    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

    May 4, 2009 at 12:13 pm

    #988278

  • RE: Are the posted questions getting worse?

    Luke L (5/4/2009)

    http://lmgtfy.com/?q=wiki+warren+zevon&l=1

    Be nice. 😉

    I'd have googled it if I'd had a clue what to google for.

    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

    May 4, 2009 at 11:55 am

    #988260

  • RE: Filtered index with IS NULL predicate

    Odd. Behaviour doesn't change even if there's a lot more rows added. I'm going to ask some other people, see if I can get an explanation.

    The output list of 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

    May 4, 2009 at 11:52 am

    #988257

  • RE: The Next Frontier of Performance Troubleshooting

    Indianrock (5/4/2009)

    Still waiting to hear if this is only for sql 2008.

    Extended events are new in SQL 2008.

    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

    May 4, 2009 at 11:20 am

    #988228

  • RE: Are the posted questions getting worse?

    Bob Hovious (5/4/2009)

    I saw a werewolf drinking a pina colada at PASS in Seattle...

    And his code was perfect....

    Ahoooooooooooo

    Werewolves of SQL

    What?

    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

    May 4, 2009 at 11:06 am

    #988214

  • RE: Error while shrinking the database log

    Why are you shrinking your log on a regular basis? It's just going to have to grow again. When it does it's going to slow the system down. Also repeated...

    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

    May 4, 2009 at 11:02 am

    #988208

  • RE: NON-Clustered Indexes on table but no Clustered Indexes

    Mohit (5/1/2009)

    I was talking to Microsoft Tier-3 Support guy about SQL Server; he suggested using the Dash Board there is a 90%+ improvement there will definetly be improvement. He...

    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

    May 4, 2009 at 11:01 am

    #988207

  • RE: Switch a subscriber to a publisher

    There's no automated way. To make the subscriber the publisher you need to drop the subscription, set that server up for replication (creating a distributor) and then create the publication...

    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

    May 4, 2009 at 10:51 am

    #988198

  • RE: Are the posted questions getting worse?

    Luke L (5/4/2009)

    It's works well when used properly but when sued poorly it can become a real beast.

    Wow, I know the US legal system's weird, but I didn't realise it...

    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

    May 4, 2009 at 10:11 am

    #988177

  • RE: Avoiding CURSOR

    arun.sas (5/4/2009)

    Hi Gail,

    In 2000, how can we handle?

    Your way should work. Since this was posted in the SQL 2005 forum, I'm assuming the poster uses SQL 2005 and hence 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

    May 4, 2009 at 4:16 am

    #988015

  • RE: Oracle create table syntax

    Thanks. That'll be useful in the future.

    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

    May 4, 2009 at 4:00 am

    #988008

  • RE: Avoiding CURSOR

    You don't. There's no 'answered posts' feature on this forum.

    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

    May 4, 2009 at 3:54 am

    #988003

Viewing 15 posts - 39,316 through 39,330 (of 49,552 total)