Forum Replies Created

Viewing 15 posts - 32,206 through 32,220 (of 49,552 total)

  • RE: Primary Key Index and Primary Key with Clustered Index

    Chris Schmidt (6/25/2010)

    "Note PRIMARY KEY constraints create clustered indexes automatically if no clustered index already exists on the table and a nonclustered index is not specified when you create...

    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 25, 2010 at 9:04 am

    #1185059

  • RE: Database stuck "in recovery"

    yessen (6/25/2010)

    I see. It remembered the state. Went backwards using the log file and then forward. If states of the databases matched, it was happy 😀

    SQL went through the active...

    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 25, 2010 at 9:02 am

    #1185055

  • RE: Database stuck "in recovery"

    yessen (6/25/2010)

    Once I have a small log file and few VLFs. My databases should not take much time recovering (i.e checking for consistency) if I need to restart SQL server.

    Providing...

    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 25, 2010 at 8:46 am

    #1185045

  • RE: Are the posted questions getting worse?

    What kind of encryption are you using? Most of the usual encryption algorithms are nondeterministic, so encrypting the same value twice gives different outputs.

    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 25, 2010 at 8:27 am

    #1185028

  • RE: Database stuck "in recovery"

    Break? A simple shrink cannot break the log. If you mean the log chain, no, shrink does not break that either

    Once you've shrunk it down, regrow it back to 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

    June 25, 2010 at 8:24 am

    #1185025

  • RE: drop production database

    Find out why it's been dropped and make sure that the person asking is correct in asking for it to be dropped.

    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 25, 2010 at 8:10 am

    #1185016

  • RE: Database stuck "in recovery"

    Jason gave you the link, last one in his signature

    http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.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 25, 2010 at 8:08 am

    #1185014

  • RE: Deadlock Problem

    *removed*

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

    #1184942

  • RE: dba task to prevent dbase suspect mode

    Cowboy DBA (6/25/2010)

    See what was running at the time: sys_dm_exec_requests

    Check free disk space at run-time

    Check log growth

    Check what the autogrowth of the data and log file is set at

    None 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

    June 25, 2010 at 6:01 am

    #1184939

  • RE: Deadlock Problem

    You said you turned traceflag 1222 on. That means that the deadlock graph will be written to the error log.

    Post it here. It may be near useless to 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

    June 25, 2010 at 6:01 am

    #1184937

  • RE: dba task to prevent dbase suspect mode

    If you're getting frequent database corruptions, your IO subsystem is likely the cause. Check to IO-related errors, check the RAID/SAN logs, check that all your firmware is updated. Or 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

    June 25, 2010 at 5:59 am

    #1184935

  • RE: Memory Setting in SQL SERVER 2008

    paul.knibbs (6/25/2010)

    If the server had a LOT of installed RAM I could see those numbers being reasonable--the memory page size Windows uses doesn't change, so the internal structures for keeping...

    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 25, 2010 at 1:58 am

    #1184838

  • RE: Need Expert advice on my sql query for speed improvement

    If it's still too slow after making those changes, please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Why are you returning millions of rows? Where are 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

    June 25, 2010 at 1:33 am

    #1184826

  • RE: The Phantom DBA

    WillC9999 (6/25/2010)

    Get some developers, they need a SQL box, easy, they can manage this themselves, just a few databases - right? Couple of years later you have 150 databases festering...

    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 25, 2010 at 1:31 am

    #1184825

  • RE: Manually Grow w/Multi files.

    digdave7 (6/23/2010)

    from sp_spaceused: The database_size: 29427824.94 MB unallocated space:506.73 MB

    Is that a correct output? Is the sum total of all the database files 29 427 824 MB? (29 427 GB,...

    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 25, 2010 at 1:27 am

    #1184821

Viewing 15 posts - 32,206 through 32,220 (of 49,552 total)