In a side-by-side upgrade, SQL Server 2012 installs either along with SQL Server 2008 (or 2005) as a separate instance or on a different server. Learn what’s involved in performing this type of upgrade.
Read More
After you start an in-place SQL Server 2012 upgrade there is no simple rollback procedure. Learn what’s involved in performing this type of upgrade.
Read More
Sometimes the USE PLAN N query hint is used to solve deadlock issues or other data-related problems. This can provide a quick workaround to keep the system running while the root cause of a problem is found and fixed.
Read More
The RECOMPILE query hint is a more granular way to force recompilation in a stored procedure to be at the statement level rather than using the WITH RECOMPILE option.
Read More
The OPTIMIZE FOR hint enables you to specify which values you expect to see most commonly at runtime, and it can result in better performance for the majority of the queries.
Read More
On systems where parallel plans are possible, and in the case of a query where a parallel plan is being generated, using MAXDOP (n) allows the Query Optimizer to use only n workers.
Read More
The JOIN query hint applies to all joins within the query. While this is similar to the join hint that can be specified for an individual join between a pair of tables within a large more complex query, the query hint applies to all joins within the query, whereas the join hint applies only to the pair of tables in the join with which it is associated.
Read More
Use the FAST number_rows query hint when you want to retrieve only the first n rows out of a relatively large result set.
Read More
Query hints are an easy way to influence the actions of query optimization. However, you need to very carefully consider their use, as in most cases SQL Server is already choosing the right plan.
Read More
Query processing is performed by the Relational Engine in SQL Server. SQL Server takes four steps to process a query: parsing, algebrizing, optimizing, and execution.
Read More
There are five key elements of a successful DevOps program to enhance collaboration between DBAs and database developers and shorten time to market.
Read More
Advice from virtualization vendors about how to configure demand-based memory allocation technology for SQL Server varies, and its important to know how it can impact performance.
Read More