ERROR: Msg 2786, Level 16, State 1, Procedure sp_estimate_data_compression_savings, Line 20 The data type of substitution parameter 3 does not match the expected type …
Read More »Ekrem Önsoy
DMV: sys.dm_db_persisted_sku_features(Check Database Before Migration Between Editions)
In some projects or scenarios, we need to move some databases between different SQL Server editions. For example, in some organizations, SQL Server Evaluation …
Read More »How do successful backups not be saved in the Error Log
With a single command: [crayon-67532f20a1ddd450134754/] If you run this way, you will be opening this Trace Flag to Global, and even if your SQL …
Read More »The transaction log for database ‘dbname’ is full due to ‘LOG_BACKUP’
ERROR: Message Executed as user: DOMAIN\svc_SQLService. The transaction log for database ‘dbname’ is full due to ‘LOG_BACKUP’. [SQLSTATE 42000] (Error 9002) BACKUP DATABASE is …
Read More »How secure is the passwords of your SQL logins
I was doing some security work to make a SQL Server production environment safer and ready for inspections. I had more than 900 SQL …
Read More »The database dbname is not accessible
ERROR: The database dbname is not accessible. (Object Explorer) EXPLANATION: Actually, I wouldn’t write an article for this error, but when I saw that …
Read More »How Long Will CHECKDB Take to Run
The answer to this question depends on the size of the database that you are running this command, the parameters you will use with …
Read More »Identity Key Problem and DBCC CHECKIDENT
A colleague today said they received an error like this: Msg 2627, Level 14, State 1, Procedure SP_name, Line 33 Violation of PRIMARY KEY constraint …
Read More »Find the logical and physical database source that is experiencing IO problem
Interesting title, right? We may want to see the processes that are currently running, especially when there are problems. In these cases you can …
Read More »How do you know that a record is in Data Cache On SQL Server
How do you find out if a specific record in a particular table is in the Buffer pool / data cache or in the …
Read More »