Forum Replies Created

Viewing 15 posts - 32,431 through 32,445 (of 49,552 total)

  • RE: RowNumber not sorted by RowNumber

    You should be able to use Row_number. Since you haven't posted any table definitions, this is rough and untested.

    SELECT name, mark, Row_number() Over (Order By Mark DESC) 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

    June 15, 2010 at 11:22 am

    #1180601

  • RE: Torn pages

    Have a look through this: http://www.sqlservercentral.com/articles/Corruption/65804/

    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

    June 15, 2010 at 10:57 am

    #1180587

  • RE: DB in suspect mode

    beejug1983 (6/15/2010)

    I meant exactly what happens that causes suspect mode to db?

    SQL will mark a database suspect if and only if corruption (data file or log file) is encountered during...

    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

    June 15, 2010 at 10:57 am

    #1180586

  • RE: DB in suspect mode

    1. Missing device causes database to be marked suspect.

    Won't cause suspect, can cause recovery_pending

    2. Disk out of space and no space to expand log file.

    Will not cause a database to...

    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

    June 15, 2010 at 10:55 am

    #1180581

  • RE: Are the posted questions getting worse?

    Jeff Moden (6/15/2010)

    I thought it was a bit one sided myself. Seemed like I hadn't done anything wrong and was surprised to see my name in that post especially...

    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

    June 15, 2010 at 10:51 am

    #1180579

  • RE: INDEX REBUILD

    Will you please read what I'm saying...

    GilaMonster (6/14/2010)

    For reasons that have to do with the way the first few pages are allocated, there's virtually no point in rebuilding an index...

    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

    June 15, 2010 at 10:49 am

    #1180577

  • RE: Non Disclosure Agreements (What's the point?)

    The only non-compete I've ever had prevented me from working for any of that company's clients for a period of 2 years. For a small custom software house, I could...

    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

    June 15, 2010 at 9:03 am

    #1180495

  • RE: INDEX REBUILD

    It's in the same DMV that you're using to find fragmentation - sys.dm_db_index_physical_stats. The column is called page_count.

    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

    June 15, 2010 at 8:44 am

    #1180477

  • RE: Today's Random Word!

    The Dixie Flatline (6/15/2010)

    vuvuzela'ed

    Deaf

    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

    June 15, 2010 at 8:39 am

    #1180474

  • RE: Non Disclosure Agreements (What's the point?)

    It's usually no big deal. I've got a drawer full of NDA documents.

    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

    June 15, 2010 at 8:32 am

    #1180466

  • RE: DB in suspect mode

    SQL sets the database state to suspect (in sys.databases) and prevents anyone from accessing or querying the DB.

    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

    June 15, 2010 at 8:31 am

    #1180464

  • RE: Torn pages

    Find a torn page or cause a torn page?

    When SQL finds a torn page it will throw a severity 24 error and log the page into the suspect pages 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

    June 15, 2010 at 8:30 am

    #1180463

  • RE: INDEX REBUILD

    mw112009 (6/15/2010)

    3. The query says that the fragmentation rate is 75 on index 1 ( I mean even after doing a rebuild why do a I get a fragmentation rate...

    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

    June 15, 2010 at 8:27 am

    #1180459

  • RE: about backup strategy

    vijay82 (6/14/2010)

    1).when ever need i want to restore the entire db on to different Test machine?

    Restore the full backup there

    2).When ever need i want to partialy made online?

    Define 'partially'. Look...

    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

    June 14, 2010 at 11:44 pm

    #1180199

  • RE: backup stratagey

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic937059-357-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

    June 14, 2010 at 11:40 pm

    #1180198

Viewing 15 posts - 32,431 through 32,445 (of 49,552 total)