Forum Replies Created

Viewing 15 posts - 24,526 through 24,540 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (8/2/2011)

    So Gail, how did the conversation end?

    With my account untouched.

    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 2, 2011 at 11:23 am

    #1362394

  • RE: Adding/Removing Columns

    Depends how you do it. Through Managment Studio's GUI it'll probably end up recreating the table. Rather use the appropriate T-SQL ALTER TABLE statements.

    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 2, 2011 at 11:21 am

    #1362392

  • RE: hi..help with statement

    Did you try it?

    What you have there is part of the statement, it needs ALTER TABLE <tablename> adding before.

    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 2, 2011 at 11:20 am

    #1362390

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (8/2/2011)

    calvo (8/2/2011)

    Steve Jones - SSC Editor (8/2/2011)

    I used about 500-700 minutes a month, and about 350-400GB of data + who knows how much on wifi.

    Ahh... that explains the disappearing...

    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 2, 2011 at 11:15 am

    #1362386

  • RE: Are the posted questions getting worse?

    SQLRNNR (8/2/2011)

    GilaMonster (8/2/2011)

    Ninja's_RGR'us (8/2/2011)

    Steve Jones - SSC Editor (8/2/2011)

    All these discussions just got me to look at my usage and lower my cell plan.

    I had an unlimited voice/unlimited data plan...

    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 2, 2011 at 11:12 am

    #1362382

  • RE: Speeding Up Database Access Part 3 - Fixing Missing Indexes

    The clustered index enforces which rows of the cluster belong together on the index pages. If a page has the values 1,3, 4 and 5 on it and value 2...

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

    #1362380

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (8/2/2011)

    Steve Jones - SSC Editor (8/2/2011)

    All these discussions just got me to look at my usage and lower my cell plan.

    I had an unlimited voice/unlimited data plan for 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

    August 2, 2011 at 11:02 am

    #1362365

  • RE: SQL Server running slow

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

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

    #1362286

  • RE: Ntfs error

    gmamata7 (8/2/2011)

    The file system structure on the disk is corrupt and unusable. Please run the chkdsk utility on the volume SQL1 Data

    Did you do what the error said?

    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 2, 2011 at 9:50 am

    #1362284

  • RE: Speeding Up Database Access Part 3 - Fixing Missing Indexes

    Personally I prefer clustered index to organise the table and nonclustered indexes for data access.

    Shameless plugging of my own article... http://www.sqlservercentral.com/articles/Indexing/68563/

    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 2, 2011 at 9:48 am

    #1362280

  • RE: Shrink

    @SQLFRNDZ (8/1/2011)

    GSquared (8/1/2011)

    Regularly shrinking the database files is usually just a good way to slow the whole server down. It causes file fragmentation, locks during auto-growth, and a host...

    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 2, 2011 at 9:43 am

    #1362275

  • RE: How to check disk queue length

    Ninja's_RGR'us (8/2/2011)

    If you don't have anything setup before the problem to have a baseline the counters won't help you much (if at all).

    And even if he did, the queue length...

    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 2, 2011 at 9:37 am

    #1362268

  • RE: very slow query

    GilaMonster (8/2/2011)

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Fragmentation will have absolutely no effect on a singleton seek (which is what an equality match 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

    August 2, 2011 at 9:35 am

    #1362263

  • RE: very slow query

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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 2, 2011 at 9:02 am

    #1362229

  • RE: How to check disk queue length

    Don't bother. It's near-impossible to interpret correctly and SQL can drive it high during normal operation.

    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 2, 2011 at 8:56 am

    #1362225

Viewing 15 posts - 24,526 through 24,540 (of 49,552 total)