Forum Replies Created

Viewing 15 posts - 17,506 through 17,520 (of 49,552 total)

  • RE: Introduction to Indexes: Part 3 – The nonclustered index

    Hard to say without detailed analysis.

    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

    July 20, 2012 at 10:51 am

    #1515653

  • RE: Introduction to Indexes: Part 3 – The nonclustered index

    Don't do that. Waste of time. It is highly, exceedingly unlikely that it's faster to create all the indexes then run the query then drop the indexes than to just...

    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

    July 20, 2012 at 9:39 am

    #1515609

  • RE: AWE Memory and Lock Pages in Memory

    thunderousity (7/20/2012)

    I tend to start out by reserving 1-2 GB RAM for the OS, and then an additional 1GB for each 4 GB of RAM installed from 4-16 GB, and...

    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

    July 20, 2012 at 9:23 am

    #1515599

  • RE: DBCC Hangs

    What do you mean 'hangs'? What's the wait type you see?

    Enterprise edition?

    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

    July 20, 2012 at 9:19 am

    #1515597

  • RE: Stack Ranking

    paul.goldstraw (7/20/2012)

    - Employment demographics and targets. I'm pretty sure from the depth of my mind that some companies and public sector work places aim to employ a certain percentage of...

    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

    July 20, 2012 at 9:05 am

    #1515588

  • RE: WAIT TYPE SOS_SCHEDULER_YIELD - Scheduler / Worker Issue SQLOS?

    If you haven't already, chapter 1 at very least of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

    July 20, 2012 at 8:59 am

    #1515580

  • RE: Introduction to Indexes: Part 3 – The nonclustered index

    I don't understand what you're asking.

    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

    July 20, 2012 at 8:56 am

    #1515577

  • RE: Performance Troubleshooting - Jonathan Kehayias and Ted Krueger Troubleshooting SQL Server

    See chapter 6 in the same book.

    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

    July 20, 2012 at 6:19 am

    #1515476

  • RE: table partition in sqlserver 2008

    When you merge two partitions, is one always empty?

    Are you trying to move lots of rows from a partition in one filegroup to a partition in another?

    What wait type 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

    July 20, 2012 at 6:15 am

    #1515475

  • RE: Are the posted questions getting worse?

    Database Corruption

    Statistics

    Indexing fundamentals

    Execution plans

    Performance tuning (demo-heavy)

    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

    July 20, 2012 at 2:54 am

    #1515361

  • RE: table partition in sqlserver 2008

    Merging and splitting the ranges shouldn't take any time.

    Are the partitions on different filegroups?

    What wait type are you seeing when running the merge and split?

    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

    July 20, 2012 at 2:53 am

    #1515360

  • RE: Pivot Query -Help

    Patience. We're volunteers here posting in our spare time.

    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

    July 20, 2012 at 2:51 am

    #1515359

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (7/20/2012)

    GilaMonster (7/19/2012)

    Gianluca Sartori (7/19/2012)

    How am I supposed to fail-over the instances if I can't reach the cluster admin snap-in?

    What permissions does the SQL Server service account have, and...

    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

    July 20, 2012 at 1:49 am

    #1515338

  • RE: Pivot Query -Help

    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/

    Why is this so urgent?

    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

    July 20, 2012 at 1:35 am

    #1515335

  • RE: Pivot Table

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1332742-392-1.aspx

    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

    July 20, 2012 at 1:23 am

    #1515330

Viewing 15 posts - 17,506 through 17,520 (of 49,552 total)