Forum Replies Created

Viewing 15 posts - 31,006 through 31,020 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/27/2010)

    Odd. I remember studying incremental backups when I took my SQL 2000 cert test.

    Me too, when I did the Windows server portion of the MCDBA. NTBackup has...

    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

    August 27, 2010 at 5:55 am

    #1212869

  • RE: Script to find Foreign Key missing Index?

    Please note: 2 year old thread.

    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

    August 27, 2010 at 5:45 am

    #1212863

  • RE: Backups

    As the error states:

    The database does not have valid owner.

    To continue, first use the Files page of the Database Properties dialog box or the Alter Authorization statement to set 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

    August 27, 2010 at 5:44 am

    #1212862

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/27/2010)

    They're working off of SQL 2000 (and prior) information. ... Even though 2000 had both.

    SQL 2000 didn't have incrementals. Just full, diff and log, like 2005+. I don't...

    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

    August 27, 2010 at 5:43 am

    #1212860

  • RE: DBCC SHRINKFILE Not Shrinking the Ldf file

    I'm confused. You said that shrinkfile isn't regaining space then you say the log isn't attached.

    Please explain the current situation and what (if anything) you've done so far to 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

    August 27, 2010 at 5:38 am

    #1212855

  • RE: DBCC SHRINKFILE Not Shrinking the Ldf file

    How full's the log? (DBCC SQLPERF(LOGSPACE) )

    What's the open tran info? (DBCC OPENTRAN)

    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

    August 27, 2010 at 4:24 am

    #1212834

  • RE: CTE - How to surpass the limit

    Quatrei.X (8/27/2010)

    Query costs relative to batch is 84% for the first one and 16% for the second.

    Those costs are estimates. There are lots of things that make the estimates wrong,...

    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

    August 27, 2010 at 2:57 am

    #1212809

  • RE: Database shutdown(close) programmatically

    You don't need to change a status in the system databases (you can't change system tables)

    Alter database ... set offline

    -- copy files

    Alter database ... set online

    Or, if you don't need...

    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

    August 27, 2010 at 1:37 am

    #1212785

  • RE: Know Backup Date using DB backup file

    Use RESTORE HEADERONLY. Should show start and finish dates for the backup

    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

    August 27, 2010 at 1:07 am

    #1212765

  • RE: How to know what are the most used store procedures and functions in a Data Base

    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

    August 26, 2010 at 6:21 pm

    #1212675

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (8/26/2010)

    716 (caffeine)

    Using a lot of that one tonight. Wait, it's morning already.

    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

    August 26, 2010 at 6:10 pm

    #1212667

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/26/2010)

    GilaMonster (8/26/2010)

    Since we seem to be sharing tales of woe, here's some things about the project I'm currently doing.

    <snip>

    And the senior architect wonders why we're not optimistic about...

    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

    August 26, 2010 at 5:30 pm

    #1212642

  • RE: Are the posted questions getting worse?

    Trey Staker (8/26/2010)

    Alvin Ramard (8/26/2010)

    Q: How would you schedule DB backups to be able to do a point in time recovery?

    A: For example, weekly full backup, daily log backups, and...

    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

    August 26, 2010 at 4:55 pm

    #1212626

  • RE: SQL SERVER 2000 Insert SQL with Sub Query not working

    Lennie (8/26/2010)

    One of the help name is pussycat59.

    Nope, it's happycat59.

    If you look at the earlier responds you will notice it.

    Make it your practice to view earlier posting inorder to understand...

    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

    August 26, 2010 at 4:33 pm

    #1212613

  • RE: Performance -Blocking and Deadlocks

    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

    August 26, 2010 at 4:30 pm

    #1212612

Viewing 15 posts - 31,006 through 31,020 (of 49,552 total)