Percy Reyes

Understanding SQL Server's internal architecture and components, such as the Relational Engine, Storage Engine, indexes, and locking mec...

The SQL Server Query Optimiser is a crucial component of Microsoft SQL Server, responsible for determining the most efficient way to execute...

Beyond all doubt, not every single database in the world has a DBA dedicated to monitoring it 24x7 hours. Moreover, many database environmen...

Developing useful scripts for administration purposes, I have found a bug with respect to data recollected by 'sys.dm_exec_requests'...

The collations Modern_Spanish and Latin1_General are both Windows collations and support the same character set (Code Page 1252), but there ...

Behind close doors of SQL Server, the following issue may be raised when Transactional Replication and Change Data Capture (CDC) are deploye...

Today's post is going to look into some concepts about the well-known tempdb database. As DBAs, we have to keep an eye on it not only at...

Just one hour ago one of my tips was published at MSSQLTips.com related to “Error 601: Could not continue scan with NOLOCK due to SQL Server...

My latest tip has been published today at mssqltips.com about “SQL Server Replication Error – The specified LSN for repldone log scan occurs...