Forum Replies Created

Viewing 15 posts - 32,281 through 32,295 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (6/22/2010)

    Sorry, Gail, looks like SA is not moving on in the World Cup.

    🙁

    What a surprise. Not.

    At least we didn't lose every match we played.

    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

    June 22, 2010 at 10:05 am

    #1183450

  • RE: Database stuck "in recovery"

    yessen (6/22/2010)

    But everytime SQL Server needs to be restarted it goes into the same "recovery mode". I want to prevent this from happening and I can't because I have 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

    June 22, 2010 at 9:53 am

    #1183437

  • RE: Database stuck "in recovery"

    Firstly DUMP is deprecated and will be removed in a future version of SQL. Replacement is backup. Truncate_only (as an option for Backup Log) is also deprecated and 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

    June 22, 2010 at 9:51 am

    #1183436

  • RE: Unused Databases, Last accessed DB

    yehuda klein (3/31/2009)

    SELECT db_name(d.database_id),MAX(last_user_SCAN),MAX(last_user_Seek),MAX(last_user_lookup),max(last_user_update)

    from sys.databases d

    left join sys.dm_db_index_usage_stats i on d.database_id=i.database_id

    group by db_name(d.database_id)

    NB. That DMV is flushed when the DB is started. Offline/online, detach/attach, close/open, restore, restart of SQL...

    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

    June 22, 2010 at 9:46 am

    #1183431

  • RE: Are the posted questions getting worse?

    Grant Fritchey (6/22/2010)

    A little help over here would be appreciated

    What I said there wasn't strictly true based on his idea. afaik, the tran is only considered started (in the log)...

    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

    June 22, 2010 at 9:41 am

    #1183428

  • RE: Row level locking

    Grant Fritchey (6/22/2010)

    I'll see if I can't get others to comment on it as well.

    What happens if the user goes for lunch leaving the screen open, then decides to take...

    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

    June 22, 2010 at 9:32 am

    #1183423

  • RE: INSERT INTO SELECT WITH ORDER BY

    Eugene Elutin (6/22/2010)

    I do feel that it may be achievable, but it is hard to do.

    On an idle/barely used machine, yes it it. You need to simulate enough load for...

    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

    June 22, 2010 at 9:28 am

    #1183420

  • RE: Could not continue scan with NOLOCK due to data movement

    Are you using the nolock hint?

    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

    June 22, 2010 at 9:23 am

    #1183413

  • RE: Database stuck "in recovery"

    yessen (6/22/2010)

    Also someone advised to use: DUMP TRAN [database_name] WITH NO_LOG.

    Very bad advice. Please read through this - Managing Transaction Logs[/url]

    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

    June 22, 2010 at 9:20 am

    #1183409

  • RE: Database stuck "in recovery"

    Please query sys.databases. What's the exact value for state_desc for that database?

    Look in the SQL error log. Are there any recent messages/errors for that database? If so, post them please.

    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

    June 22, 2010 at 9:18 am

    #1183404

  • RE: INSERT INTO SELECT WITH ORDER BY

    As I said

    GilaMonster (6/22/2010)

    Yes, I've forced a table lock because SQL doesn't pick one automatically. Bear in mind that I'm running single user, single query on my laptop. On a...

    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

    June 22, 2010 at 9:03 am

    #1183397

  • RE: INSERT INTO SELECT WITH ORDER BY

    Attached is the execution plan, if anyone's interested. Both are simple clustered index scans, no other operators are present.

    The notable difference is the property of the clustered index scan...

    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

    June 22, 2010 at 6:08 am

    #1183262

  • RE: INSERT INTO SELECT WITH ORDER BY

    Eugene Elutin (6/22/2010)

    Sorry, of cause data is stored logicaly and retrieved in the logical order.

    There are conditions under which SQL can retrieve data in the physical order instead of 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

    June 22, 2010 at 6:04 am

    #1183259

  • RE: How to retrieve most recent records inserted in sql server 2005 db log?

    Karthik Palanivel (6/22/2010)

    ie. for past 1 hour what are all the table's records are affected in my database. it may be insert,update or delete.

    There is no automatic way to do...

    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

    June 22, 2010 at 5:56 am

    #1183253

  • RE: Restore with point in time

    Saravanan_tvr (6/22/2010)

    But still our one of DB guy asking up to last month database that's a way am asking , is its possible to give the database up to last...

    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

    June 22, 2010 at 5:49 am

    #1183248

Viewing 15 posts - 32,281 through 32,295 (of 49,552 total)