About 22 Wiki Search Results
Showing 1 - 10
SQL Server Troubleshooting Tips and Tricks - SQLServerPedia
This will minimize the impact of your ad-hoc queries by allowing dirty reads.
http://sqlserverpedia.com/wiki/SQL_Server_Troubleshooting_Tips_and_Tricks
While this can be beneficial for many production environments, ...SQL Server Profiler - SQLServerPedia
Most applications are composed of numerous stored procedures and ad-hoc queries.
http://sqlserverpedia.com/wiki/SQL_Server_Profiler
Examining each of these can be a daunting task. ...Memory - Performance Counters - SQLServerPedia
SQL Plans - query plans for ad-hoc Transact-SQL statements, or Transact-SQL
http://sqlserverpedia.com/wiki/Memory_-_Performance_Counters
statements prepared using sp_prepare or sp_cursorprepare system procedures. ...Built-in Functions - Rowset Functions - SQLServerPedia
Furthermore, before data can be retrieved using this function SQL Server 2005
http://sqlserverpedia.com/wiki/Built-in_Functions_-_Rowset_Functions
requires that configuration option Ad Hoc Distributed Queries have a value of
...Queries in Procedure Cache - SQLServerPedia
It's not uncommon for this query to take several minutes on a server with a
http://sqlserverpedia.com/wiki/Queries_in_Procedure_Cache
large number of ad-hoc queries in the procedure cache. ...Server-Level Configuration Options for 2005 - SQLServerPedia
Controls whether ad-hoc distributed queries are enabled. ... Ad hoc distributed
http://sqlserverpedia.com/wiki/Server-Level_Configuration_Options_for_2005
queries can be executed by using OPENDATASOURCE or OPENROWSET functions. ...Bloggers - SQLServerPedia
Marlon started working with SQL Server 2000 writing ad-Hoc queries as part of
http://sqlserverpedia.com/wiki/Bloggers
his tasks doing IT Support in a small document and information management ...Query Processing - Retrieving Information about Execution Plans ...
For ad hoc statements this is an internally generated identifier. ... view which
http://sqlserverpedia.com/wiki/Query_Processing_-_Retrieving_Information_about_Execution_Plans
returns aggregate performance statistics for cached query plans or from ...Query Processing - Caching Execution Plans - SQLServerPedia
Ad-hoc SELECT, INSERT, UPDATE and DELETE statements. ... The third query cannot
http://sqlserverpedia.com/wiki/Query_Processing_-_Caching_Execution_Plans
reuse the plan however, because the text of the third query is slightly ...Query Processing - Plan Guides - SQLServerPedia
Plan guides allow you to inject query hints to existing queries without
http://sqlserverpedia.com/wiki/Query_Processing_-_Plan_Guides
modifying ... Data Modification Language trigger or an ad-hoc SQL statement (
plan ...
About 72 Blog Search Results
Showing 1 - 10
Optimizing for Ad hoc Workloads | SQLServerPedia
Jul 6, 2010 ... If your workload involves a high number of ad hoc queries that are used only
http://sqlserverpedia.com/blog/sql-server-bloggers/optimizing-for-ad-hoc-workloads/
once, your plan cache (also known as the “procedure cache”) may ...adhoc plan cache, force parameterization | SQLServerPedia
Apr 29, 2008 ... SQL Server 2005, plan cache, becoming bloated with excessive amounts of adhoc
http://sqlserverpedia.com/blog/sql-server-bloggers/adhoc-plan-cache-force-parameterization/
queries with a usecount of 1, crashing the server.SQLServerPedia
Interesting, but to be useful we need to know what queries are causing the
http://sqlserverpedia.com/blog/
lookups. ... [dbid]), 'Unresolved') ELSE CAST('Ad-hoc\Prepared' AS SYSNAME) END
...Tracking Down Elusive Query Timeouts | SQLServerPedia
Dec 11, 2009 ... Timeouts on one particular type of ad-hoc query were reported. Our custom error
http://sqlserverpedia.com/blog/sql-server-bloggers/tracking-down-elusive-query-timeouts/
logging framework told us that these timeouts were coming in ...Identifying Frequently Running Queries | SQLServerPedia
Sep 21, 2009 ... You could group by these values to aggregate ad hoc queries that would, if they
http://sqlserverpedia.com/blog/sql-server-2005/identifying-frequently-running-queries/
were stored procedures, be identical executions and arrive ...Linked Server Provider Options | SQLServerPedia
Mar 17, 2009 ... Dynamic Parameters: If you have a lot of adhoc queries against linked servers
http://sqlserverpedia.com/blog/sql-server-bloggers/linked-server-provider-options/
this may be a good option to turn on along with forced ...T-SQL Tuesday #007 – Roundup | SQLServerPedia
Jun 14, 2010 ... Pretty cool feature to help cull down those resource-hungry queries from ad-hoc
http://sqlserverpedia.com/blog/sql-server-bloggers/t-sql-tuesday-007-%25E2%2580%2593-roundup/
queries. Rob Farley throws us for a loop as his favorite ...Retrieving Data From Excel | SQLServerPedia
Mar 29, 2010 ... The OPENROWSET() function expects that the 'Ad Hoc Distributed Queries' option
http://sqlserverpedia.com/blog/sql-server-bloggers/retrieving-data-from-excel/
is enabled on the server. When that's not the case you'll see ...VLDBs and Instant File Initialization | SQLServerPedia
Jul 9, 2009 ... Resource Governor Basics In very large databases, ad-hoc user queries can easily
http://sqlserverpedia.com/blog/sql-server-management/vldbs-and-instant-file-initialization/
run... Tom LaRock on Meet the Experts Tom LaRock (Blog ...Resource Governor Basics | SQLServerPedia
Jul 16, 2009 ... In very large databases, ad-hoc user queries can easily run on for minutes or
http://sqlserverpedia.com/blog/sql-server-2008/resource-governor-basics/
hours. Patient users often kick off long reporting queries and ...