Category Archives: SQL Optimization

The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information Error 8623 / 8632

The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer [...]

50 Database Optimization TIPS

Database Optimization TIPS helps any system to perform work efficiently and quickly. SQL Server Performance tuning is very wide subject and there are a lot of different pieces to troubleshoot a poor performing application. Connectivity / Network Server Hardware Operating System SQL Server Database Query The basic principle of Optimization / Tuning is Profile First [...]

DELETE | UPDATE with JOIN SQL Table

Summary : We can write all your UPDATE, DELETE query same way as we write SELECT Query [*Most of the time],  this means we can use also UPDATE / DELETE using JOIN as well. I am writing this because, Today I was working with my development team to fix some data. A task was being [...]

How to check Database Statistics are optimized for Performance ?

What is Statistics in SQL Server ? Statistics helps Query Optimizer to makes a decision to choose the fast good (best) way to execute a given query. Statistics decides, whether to choose  a particular index or not and build the execution plan. So if your stats are not updated then Optimizer might not choose the [...]

Can I run SQL Server 2005 32 bit on a Windows Server 64 bit ?

YES, we can run SQL Server 32 bit on windows server 64 bit platforms. Will there be any changes required in SQL Server Configuration or application to run SQL Server 32 bit on a Windows Server 64 bit ? NO, no changes are required to run SQL Server 32 bit on a Windows Server 64 [...]

New Features of SQL Server 2008

Here is the list of top 51 features of SQL Server 2008 which are present in SQL Server 2008 sales Boucher. My objective to cover all new features of SQL Server 2008 with detailed concept delivery with videos. Policy-Based Management Policy-Based Management is a policy-based system for managing one or more instances of SQL Server [...]

SQL Server 2008 Star Join Query Optimization

SQL Server 2008 will offer much more powerful relational data warehousing capabilities than its predecessor. As part of the development effort for the star join optimization in SQL Server 2008, Microsoft performed a number of performance studies based on benchmark and real customer workloads and made a significant enhancement. Star Join Query Optimization is a [...]