About 26 Wiki Search Results
Showing 1 - 10
MSAS - Miscellaneous MDX Query Optimization Tips - SQLServerPedia
This section provides miscellaneous tips that might be helpful when optimizing
http://sqlserverpedia.com/wiki/MSAS_-_Miscellaneous_MDX_Query_Optimization_Tips
MDX queries. Unfortunately it is nearly impossible to quantify the amount of ...Using the Right Indexes for Optimal Performance - SQLServerPedia
Let's look first at Query Optimizer's default use of indexes. ... In Query 2, on
http://sqlserverpedia.com/wiki/Using_the_Right_Indexes_for_Optimal_Performance
the other hand, Query Optimizer uses a clustered index on PK where all ...Memory - Performance Counters - SQLServerPedia
Memory reserved for query optimization. Ideally, the value of this counter
http://sqlserverpedia.com/wiki/Memory_-_Performance_Counters
should remain relatively static. If this isn't the case you might be using ...Optimization Tips & Techniques - SQLServerPedia
SQL Server 2000 has come a long way as compared to its predecessors as far as
http://sqlserverpedia.com/wiki/Optimization_Tips_%2526_Techniques
sub-query optimization ...Db Config - Date Correlation Optimization Option - SQLServerPedia
SQL Server verifies that the re-written query will produce the same results as
http://sqlserverpedia.com/wiki/Db_Config_-_Date_Correlation_Optimization_Option
the original query. To enable date correlation optimization, ...MSAS 2005 Cubes - Usage Based Optimization - SQLServerPedia
Once you have configured the query logging you can examine queries that have
http://sqlserverpedia.com/wiki/MSAS_2005_Cubes_-_Usage_Based_Optimization
been executed against your server. The usage based optimization wizard allows
...MSAS - Setting up Query Log - SQLServerPedia
Furthermore, if you intend to use usage-based optimization wizard, you MUST log
http://sqlserverpedia.com/wiki/MSAS_-_Setting_up_Query_Log
queries into a SQL Server table. If you record query log in .trc file, ...Tuning Overview - SQLServerPedia
SQL Server has a built-in query optimizer that decides how to execute each
http://sqlserverpedia.com/wiki/Tuning_Overview
submitted query. Understanding how query optimizer works is often the key to ...MSAS - Partitioning Strategies - SQLServerPedia
Furthermore, MSAS can utilize multiple threads to query several ... the size of
http://sqlserverpedia.com/wiki/MSAS_-_Partitioning_Strategies
aggregations by aggregation design and usage-based optimization wizards. ...Performance Tuning - SQLServerPedia
SAN Performance Tuning with SQLIO · SQL Server Query Optimizer · SQL Server
http://sqlserverpedia.com/wiki/Performance_Tuning
Profiler - includes videos on how to get started with Profiler. ...
About 86 Blog Search Results
Showing 1 - 10
SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove ...
Oct 7, 2009 ... This article is follow up of my previous article SQL SERVER – Query Optimization
http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-%25E2%2580%2593-query-optimization-%25E2%2580%2593-remove-bookmark-lookup-%25E2%2580%2593-remove-rid-lookup-%25E2%2580%2593-remove-key-lookup-%25E2%2580%2593-part-2-2/
– Remove Bookmark Lookup – Remove RID Lookup – Remove Key ...SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove ...
Oct 6, 2009 ... Today, I would like to share one very quick tip about how to remove bookmark
http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-%25E2%2580%2593-query-optimization-%25E2%2580%2593-remove-bookmark-lookup-%25E2%2580%2593-remove-rid-lookup-%25E2%2580%2593-remove-key-lookup/
lookup or RID lookup. Let us first understand Bookmark lookup ...Recap: Performance Tuning and Query Optimization | SQLServerPedia
Jul 21, 2009 ... Tonight was our monthly SQL Server User Group meeting and our featured presenter
http://sqlserverpedia.com/blog/sql-server-bloggers/recap-performance-tuning-and-query-optimization-2/
this evening was Plamen Ratchev (Blog) presenting on ...SQL SERVER – Identifying Statistics Used by Query | SQLServerPedia
Jul 18, 2010 ... Can I know which statistics were used by my query?” Recently, someone asked this
http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-%25E2%2580%2593-identifying-statistics-used-by-query/
question in my training class of query optimization and ...SQL SERVER – Remove Bookmark Key Lookup – 4 Different Ideas ...
Nov 21, 2009 ... SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup –
http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-%25E2%2580%2593-remove-bookmark-key-lookup-%25E2%2580%2593-4-different-ideas/
Remove Key Lookup – Part 2 This article is follow up of my ...SQL SERVER – Stored Procedure Optimization Tips – Best Practices ...
Feb 15, 2010 ... SQL SERVER – Stored Procedure Optimization Tips – Best Practices ... DECLARE @
http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-%25E2%2580%2593-stored-procedure-optimization-tips-%25E2%2580%2593-best-practices-2/
Query VARCHAR(100) DECLARE @Age INT SET @Age = 25 SET @Query ...SQL SERVER – Introduction to Extended Events – Finding Long ...
Mar 28, 2010 ... The month before, I was busy doing query optimization and performance tuning
http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-%25E2%2580%2593-introduction-to-extended-events-%25E2%2580%2593-finding-long-running-queries/
projects for our clients, and this month, I am busy delivering ...SQLServerPedia
And there you have it, a join without an ON clause as far as the optimizer is
http://sqlserverpedia.com/blog/
concerned. By not qualifying all the columns in the sub-query we opened ...Book Review: SQL Server 2008 Query Performance Tuning Distilled ...
Apr 20, 2009 ... Recap: Performance Tuning and Query Optimization Tonight was our monthly SQL
http://sqlserverpedia.com/blog/sql-server-bloggers/book-review-sql-server-2008-query-performance-tuning-distilled/
Server User Group meeting... Recap: Performance Tuning and ...The effects of DISTINCT in a SQL query | SQLServerPedia
Jul 24, 2009 ... SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup –
http://sqlserverpedia.com/blog/sql-server-bloggers/the-effects-of-distinct-in-a-sql-query/
Remove Key Lookup Today, I would like to share one very quick ...