Forum Replies Created

Viewing 15 posts - 1 through 15 (of 27 total)

  • RE: Restoring database A also tries to Restore database B

    This is not a bug, but expected behavior.  You said you ran the following command:


  • RE: SQL Server 2012 AlwaysOn Groups and FCIs Part 4

    Thanks for the informative article! I realize that this article is almost a year old, but I have a few questions that I'm hoping you can help me with.


  • RE: table size keep growing

    I've seen similar symptoms occur when deleting rows from a heap table (table with no clustered index). This describes the workaround:


  • RE: Need help helping my daughter with math

    how much acid required in final 3% mixture: 10oz * .03 = .3oz of acid

    how much of 10% mixture will it take to make .3oz of acid: x...

  • RE: Virtual Conversions

    We did some pretty intensive benchmark testing and found that our test workload (which included insert/select/update statements as well as bulk inserts, dbcc checkdb, and backups/restores) which was run using...

  • RE: identifying offline databases

    How about this:

    SELECT [name]

    FROM master.dbo.sysdatabases

    WHERE CAST(DATABASEPROPERTY([name], 'IsOffline') as int) = 1

    ORDER BY [name]

  • RE: How to verify DB is in use

    Another option would be to turn the database "auto close" option on for each database you want to monitor. Then a "starting up database xxxxx' message will be logged...

  • RE: Simple Insert Issue

    It's hard to tell what may have caused it after the fact, but I'd suspect blocking. 

    The log files don't show blocking, but you can use sp_who2 and look at...

  • RE: Simple Insert Issue

    did you check to see if the insert is being blocked by another spid?

  • RE: Unable to create login / Error 15401

    I believe that if your SQL Server was installed with a case-sensitive collation, the login name must be specified with the exact same case as how the Windows user account was...

  • RE: Windows 2003 SP2 & SS2000

    Maybe there's some confusion due to the fact that pre-SP2 versions of SQL Server are not supported on Windows 2003.

  • RE: Growing tables : same number of records

    It's not always possible to use TRUNCATE since you may not want to remove all rows, and it's not always feasible to use a TABLOCK hint due to blocking concerns. ...

  • RE: Growing tables : same number of records

    Not sure if this may apply to you, but there is a bug that prevents space from being released after a delete if the table doesn't have a clustered index.  This...

  • RE: Restore DB



    filelistonly from disk = 'D:\Microsoft SQL Server\test1'

    to see the logical and physical filenames...

  • RE: SP4 AWE Hotfix

    We've seen it not install on all nodes in a clustered environment.  It doesn't give an error says it was successful, but "select @@version" shows 8.00.2039 instead of 8.00.2040...

Viewing 15 posts - 1 through 15 (of 27 total)