Forum Replies Created

Viewing 15 posts - 32,776 through 32,790 (of 49,552 total)

  • RE: Database Consistency Error

    Please run the following and post the full, complete and exact output.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    If you need urgent help, I suggest that you call Micrsoft's customer support...

    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 23, 2010 at 4:23 am

    #1171283

  • RE: Clustered Indexes? Sedimentary, my dear Watson

    Well I'm strongly in the 'clustered index to organise the table' camp, and do have reasons.

    Firstly, note that these reasons are for OLTP-type systems. Lots of changes, lots of fast,...

    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 23, 2010 at 2:38 am

    #1171277

  • RE: performance Tuning

    If you want immediate help, consider hiring someone.

    Your question is very wide, there could be any number of things wrong. Have you checked for blocking? Is there anything unusual...

    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 22, 2010 at 6:25 am

    #1171211

  • RE: sql server logfile

    Full recovery and no log backups?

    Please read through this - Managing Transaction Logs[/url]

    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 22, 2010 at 1:55 am

    #1171192

  • RE: Torn Page issue

    Chris Mathews (5/17/2010)

    But my actual question is this, I have the two pages in question can I determine the database objects that rest on those pages. The database contains...

    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 21, 2010 at 11:36 am

    #1171003

  • RE: Query Optimize

    Please post the query, table definitions and index definitions 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

    May 21, 2010 at 4:25 am

    #1170693

  • RE: i have 1.5 gb ldf file i want to trincate it

    Take a look through this article - http://www.sqlservercentral.com/articles/64582/

    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 21, 2010 at 4:25 am

    #1170692

  • RE: clustered index on non-primary key?

    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

    May 20, 2010 at 11:21 pm

    #1170588

  • RE: INNER JOIN and WHEwhat is order execute?

    nguyennd (5/20/2010)

    What is order execute?

    1. Step1: TABLEA JOIN TABLEB

    2. Step2: After JOIN, SQL execute WHERE

    OR

    1. Step1: SQL execute WHERETABLEA JOIN TABLEB

    2. Step2: After WHERE, SQL execute TABLEA JOIN TABLEB

    Depends on...

    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 20, 2010 at 11:19 pm

    #1170587

  • RE: Does rebuilding indexes and statistics cause recompile of execution plans?

    kwiggans (5/20/2010)

    Does SQL server see a fresh index or statistics on a table and automatically force a recompile on a stored procedure if executed in order to choose the best...

    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 20, 2010 at 11:18 pm

    #1170586

  • RE: Select ... Except Query Optimization Strategies (Suggestions Requested)

    Probably. Can't say much more without more info. Do you have the query? If so, 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

    May 20, 2010 at 11:12 pm

    #1170584

  • RE: Are the posted questions getting worse?

    Jack Corbett (5/20/2010)

    I think it's borderline because they never asked me if they could grab my stuff and other sites like SSC and SQLServerPedia ask first.

    Disagree. Republished without permission, without...

    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 20, 2010 at 3:56 pm

    #1170489

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (5/20/2010)

    Looking for insight / opinions on this.

    I was searching for the SQLSat Utah information and came across this blog. I am uncertain if it is RSS'd or if...

    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 20, 2010 at 3:48 pm

    #1170484

  • RE: Maintenance Plan Best Practice

    Jeffrey Irish (5/20/2010)

    In any case, rebuilding Indexes daily still sounds excessive to me.

    Rebuilding all indexes, regardless of fragmentation is usually a waste. There are many good index rebuild scripts that...

    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 20, 2010 at 1:23 pm

    #1170415

  • RE: How to extract "password" from SQL Login

    PaulB-TheOneAndOnly (5/20/2010)

    That's not true. There is a Microsoft published way... research "sp_help_revlogin" - under your own responsibility.

    That extracts the hashed password, it doesn't reverse the one-way hash and give...

    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 20, 2010 at 12:53 pm

    #1170404

Viewing 15 posts - 32,776 through 32,790 (of 49,552 total)