Category: SQL Server

I’ve found there is a lot of confusion around the memory support of SQL 2012 Standard. Traditionally we see 2012 at 64GB and 2014 at 128GB and that is correct. However like most things in technology it depends. Yes SQL 2012 Standard has the 64GB Limit but the Limit only applies to the buffer pool.…

Danger Do NOT RUN DBCC CheckDB REPAIR_ALLOW_DATA_LOSS DBCC CHECKDB (‘DATABASENAME’, REPAIR_ALLOW_DATA_LOSS); NEVER run the command above on a production database. As it says you will most likely loose data. That syntax commands SQL to throw out any corrupted 8K Page. There can be lots of data in that page and there may be multiple pages…

DBCC CHECK DB Steve and I recently repaired SQL Database Corruption for a customer who wasn’t running DBCC Check DB on a regular basis. Please don’t do this. DBCC Check DB both needs to be run on a regular basis AND you need to be monitoring the results. It’s so important to know about corruption…