Forum Replies Created

Viewing 15 posts - 45,646 through 45,660 (of 49,552 total)

  • RE: Locking problem...

    ashok (7/16/2008)

    I'm not sure why the ROWLOCK is locking the complete table instead of the row...

    * My table DOES NOT contain any Indexes...

    If you have no indexes, then a read...

    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

    July 16, 2008 at 8:31 am

    #843811

  • RE: Restore database

    DTS packages are not stored in any of the user databases. They're stored in MSDB and backed up and restored along with that database, not the user 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

    July 16, 2008 at 8:29 am

    #843808

  • RE: descrepency between sys.indexes and sys.dm_db_index_usage_stats

    Also sysindxes shows statistics, while sys.dm_db_index_usage_stats won'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

    July 16, 2008 at 8:28 am

    #843806

  • RE: Log File Full

    And don't truncate the log unless you are willing to throw log records away and lose the ability to do point in time recovery until another full/diff backup is taken.

    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

    July 16, 2008 at 8:15 am

    #843798

  • RE: Prod Server ... High CPU with Lastwaitype "SOS_SCHEDULER_YIELD"

    I'd start by fnding out what those queries are running.

    You can get the query/proc using the sys.dm_exec_requests and sys.dm_exec_query_text dmvs.

    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

    July 16, 2008 at 8:13 am

    #843796

  • RE: How do I reduce or eliminate logging?

    rinu philip (7/16/2008)

    Hi, here's an example to explain : DBCC SHRINKFILE(testlog, 3)

    Now if the target size is not reached with the above command, we can go on to truncate 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

    July 16, 2008 at 1:31 am

    #843570

  • RE: How to obtain list of queries executed on SQL Server

    Please don't cross post.

    Also asked (and answered) here:

    http://www.sqlservercentral.com/Forums/Topic534754-1291-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

    July 16, 2008 at 1:25 am

    #843565

  • RE: How to get a history of queries executed by SQL Server

    Refer to thread:

    http://www.sqlservercentral.com/Forums/Topic534754-1291-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

    July 16, 2008 at 1:24 am

    #843564

  • RE: LOG File Growth

    rinu philip (7/16/2008)

    Hi,

    what does 'log_reuse_wait_desc' --mean?

    I explained it above.

    Its the reason that the space in the log file is not been reused and hence the log is growing

    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

    July 16, 2008 at 1:20 am

    #843562

  • RE: How do I reduce or eliminate logging?

    rinu philip (7/16/2008)

    After shrinking the log then a trucate will get more space.:)

    Explain what you mean there 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

    July 16, 2008 at 1:19 am

    #843561

  • RE: Restoring differential backup on other server

    GilaMonster (7/16/2008)[hr

    If you need to restore that database to a point after Tranlog backup 12, the restore paths are:

    Full 1, Diff 2, Tran backups 5,6,7,8,9,10,11,12

    Or

    Full 2, Diff 4, Tran backups...

    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

    July 16, 2008 at 1:18 am

    #843559

  • RE: sql server 2005 stops every night

    Anythng in the SQL error log from the time of the stop?

    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

    July 16, 2008 at 1:16 am

    #843557

  • RE: Restoring differential backup on other server

    Abhijit (7/16/2008)

    It menas if i'll not take the full2 then I can restore the database in below sequece...

    Full 1, Diff 4, Tran backups 11,12

    correct?

    Yes, if full 2 was 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

    July 16, 2008 at 1:14 am

    #843556

  • RE: Index strcture

    Abhijit (7/16/2008)

    Now want to build the indexing strategy on both tables. could anyone help me out in this?

    Not enough information.

    Are there any foreign keys? How are you going to 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

    July 16, 2008 at 1:13 am

    #843553

  • RE: How do I reduce or eliminate logging?

    Abhijit (7/16/2008)

    In this case instead of trncating the logfile if i'll shrink the log file what will happen?

    Provided there's unused space within the log file, the size of the file...

    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

    July 16, 2008 at 1:07 am

    #843549

Viewing 15 posts - 45,646 through 45,660 (of 49,552 total)