Sql Server: ALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Posted by Sqltimes
On August 23, 2013
0 Comments

A quick one: In my lab environment, I burn through a good set of databases frequently. I create a new one, play with it for the task needed; When done, DROP it. Sometimes the ‘DROP DATABASE’ command fails with this reason. Msg 3702, Level 16, State 4, Line 1 Cannot drop database "DBADB" because it […]

Posted by Sqltimes
On August 20, 2013
0 Comments

All night today (actually tonight), we’ve been on a production deployment call. One piece of the puzzle that, we assumed, but did not take into account is the switch back from SIMPLE to FULL recovery model. The required steps that need to be done after we make the switch back to FULL. We need to […]

Posted by Sqltimes
On August 5, 2013
0 Comments

This is an interesting wait type. When you run Paul Randall or Glenn Berry’s query to capture top wait stats you can get a good picture of where is Sql Server experiencing the most waits. Since these are based on DMV’s they only give this since the last SQL was restarted. But this is a […]

Posted by Sqltimes
On August 1, 2013
0 Comments

When you run a long running query, sometimes you might get lucky enough to capture hobit_id pop up in the Activity Monitor. This is interesting. Run a long running query, when it is waiting for the data pages to be pulled into memory you see the wait like PAGELATCHIO or LCK_M_X in the ‘Wait Type’ […]

Sql Server: ALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE

SQL Server: after changing recovery model from SIMPLE to FULL perform a FULL database backup

Sql Server Wait Types: ASYNC_NETWORK_IO

Sql Server: What is a hobt_id