Forum Replies Created

Viewing 15 posts - 23,296 through 23,310 (of 49,552 total)

  • RE: Select Records Issue

    engrshafiq4 (9/26/2011)

    As i mentioned earlier,i want to show top 3 paid companies(paid companies are more than 3)

    Top 3 by what criteria? Your query currently selects 3 companies with flag...

    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 26, 2011 at 6:29 am

    #1386418

  • RE: Getting Truncated data back

    prakash 67108 (9/26/2011)

    i don't know what exactly the problem is ? actually one of my friend asked me what is the way to retrieve the table if it is crashed...

    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 26, 2011 at 6:11 am

    #1386406

  • RE: Getting Truncated data back

    Define 'crashed'

    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 26, 2011 at 5:31 am

    #1386388

  • RE: MERGE

    Insert into Destination

    from Source where not exists (select from destination where <comparison condition>)

    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 26, 2011 at 5:30 am

    #1386386

  • RE: Doubt on LSN

    The first and last LSNs of the diff, just like of the full backup, are of transactions running during the backup.

    A log backup contains a set of log records,...

    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 26, 2011 at 3:40 am

    #1386338

  • RE: Database Stuck in Restore Mode

    Drop the database and restore it from backup again. Either the restore failed part way through or the backup file used was damaged.

    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 26, 2011 at 3:37 am

    #1386337

  • RE: retried attempts on deadlocks

    Traceflag 1222, which you already have. That's exactly what it does.

    You don't need 3605 as well. Just 1222.

    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 25, 2011 at 3:07 pm

    #1386244

  • RE: REBUILD for heaps

    Sorry, not rebuilds (it's a heap anyway), and can't find the ref I thought existed for triggers, so ignore.

    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 25, 2011 at 3:05 pm

    #1386243

  • RE: Index usage after UNION operator

    sporoy (9/25/2011)

    This solved my issue! There was collation conversion between tables, I have standardized the collations. Now its very fast, thanks Gila. How did you see the conversion in sqlplan?

    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 25, 2011 at 11:04 am

    #1386226

  • RE: REBUILD for heaps

    Edit: Blah.

    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 25, 2011 at 10:58 am

    #1386224

  • RE: REBUILD for heaps

    opc.three (9/23/2011)

    I am wondering if anyone knows if during a heap rebuild if the non-clustered indexes are updated with the new RIDs as the heap is being defragmented then...

    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 25, 2011 at 7:53 am

    #1386206

  • RE: Select Records Issue

    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

    September 25, 2011 at 5:35 am

    #1386194

  • RE: pass table name as a parameter in stored procedure

    mjbkm (9/25/2011)

    Found this option. And it worked pretty good -I mean looking forward, splitting this table up by year. Because the user always queries a specific year at...

    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 25, 2011 at 5:34 am

    #1386193

  • RE: MVP Branding

    Jeff Moden (9/24/2011)

    Part of the reason for that is because of the things they're exposed to after they become an MVP. The information is so cutting-edge that they have...

    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 25, 2011 at 2:51 am

    #1386178

  • RE: MVP Branding

    stefanos_valvis (9/24/2011)

    a) How valuable is the MVP designation for a consultant?

    I've certainly gained advantage from it. Being able to say I'm the only SQL MVP in the country is 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 25, 2011 at 2:48 am

    #1386177

Viewing 15 posts - 23,296 through 23,310 (of 49,552 total)