While updating the permission setting for the folder, the permission setting update failed for the file with the error REBUILDDATABASE.
Plan Cache Memory by Cache Store: Where Plans Use Your RAM
Break down plan cache memory by cache store and object type, compare memory clerks, and investigate unused plans without cache clearing.
SQL SERVER – The Future of DevOps for DBA
Unless you live under a rock, you have heard the word DevOps. Here I define it simply and share my thoughts on the future of DevOps for the DBA.
Index Slows Down SELECT? What an Unused Index Costs You
An index slows down SELECT queries only in small ways when the plan never reads it. This post measures compile memory with twelve unused indexes, shows the plan change when a related index appears, and counts what every insert and update pays. The real bill arrives on writes.
Every Second Item Free: Pricing Promotions With ROW_NUMBER
Price every second item as free with ROW_NUMBER, expand quantities into units, and calculate basket discounts without double counting.
When was Table Accessed Last By User? – Interview Question of the Week #226
When was a table accessed last by a user? When clients say a table is rarely used, I run this report to check before we create or drop indexes.
SQL SERVER – REBUILDDATABASE Error: 0x851A0012 – Missing sa Account Password. The sa Account Password is Required for SQL Authentication Mode
The plan was to first rebuild system databases and then restore ALL databases from the backup. Today we will discuss an error about REBUILDDATABASE.