Forum Replies Created

Viewing 15 posts - 10,606 through 10,620 (of 49,552 total)

  • RE: Log File too Big

    How it got so big: You aren't running regular log backups. In full recovery model only log backups mark the log as reusable, so you need to schedule them. Full...

    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

    December 19, 2013 at 10:25 am

    #1674922

  • RE: Backup question

    No point. In fact, unless losing 24 hours work off dev is unacceptable, there probably doesn't need to be diffs and logs, or maybe weekly fulls and daily diffs.

    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

    December 19, 2013 at 8:04 am

    #1674831

  • RE: Log File too Big

    JimS-Indy (12/19/2013)

    My backup package does a full backup (including logs), then a db integrity check, then truncates the logs. I will read your link. Thank you.

    A full backup does not...

    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

    December 19, 2013 at 7:40 am

    #1674817

  • RE: Log File too Big

    Full backups do not truncate the log.

    If the database is in full recovery, you need to be running log backups. If you don't need point in time recovery, switch to...

    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

    December 19, 2013 at 7:36 am

    #1674813

  • RE: How to avoid KeyLookpu in Execution Plan of a Query ?

    prabhu.st (12/19/2013)

    what I replied exactly to the Interviewer is, "Appending all the Columns into the INCLUDE option will not be a right decision, Instead, we can try tune up 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

    December 19, 2013 at 6:40 am

    #1674788

  • RE: date between in procedure

    Don't convert dates to strings for comparisons, just going to make a mess. Compare dates with dates, it's efficient and you're not going to run into problems with formats

    Are 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

    December 19, 2013 at 5:29 am

    #1674767

  • RE: How to avoid KeyLookpu in Execution Plan of a Query ?

    prabhu.st (12/19/2013)

    so I request you guys to give me a best way were I can find a Moderate(Optimized) for all Queries on the table,

    Don't. While it is possible to 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

    December 19, 2013 at 4:45 am

    #1674763

  • RE: Help please? Tried moving installation directory of Cheftec (old restaurant management software) and broke the database(?)

    jhaddow (12/19/2013)

    After transferring the files to the new computer, the program worked fine for nearly a year. This was simply copying the .mdf and .ldf files that seem to...

    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

    December 19, 2013 at 12:42 am

    #1674717

  • RE: Help please? Tried moving installation directory of Cheftec (old restaurant management software) and broke the database(?)

    SQL Server is not a file-based database. Moving the files isn't enough. Someone (preferably someone with a mediocre of SQL knowledge) needs to log into the SQL instance on 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

    December 18, 2013 at 11:53 pm

    #1674709

  • RE: Performance degrades after significant insert/delete workload

    burtsev (12/18/2013)

    Table has no indices,

    There's your problem right there. Identify most common queries, index to support them, have a good clustered index.

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    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

    December 18, 2013 at 10:13 pm

    #1674701

  • RE: Doubt in error handling

    That's the less problematic part of it.

    From books Online:

    Missing and Double Reads Caused by Row Updates

    Missing one or more rows that were not the target of update

    When you are using...

    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

    December 18, 2013 at 6:42 am

    #1674402

  • RE: Doubt in error handling

    vignesh.ms (12/18/2013)

    Im a newbie .. I dont know the downsides and side effects of nolock..

    So why do you use it if you don't know what it does?

    Could 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

    December 18, 2013 at 6:23 am

    #1674392

  • RE: Improve Performance -Update query with OR in WHERE

    Could you post the execution plans please, not pictures of the plans?

    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

    December 18, 2013 at 6:04 am

    #1674382

  • RE: attach database from sql2008r2 to sql2008

    Right click database -> tasks -> generate scripts.

    Don't script the data, use import/export once you've created the database on SQL 2008.

    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

    December 18, 2013 at 6:02 am

    #1674379

  • RE: attach database from sql2008r2 to sql2008

    Can't be done.

    A SQL 2008 R2 database can only attach to SQL 2008 R2 or SQL 2012. SQL Server does not allow downgrading of database versions

    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

    December 18, 2013 at 4:14 am

    #1674332

Viewing 15 posts - 10,606 through 10,620 (of 49,552 total)