Forum Replies Created

Viewing 15 posts - 15,421 through 15,435 (of 49,552 total)

  • RE: Is DBCC CHECKDB increase log size

    Clarification. Unless you're running it with a repair option when there is corruption.

    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

    November 29, 2012 at 12:07 pm

    #1563965

  • RE: autogrowth

    sqlfriends (11/29/2012)

    So, it doesnot send any kind of alerts to DBA proactively?

    If you've configured alerts, you get alerts. If not, you don't (how would SQL intuit who to send alerts...

    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

    November 29, 2012 at 10:53 am

    #1563935

  • RE: Too many statistics

    CREATE TABLE Blah (

    ID int identity,

    SomeDate DATETIME

    -- other fields

    )

    CREATE CLUSTERED INDEX idx_Blah on Blah (SomeDate)

    ALTER TABLE Blah ADD CONSTRAINT pk_blah PRIMARY KEY NONCLUSTERED (ID)

    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

    November 29, 2012 at 10:51 am

    #1563934

  • RE: Differential backups failing since we started VM

    What's the error?

    Are there any full machine backups running? Possibly via the VM host?

    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

    November 29, 2012 at 10:47 am

    #1563931

  • RE: Is DBCC CHECKDB increase log size

    Nope.

    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

    November 29, 2012 at 10:44 am

    #1563927

  • RE: Too many statistics

    MOC Ewez (11/29/2012)

    What is wise for a PK seems to be highly debated amongst the pros. Some say it should be a short as possible "Description" of what your 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

    November 29, 2012 at 8:20 am

    #1563821

  • RE: Performance issue

    Generally when dealing with a performance problem, knowing what tables are hit often is not very useful. Knowing what queries run often is.

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    November 29, 2012 at 8:06 am

    #1563804

  • RE: Too many statistics

    MOC Ewez (11/29/2012)

    Do you do this with or without shoes?:-)

    Without of course. 🙂

    What you want to do is compare the columns the stats are on and see if you have...

    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

    November 29, 2012 at 8:04 am

    #1563801

  • RE: Database Integrity and backup job failing.

    That's not a useful error. Log the job output to a file and check what's in the file.

    You can run integrity checks after taking a backup, but personally I prefer...

    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

    November 29, 2012 at 7:15 am

    #1563761

  • RE: Too many statistics

    MOC Ewez (11/29/2012)

    I guess i need a recursive CTE or pivot into # table then group by and count....???

    These are still weak spots for me. I think an overly dramatic...

    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

    November 29, 2012 at 7:13 am

    #1563758

  • RE: Sequence of events

    aaron.reese (11/29/2012)

    My question is , when the update script runs, does SQL update the indexes first, then update the physical records, or does it update the records first, then 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

    November 29, 2012 at 6:22 am

    #1563731

  • RE: Database Integrity and backup job failing.

    Well, the first thing that anyone trying to help needs to know is what's causing the jobs to fail. What's the error?

    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

    November 29, 2012 at 5:53 am

    #1563711

  • RE: pages

    Huh?

    What are you asking?

    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

    November 29, 2012 at 5:52 am

    #1563710

  • RE: Query returns more records than original records

    Please don't post multiple threads for the same problem. Can we perhaps keep everything in one thread - http://www.sqlservercentral.com/Forums/FindPost1390289.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

    November 29, 2012 at 3:52 am

    #1563655

  • RE: Low instance memory.....or is it.

    Nic-306421 (11/29/2012)

    I can't remember where I read it, but I thought the 'Process_Indicator' flag - which is 2 (sorry should have mentioned that) indicated its something within SQL Server itself....

    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

    November 29, 2012 at 3:19 am

    #1563632

Viewing 15 posts - 15,421 through 15,435 (of 49,552 total)