Sql Server: File cannot be shrunk as it is either being shrunk by another process or is empty

Posted by Sqltimes
On June 7, 2013
0 Comments

A few days ago, on one of the production database servers we ran into space issue. One of the databases, which is usually at 300 GB size with increase on 1 0r 2 GB per day increased to more than 500 GB in a couple of days. This is one of the critical servers that […]

Posted by Sqltimes
On June 3, 2013
0 Comments

A few weeks ago, as I was running some test on our Database Mirroring session in DBA environment (development for DBAs), I ran into this error: [sourcecode language=”sql”] Msg 1473, Level 16, State 6, Line 1 This SQL Server edition does not allow changing the safety level. ALTER DATABASE command failed [/sourcecode] My earlier (incorrect) […]

Posted by Sqltimes
On June 1, 2013
0 Comments

Sql Server is a complicated and efficient data storage and retrieval engine. It has many unique and fascinating techniques to make the overall engine more efficient. One such concept is Advanced Scanning. In any database, you’ll have many users running queries simultaneously. All queries, more or less, query the same set of tables in the […]

Sql Server: File cannot be shrunk as it is either being shrunk by another process or is empty

Database Mirroring: This SQL Server edition does not allow changing the safety level. ALTER DATABASE command failed

Miracles of Sql Server Storage Engine: Advanced Scanning (Enterprise Edition only)