During a consulting session on SQL Server building blocks, a DBA asked me about pages. Here is how to identify Page Types in your database, back to basics.
MySQL – FOUND_ROWS() Function for Total Number of Rows Affected
In SQL Server you get the number of rows affected with @@ROWCOUNT. In MySQL, you can find the total number of rows with FOUND_ROWS().
Error 112 Not Enough Space: Compressed Backup Fails at Random
Error 112 not enough space on the disk failed a client’s backups at random, even though free space looked fine. The cause was how compressed backups pre-allocate the file. Trace flag 3042 fixed it, and a simple free-space rule of thumb helps.
SQL SERVER – Network Name resource fails to come online in a Windows Server 2008 R2 Failover Cluster
After adding a new disk, a client’s cluster Network Name resource would not come online in a Windows Server 2008 R2 Failover Cluster. Here is what we found.
SQL SERVER – Drive Space Full Due to MDMP Files
A client’s C drive kept filling up, and the transaction log was not to blame. SQL dump files were. Here is what caused this Drive Space Full issue.
Master Database in SQL Server: What It Holds and How to Protect It
The master database is the one database a SQL Server instance cannot start without. It stores logins, linked servers, server settings and the list of databases. The tests here show what master holds, what it does not, how to back it up with CHECKSUM, how to check the backup, and what a master restore involves.
What is ACID Property in Database? – Interview Question of the Week #066
What is the ACID Property in a database? A classic interview question, with Atomicity, Consistency, Isolation and Durability explained in plain words.