Forum Replies Created

Viewing 15 posts - 20,461 through 20,475 (of 49,552 total)

  • RE: Please critique our SQL Server 2005 Backup Maintenance Plan

    Bru Medishetty (2/8/2012)

    I am assuming whoever has created the Maintenance plan and schedule might have created it such a way that both Full and Log backups do not run at...

    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

    February 8, 2012 at 1:19 pm

    #1444747

  • RE: Please critique our SQL Server 2005 Backup Maintenance Plan

    Why 5 schedules for the log backups? Just one schedule (every 5 minutes, all day) would be easier and less confusing if you need to restore.

    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

    February 8, 2012 at 12:28 pm

    #1444720

  • RE: Index fragmentation - please help very confused

    Not fragmented, it means that there is lots of free space on all of the pages. (yes, the docs refer to low page density as internal fragmentation, I personally dislike...

    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

    February 8, 2012 at 12:27 pm

    #1444719

  • RE: SQL Query to Locate New Records Added

    There is no DMV or view that tracks new records automatically.

    If you need to identify new records, you need something like an insert date column or triggers on the tables...

    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

    February 8, 2012 at 12:24 pm

    #1444717

  • RE: Mysterious Error on "Execute SQL Task"

    I'd prefer to see a full checkDB, or just get the results when the next scheduled integrity check runs.

    It may not be that, it's just that the disconnect can be...

    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

    February 8, 2012 at 12:03 pm

    #1444705

  • RE: ReportServerTempDB - simple mode, huge log file, open tran

    Kill the open transaction or wait for it to complete. Nothing else will have any impact on the log while there is an open transaction.

    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

    February 8, 2012 at 11:09 am

    #1444682

  • RE: Backup & Restore questions

    richardm-1037631 (2/8/2012)

    I'd read through the article about managing transaction logs previously, but still wasn't sure whether the full/differential backups would replace the need to do a log backup. Since...

    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

    February 8, 2012 at 10:57 am

    #1444675

  • RE: Need to tune SQL

    Sean Lange (2/8/2012)

    Cadavre (2/8/2012)

    At best, your post is like telling a car mechanic the make and model of your car, telling him it's broken, but without telling him in what...

    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

    February 8, 2012 at 9:15 am

    #1444605

  • RE: maxdop?

    GSquared (2/8/2012)

    If a shared connection suffers an error that closes the SPID (16 or higher, if I'm not mistaken)

    20 or higher. Below that they terminate the statement or the batch,...

    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

    February 8, 2012 at 8:18 am

    #1444554

  • RE: sys.index_columns Gives more than one row for PK Index

    I ran that on a testing database and saw exactly what I would expect.

    Can you post the output that's confusing 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

    February 8, 2012 at 8:15 am

    #1444550

  • RE: Backup & Restore questions

    Yes (and you'll want a domain account not a local user account)

    Maybe, though you shouldn't be just running a log backup after the full or diff for the sole purpose...

    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

    February 8, 2012 at 8:12 am

    #1444547

  • RE: Need to tune SQL

    kiran.rajenimbalkar (2/8/2012)

    So can you able just look to where i need to change something in the SQL?

    Not without what I asked for, no.

    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

    February 8, 2012 at 8:04 am

    #1444538

  • RE: Table Name as parameter

    Personally, I'd rather separate queries, or at most something like this:

    IF (@fiscalyear = '201120011')

    SELECT <column list> FROM tblMOR_LU_AdCpGp201120011

    IF (@fiscalyear = '201020011')

    SELECT <column list> FROM tblMOR_LU_AdCpGp201020011

    ....

    Otherwise 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

    February 8, 2012 at 7:32 am

    #1444511

  • RE: Need to tune SQL

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

    February 8, 2012 at 7:20 am

    #1444497

  • RE: What do these symbols do???

    Adding and subtracting values. The various fields apparently return numeric types and are been added and subtracted to get a total.

    Maybe it would be more understandable as such:

    (SELECT COALESCE (SUM(m.QtyOnHand),...

    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

    February 8, 2012 at 7:15 am

    #1444492

Viewing 15 posts - 20,461 through 20,475 (of 49,552 total)