Forum Replies Created

Viewing 15 posts - 10,756 through 10,770 (of 49,552 total)

  • RE: Performance issues with SP

    sree-226516 (12/3/2013)

    Recompile is not creating new execution plan also its not solving the issues.Only after I run update stats,execution time comes back to normal.

    Then you may need to schedule that...

    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 3, 2013 at 2:41 pm

    #1670548

  • RE: 6 hours for a delete task???

    If you cancel it, the delete has to roll back. That might well take more than 6 hours.

    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 3, 2013 at 2:38 pm

    #1670545

  • RE: Database restoring,,,,, since 20 hrs

    dan-572483 (12/3/2013)

    What happens if you run this command while a database is actually in the process of restoring?

    Nothing, because the running restore will have an exclusive lock on the database.

    Is...

    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 3, 2013 at 2:18 pm

    #1670540

  • RE: .bak file larger than .mdf file

    Do you have transactional replication configured on that database? Don't assume, check the replication folder in SSMS. Is there a transactional replication publication there for this database?

    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 3, 2013 at 2:34 am

    #1670305

  • RE: .bak file larger than .mdf file

    PravB4u (12/3/2013)

    select log_reuse_wait_desc from sys.databases Where database_id =YOURDBID

    pass database id and you'll get single row output.

    Far easier to filter by the database name.

    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 3, 2013 at 2:31 am

    #1670301

  • RE: .bak file larger than .mdf file

    amandac (12/3/2013)

    If I run

    use %databasename%

    then the select command, will this give me the correct result?

    Well, it'll give you correct results, but it won't give you want I asked for. It's...

    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 3, 2013 at 2:30 am

    #1670300

  • RE: .bak file larger than .mdf file

    Not for every database on the server, that's a pretty meaningless list without the DB names. What is the log_reuse_wait_desc for that database? For the specific database you're having problems...

    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 3, 2013 at 2:20 am

    #1670292

  • RE: .bak file larger than .mdf file

    GilaMonster (12/3/2013)

    What is log_reuse_wait_desc for that database (from sys.databases)?

    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 3, 2013 at 2:14 am

    #1670290

  • RE: .bak file larger than .mdf file

    No, that wouldn't have caused a problem.

    What is log_reuse_wait_desc for that database (from sys.databases)? Are you sure you're not making multiple backups to the same file (appended)?

    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 3, 2013 at 2:00 am

    #1670286

  • RE: Twice join same table with left join issue

    Please don't cross post. It just wastes people's time and fragments replies

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1519100-391-1.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

    December 3, 2013 at 1:58 am

    #1670285

  • RE: FAIL_VIRTUAL_RESERVE 65536 - both -g & -T845, is it OK?

    It has no effect on 64 bit because it's not needed. On 32 bit, a process only had a 2GB virtual address space (or 3GB with /3GB). the -g flag...

    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 3, 2013 at 12:44 am

    #1670279

  • RE: .bak file larger than .mdf file

    happycat59 (12/2/2013)

    Full backups and differential backups don't backup data that is in the transaction log. They contains pages that exist in the various .mdf and .ndf files (the data...

    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 2, 2013 at 11:49 pm

    #1670274

  • RE: Restore database issue

    Damaged backup. Get a fresh backup from the 2005 server.

    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 2, 2013 at 11:36 pm

    #1670271

  • RE: FAIL_VIRTUAL_RESERVE 65536 - both -g & -T845, is it OK?

    -g has no effect on a 64-bit SQL instance. It's for 32 bit only.

    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 2, 2013 at 11:35 pm

    #1670270

  • RE: How to access the database if I am not an administrator?

    That requires the View Server State permission. It has nothing to do with how you log in, you just need the login you use to have that permission.

    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 2, 2013 at 9:52 pm

    #1670259

Viewing 15 posts - 10,756 through 10,770 (of 49,552 total)