Forum Replies Created

Viewing 15 posts - 23,806 through 23,820 (of 49,552 total)

  • RE: using a table variable.

    Table variables can be used just about anywhere that permanent or temp tables can

    The only syntax problem I can see with your queries is that table variables have to be...

    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

    August 30, 2011 at 9:18 am

    #1375070

  • RE: Are the posted questions getting worse?

    Tom.Thomson (8/29/2011)

    GilaMonster (8/29/2011)

    Jeff Moden (8/29/2011)

    GilaMonster (8/29/2011)

    mtillman-921105 (8/29/2011)

    But communism is not seriously considered a real option anymore.

    Come down and tell some people in government here that. It would come as...

    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

    August 30, 2011 at 7:06 am

    #1374950

  • RE: Are the posted questions getting worse?

    GSquared (8/30/2011)

    Actually, in the US, the government does own and run the two biggest companies in that particular arena (Fannie Mae and Freddie Mack).

    Yes, I know. And they buy mortgages...

    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

    August 30, 2011 at 7:04 am

    #1374946

  • RE: If i partition my mdf file

    Read up on piecemeal restores before you go that way. You don't want to be left in a state where you can't restore the DB fully.

    Basically, unless the filegroups are...

    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

    August 30, 2011 at 4:16 am

    #1374873

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/29/2011)

    GilaMonster (8/29/2011)

    Jeff Moden (8/29/2011)

    GilaMonster (8/29/2011)

    mtillman-921105 (8/29/2011)

    But communism is not seriously considered a real option anymore.

    Come down and tell some people in government here that. It would come...

    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

    August 30, 2011 at 4:10 am

    #1374872

  • RE: SQL Database crush

    Start by explaining the situation in a lot more detail.

    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

    August 30, 2011 at 3:50 am

    #1374868

  • RE: Msg 0, Level 11, State 0, Line 0 when I reog indexes

    No, because that's completely dependant on how much concurrent activity there is during the CheckDB

    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

    August 30, 2011 at 3:48 am

    #1374866

  • RE: Where the Data is Stored if Select query executed before placing to Grid?

    patelmohamad (8/30/2011)

    Hi Sean,

    Agree with you but in Asp.Net application we holds the data in DataTable,List or Dataset Basically the Data holder and then display in grid, my question is same...

    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

    August 30, 2011 at 3:41 am

    #1374864

  • RE: Index over multiuple columns question

    What's the clustered index definition?

    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

    August 30, 2011 at 3:39 am

    #1374863

  • RE: Clustered Indexes? Sedimentary, my dear Watson

    Tom.Thomson (8/29/2011)

    Well, that's mostly correct. The number of page traversals may be different if page fragmentation has caused the depth to change in one case but not in the other,...

    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

    August 30, 2011 at 3:35 am

    #1374862

  • RE: Clustered Indexes? Sedimentary, my dear Watson

    Please, please, please read that indexing article I referenced.

    It doesn't matter which way around the keys are, the index tree is the same depth (and SQL pages are always 8k...

    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

    August 29, 2011 at 3:07 pm

    #1374746

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/29/2011)

    GilaMonster (8/29/2011)

    mtillman-921105 (8/29/2011)

    But communism is not seriously considered a real option anymore.

    Come down and tell some people in government here that. It would come as a revelation...

    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

    August 29, 2011 at 3:00 pm

    #1374743

  • RE: Why is my select slow? (question about indexes)

    jeeva.nadarajah (8/29/2011)

    Thanks Everybody!

    Since there is so little data in the table, I've switched the type to be VARCHAR(max).

    In other words, you've changed almost nothing... 🙂

    A varchar(max) and a text...

    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

    August 29, 2011 at 2:02 pm

    #1374699

  • RE: Clustered Indexes? Sedimentary, my dear Watson

    Ken Lee-263418 (8/29/2011)

    Tom.Thomson (8/27/2011)

    It's an interesting editorial. An some interesting comments - some people seem to be assuming that the clustered index must be unique, or that the primary...

    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

    August 29, 2011 at 1:59 pm

    #1374698

  • RE: Why is my select slow? (question about indexes)

    Evil Kraig F (8/29/2011)

    Oh, and this isn't helping either:

    TEXTIMAGE_ON [PRIMARY]

    By preference you want it in a different filegroup.

    However it's near-impossible to change after table creation. 🙁

    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

    August 29, 2011 at 1:45 pm

    #1374685

Viewing 15 posts - 23,806 through 23,820 (of 49,552 total)