Percy Reyes

While SQL Server provides automatic statistics management, manually updating statistics allows for greater control over database performance...

SQL Server query hints are directives that can be included in your SQL queries to guide the SQL Server Query Optimiser in executing them. Ty...

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

Undoubtedly, poor cursor usage is a critical issue to review in order to mitigate the risk of CPU bottlenecks and to assess whether cursors ...

SQL Server 2022 brings a wealth of new features that empower DBAs to enhance database performance, security, and usability. By leveraging th...

I have never worked for Microsoft, but SQL Server has given me a lot in terms of learning, community and opportunities, all these together h...

Monitoring the state of database statistics is crucial because they significantly influence overall performance. When statistics become outd...

Not having another way of fixing some specific errors, at times some people may consider turning off any ANSI database options as a final s...

Without any shadow of a doubt, one of the procedures to follow in order to monitor and diagnose performance issues of a database server is t...

While migrating databases to new versions of SQL Server, there are some tasks that need to be carried out in order to warrant strong consist...

The AUTO_CLOSE database option is only one of the many options related to performance and availability of the database in SQL Server.  When ...

Having .NET Applications working with SQL Server, some unforeseen timeout errors can be raised for two possible causes: bad-written SQL code...

Undoubtedly, recompilation is a big topic to reckon with, more importantly, in database environments processing data that is changing rapidl...

It is said that indexes are extremely useful to boost the performance of databases, especially indexes on huge tables. I am in agreement wit...

Without a shadow of a doubt, at times while working on optimising not only database performance but also hard disk usage, we have to face wi...

Traditionally, we were used to getting only basic runtime performance stats per operator regarding to CPU, I/O and Memory, which were not go...

Naturally, as DBAs we do know is mandatory to modify data and log properties of the tempdb database . Unless we do a customized configuratio...

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...

My latest tip was published today at MSSQLTips.com, you can read it at http://www.mssqltips.com/sqlservertip/3392/microsoft-sql-server-2014-...

It is known that ORDER BY clause has been improved in 'Denali' (code name of the upcoming version SQL Server 2012) adding more optio...