Forum Replies Created

Viewing 15 posts - 30,316 through 30,330 (of 49,552 total)

  • RE: T-log Backup Size - same as DB

    Is there an index rebuild job running between 1am and 3am?

    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

    September 29, 2010 at 1:37 am

    #1228792

  • RE: Created Full Backup for User Defined Databases To Disk with Restore Verify Only option

    Just note that, unless the backup is taken with the CHECKSUM option, Verify does not guarantee that the backup will be restorable. It checks mostly the headers of the backup.

    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

    September 28, 2010 at 11:54 pm

    #1228770

  • RE: SSRS 2008 error - Sys.WebForms.PageRequestManagerServerErrorException: status code 12029

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

    September 28, 2010 at 11:51 pm

    #1228768

  • RE: How to find Index size in Sql 2000

    sys.dm_db_index_physical_stats is a SQL 2005 view, it's not available in SQL 2000.

    Use DBCC SHOWCONTIG. As one of the output columns it has 'pages scanned'

    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

    September 28, 2010 at 11:50 pm

    #1228767

  • RE: Know how old an execution plan is

    It's in sys.dm_exec_query_stats

    Be careful, there's a 1-many relationship between sys.dm_exec_cached_plans and sys.dm_exec_query_stats. Group by the plan handle.

    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

    September 28, 2010 at 2:45 pm

    #1228667

  • RE: cannot start sql services help!!!

    Those events are from 6 days ago. I hardly think they're relevant here.

    Is that the latest error log file and is it for the correct instance? The server and...

    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

    September 28, 2010 at 2:06 pm

    #1228649

  • RE: cannot start sql services help!!!

    DBA-640728 (9/28/2010)

    i can't start the instance, i can't see the sql error log for the instance I can't start

    It's just a text file. Open it in notepad. Latest one will...

    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

    September 28, 2010 at 1:03 pm

    #1228621

  • RE: sp_refreshview

    Yes, if you drop columns. Refreshview will throw an error if the view is no longer valid. Better to find out then than at a later date when someone queries...

    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

    September 28, 2010 at 12:35 pm

    #1228603

  • RE: cannot start sql services help!!!

    Check the SQL error 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

    September 28, 2010 at 12:16 pm

    #1228583

  • RE: sp_refreshview

    Schema changes

    The data that a view shows changes as the table's data changes, because the view is just a stored select statement. If the table's schema changes in such 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

    September 28, 2010 at 12:16 pm

    #1228582

  • RE: DMV sys.dm_exec_sessions lists Multiple SA Logins

    Did you exclude system processes? (WHERE is_user_process = 0)

    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

    September 28, 2010 at 12:12 pm

    #1228577

  • RE: Why separate data, log and backups on SAN?

    Please post new questions in a new thread. Thanks

    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

    September 28, 2010 at 12:02 pm

    #1228574

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (9/28/2010)

    I am not sure I've had many projects at all in my lifetime that were on budget/on time unless they were trivial (< 1 week). It...

    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

    September 28, 2010 at 10:23 am

    #1228514

  • RE: Msg 8152, Level 16 Error

    One of the values you are trying to insert is too large for the column.

    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

    September 28, 2010 at 8:52 am

    #1228434

  • RE: Moving Database Files Detach/Attach or ALTER DATABASE?

    jswong05 (9/28/2010)

    There is no magic, it is suggested you fool the engine by renaming mdf file or use backup file. You lost what is in the transaction log that hasn'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

    September 28, 2010 at 8:37 am

    #1228418

Viewing 15 posts - 30,316 through 30,330 (of 49,552 total)