SQL Server Education (by the geeks, for the geeks)
Dear Friends, Few weeks back, I blogged on SQL Server Transactions Deferred Transactions which I thought is not complete if I do not write on how we deal with them in general? To …
SQL Server Transactions – How to deal with Deferred Transactions? Read MoreDear Friends, Just think of a scenario when your system crashed and reboots unexpectedly. As your SQL Server restarts so it has to run recovery on all databases. Bad thing is …
SQL Server Deferred Transactions what are they? Read MoreDear Friends, Very recently while imparting training to junior DBAs someone from them asked me what are the different states of a database and how they can move into each stage? …
SQL Server Database States – simple talk but not simpler Read More