Category Archives: SQL Internals

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

SQL Script to find out 5 biggest transaction that uses internal objects

SQL Script to find out 5 biggest transaction that uses internal objects — ******************************************** */ — Description */ — ============ */ — Script to check the biggest transaction */ — that are using internal objects */ — If it is for internal objects (tempdb */ — issues), use the script bellow. It lists */ — [...]

How much database space is required during Index rebuild?

These are the Few Question, which every DBA want to get. How much temporary space is required to create or rebuild a index ? Whether it matters if you are creating/rebuilding a unique or a non-unique index ? Whether it matters if you are creating/rebuilding an index on a partitioned or a non-partitioned table ? [...]

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

Factor which Influence Index Rebuilt Strategy

Choosing options for an index create or rebuild involves deciding whether to do it online or offline, whether to use the temporary space in TEMPDB or in the user database Here is the summary of options for index rebuilding and their effects. ONLINE Concurrency Versioning Time SORT_IN_TEMPDB YES high Yes Slow YES YES high Yes [...]

Difference between sql_handle and plan_handle

After reading a post about DBCC FREEPROCCACHE with parameters, I got  a lot of question like What is sql_handle? what is plan_handle? How to find sql_handle and plan_handle? What is the difference between a sql_handle and plan_handle? Can we have a example to understand sql_handle and plan_handle ? Let me answer all these question, A [...]

How much space can be saved using SQL Server 2008 Data Compression feature ?

If you have the questions like How much space can be saved using SQL Server 2008 Data Compression feature ? How much space can be saved using Page Level compression ? How much space can be saved using Row Level compression ? How much space can be saved using Row Level compression as well Page [...]