Forum Replies Created

Viewing 15 posts - 36,316 through 36,330 (of 49,552 total)

  • RE: Seperate Indexes from Data

    Silverfox (10/14/2009)

    You say avg, but over what period ?

    Over whatever interval the perfmon samples were done. Default is every sec.

    The name of the counter is Physical disk:Avg sec\read.

    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

    October 14, 2009 at 10:04 am

    #1065812

  • RE: Are the posted questions getting worse?

    Bob Hovious 24601 (10/14/2009)

    This is why people who waste our time are irritating, as are the people who insist that their problems are urgent and somehow more deserving of assistance....

    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

    October 14, 2009 at 9:59 am

    #1065806

  • RE: Transaction log queries

    WillC9999 (10/14/2009)

    I (think) I understand the concept of the transaction log. All the insert/update/delete statements stack up in the .trn file. At some point these are written to the .mdf...

    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

    October 14, 2009 at 9:57 am

    #1065804

  • RE: SQL SERVER 2000 corruption on table in MDSB BACKUPMEDIAFAMILY

    Seth Lynch (10/14/2009)

    Repair_allow _Data_loss does not mean there has to be data loss though so your solution was probably fine.

    The majority of the time it does. There are a few...

    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

    October 14, 2009 at 9:51 am

    #1065798

  • RE: Seperate Indexes from Data

    The read's a little high on the data. Should be < 10ms. I've seen worse though (far, far worse)

    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

    October 14, 2009 at 9:45 am

    #1065790

  • RE: I need to create an index to stop a lookup

    Please post query, 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

    October 14, 2009 at 1:05 am

    #1065511

  • RE: Shrink Database issue

    SQLRocker (10/13/2009)

    Auto-shrink is enabled.

    Disable it and try the manual shrink again. It could be that you're trying to shrink while the auto-shrink is running, hence the error that 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

    October 14, 2009 at 12:50 am

    #1065510

  • RE: space for a Log File

    Krasavita (10/13/2009)

    How to check for space for a Log File

    Error log, event log, maintenance plan history log, transaction log???

    Assuming you mean transaction log, do you want the size of 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

    October 13, 2009 at 10:08 am

    #1065288

  • RE: Is there a way to make a backup that isn't part of the backup set

    Silverfox (10/13/2009)

    my build version is 9.0.4035

    That the server version or management studio version?

    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

    October 13, 2009 at 10:05 am

    #1065285

  • RE: Shrink Database issue

    Auto-shrink enabled?

    Why are you shrinking the database? Do you expect that the 15 GB free space won't be reused in a reasonable amount of 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

    October 13, 2009 at 8:40 am

    #1065224

  • RE: Tuning DBCC DBREINDEX

    Don't rebuild indexes that don't need rebuilding. There are lots of custom index rebuild scripts available. There's one I quite like here - http://www.sqlfool.com

    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

    October 13, 2009 at 3:19 am

    #1065100

  • RE: Attaching mdf and ldf for SQL 2000 compatible DB - nasty error

    Joseph Fallon (10/13/2009)

    Is this a new "feature" in 2008 I wonder ?

    No. It was there in 2005 as well. That's where I ran into it.

    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

    October 13, 2009 at 3:11 am

    #1065093

  • RE: Is there a way to make a backup that isn't part of the backup set

    Silverfox (10/13/2009)

    Interesting, I backup and restore "copy only" backups all the time, never had any issues.

    T-SQL restore statement or Management studio restore dialog?

    It was a known problem on SQL 2005...

    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

    October 13, 2009 at 1:32 am

    #1065063

  • RE: Intelligence While Writing the Queries

    pramod_yg (10/13/2009)

    Is there no way, i mean any add on's installation all all would help to achieve it?

    You can buy SQL Prompt from RedGate. It's around $300 iirc. In my...

    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

    October 13, 2009 at 1:23 am

    #1065054

  • RE: Database corruption / steps to fix issues

    Free-292871 (10/12/2009)

    I ran the dbcc checkdb('mydb', with no_infomsg, all_errormsgs) and got the following message.:

    Msg 8921, Level 16, State 1, Line 1

    Check terminated. A failure was detected while collecting facts. Possibly...

    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

    October 13, 2009 at 1:20 am

    #1065048

Viewing 15 posts - 36,316 through 36,330 (of 49,552 total)