Forum Replies Created

Viewing 15 posts - 9,091 through 9,105 (of 49,552 total)

  • RE: MDF, LDF and Tempdb files placement drive?

    I suggest you spend some time on google, there's lots and lots written on the subject. Also, probably Glenn Berry's hardware 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

    May 12, 2014 at 4:51 am

    #1712599

  • RE: Are the posted questions getting worse?

    *sigh* http://www.sqlservercentral.com/Forums/FindPost1569693.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

    May 12, 2014 at 4:49 am

    #1712597

  • RE: Query tuning

    Grant Fritchey (5/12/2014)

    In fact, most of the time, when testing queries, I'll run it once without really looking at the time, then run it 2-3 more times and take 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 12, 2014 at 4:34 am

    #1712591

  • RE: Database stuck "in recovery"

    Elliswhite (5/12/2014)

    Here are few steps by which you can drive out your SQL database from recovery mode and perform action on it.

    First step is to stop the SQL Services

    Then change...

    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 12, 2014 at 4:33 am

    #1712589

  • RE: How am I getting Network_IO wait

    Those waits aren't about how the query is written. They occur when SQL has results that it is waiting to send to the client application.

    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 11, 2014 at 8:55 am

    #1712478

  • RE: When to Restore and When to Rebuild master database

    It's not a case of which you do. If you have backups you'd almost always want to restore. There are scenarios however where you'd need to rebuild first to get...

    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 11, 2014 at 8:54 am

    #1712477

  • RE: MDF, LDF and Tempdb files placement drive?

    ananda.murugesan (5/10/2014)

    is it really get performance on different logical array in single Physical arrary controller?

    Probably not.

    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 10, 2014 at 10:44 am

    #1712399

  • RE: 16 inconsistencies found running DBCC checkDB

    Please note: 6 year old thread.

    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 10, 2014 at 3:32 am

    #1712373

  • RE: How to resolve error while attach MDF file Error (5171)

    Please note: 2 year old thread.

    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 10, 2014 at 3:31 am

    #1712372

  • RE: MDF, LDF and Tempdb files placement drive?

    You can put TempDB there, but it's an extremely bad idea. If TempDB grows unexpectedly, you could have the server crash because of lack of free space on C.

    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 10, 2014 at 3:29 am

    #1712371

  • RE: Log not available error 9001

    Please post new questions in a new thread. Thank you.

    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 9, 2014 at 3:40 pm

    #1712349

  • RE: Is there any way to improve statistics on a table like this?

    How many rows in the table?

    Can you post the execution plan (actual please) of that simple query with the inaccurate estimations?

    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 9, 2014 at 3:39 pm

    #1712348

  • RE: sql command

    mkkb917 (5/9/2014)

    ZoneSearch is a variable and it contain a zone name selected form the combo box items

    here it is "City"

    So the resultant dynamic query will read:

    SELECT IP_Addr FROM...

    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 9, 2014 at 3:39 pm

    #1712347

  • RE: Table scan paranoia

    I can't see any useful covering indexes for that query, so it's probably just a case of the indexes being insufficiently selective and not covering. Cheaper to scan the table...

    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 9, 2014 at 3:33 pm

    #1712345

  • RE: Putting Page Files, root node, intermediate, clustered index and non-clustered index all together and trying to make sense

    Did you read the articles I referenced?

    Wrong way around, pages don't have indexes, indexes have pages.

    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 9, 2014 at 3:29 pm

    #1712344

Viewing 15 posts - 9,091 through 9,105 (of 49,552 total)