Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Monitor query performance with the SQL Server 2005 procedure cache
- In SQL Server 2005, you only need to recompile the statements inside stored procedures. This is much different than SQL Server 2000, where the entire procedure or batch may be recompiled. The benefit to the statement level recompile in SQL Server 2005 is that typically just a few statements inside...
- Tags: Monitor, Procedure, Performance, Microsoft SQL Server, Statement, Database Engine, Microsoft SQL Server 2005, Execution Plan, Tim, Databases, Storage, Enterprise Software, Software, Data Management, Hardware, Tim Chapman
- Blog posts 2008-01-17
- Capture execution plans with SQL Server 2005 Profiler
- Execution plans are one of the best tools for diagnosing problem queries and for performance tuning queries on your SQL Server. Prior to SQL Server 2005, the only options for query executions were text plans or graphical execution plans for queries run by hand. In SQL Server 2005, you can...
- Tags: Event, Microsoft SQL Server, Trace, Microsoft SQL Server 2005, Option, Execution Plan, SQL Server Management Studio, Tim, Databases, Storage, Enterprise Software, Software, Data Management, Hardware, Tim Chapman
- Blog posts 2008-01-14
- See SQL Server graphical execution plans in action
- Execution plans are one of the best tools to use to tune your SQL Server queries. In this article, I identify a few basic things to look for in a graphical execution plan to help you better understand how SQL Server uses indexes. I also offer ideas about how to...
- Tags: Query, Microsoft SQL Server, Data, Server, Column, Index, Speed, Table, Execution Plan, SalesHistory, SaleID, SaleDate, PoolTable, Product, Bookmark Lookup, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2007-10-01
- Format EXPLAIN PLAN results easily with Oracle's DBMS_XPLAN
- When you need to troubleshoot inefficient SQL, one of the most important diagnostics tools at your disposal is the output of the EXPLAIN PLAN command. Find out how Oracle's DBMS_XPLAN functions can help you tune your SQL statements. One of the most important diagnostic tools in troubleshooting inefficient...
- Tags: Oracle Corp., SQL, DBMS_XPLAN.DISPLAY, Databases, Bob Watkins, Programming languages, execution plan, Explain Plan, SQL Statement, PLAN_TABLE, DBMS_XPLAN, Oracle Tips Newsletter, Listing B, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2006-05-16
- Understanding SQL Server's WITH RECOMPILE option
- Dynamic St ProcWell i guess that's the problem with only Dynamic Stored Procedure... It looks ur suggestion fits best to dynamic SP... Otherwise If SP has to work with just static veiw of relational schema in Normal Stored procedure, it should not be recompiled everytime as it might degrade the...
- Tags: naishaltopiwala@..., server, software, sproc
- Discussion threads 2005-04-12
- Database management: Create a proper development environment for Oracle SQL
- In order to provide a consistent SQL execution environment in Oracle there are a number of environmental issues that should be addressed. By ignoring these issues you invite instability, acknowledged by ever-changing SQL execution plans, resulting in poor database query performance.Successful use of Oracle’s Cost-Based Optimizer CBO is heavily dependent...
- Tags: Programming languages, Databases, database management, database, Donald Burleson, development environment, SQL, execution plan, Oracle Corp., outline, Cost Based Optimizer, SQL execution plan
- Technical articles 2003-12-29
- Achieve faster SQL performance with dbms_stats
- When a SQL statement is executed, the database must convert the query into an execution plan and choose the best way to retrieve the data. For Oracle, each SQL query has many choices for execution plans, including which index to use to retrieve table row, what order in which to...
- Tags: Programming languages, Databases, Donald Burleson, Oracle Corp., execution plan, SQL
- Technical articles 2003-08-19
- Tune your SQL Server scripts with Query Analyzer
- I like to think of the bundled SQL Server tools as an inverted pyramid with tools for diagnosing and reviewing general issues at the top, and those for finding and diagnosing specific areas of concern at the bottom. Besides providing a handy way to write SQL scripts, Query Analyzer is...
- Tags: Databases, Microsoft SQL Server, Query Analyzer, execution plan
- Technical articles 2003-03-26
- Boost Oracle performance with intelligent optimizer limits
- The most important component of Oracle SQL execution time is the time spent preparing a new SQL statement for execution. But by understanding the internal mechanisms of the generation of the execution plan, you can control the amount of time Oracle spends evaluating table join order, and boost the performance...
- Tags: Programming languages, Databases, performance, optimizer_max_permutations initialization parameter, Donald Burleson, SQL, Oracle Corp., SQL Statement, execution plan, optimizer, optimizer_search_limit
- Technical articles 2003-02-11
Additional Resources
- Query Plan (zip)
- Priodata Query Plan is a front-end to the most commonly used V$ views to investigate SQL execution performance in the Oracle Database. You can browse the shared cursor area looking for low-performance SQL, see all information related (taken from V$SQL view) and the complete SQL statement and its execution plan...
- Tags: SQL, Priodata Query Plan, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2006-03-21
- Strategic Planning: A Vision and Roadmap to Prosperity
- This paper focuses on the value of the V-O-E (Visioning/Strategic Planning, Organization and Execution) approach toward corporate prosperity. More specifically, a proven, successful approach toward Strategic Planning is introduced. Using the fruit bowl analogy, Strategic Planning provides the context within which the business operates. That approach includes a discussion of...
- Tags: Prosperity, Vision, Strategic Planning, Strategy, Management
- White papers 2006-03-01
- Cost Control: Inside the Oracle Optimizer
- Oracle's Cost-Based SQL Optimizer CBO is an extremely sophisticated component of Oracle that governs the execution for every Oracle query. The CBO has evolved into one of the world's most sophisticated software components, and it has the challenging job of evaluating any SQL statement and generating the "Best" execution plan...
- Tags: Oracle Corp., Cost Control, CBO, Tools & Techniques, Financial Services, Programming Languages, Management, Software Development, Software/Web Development
- White papers
- MSDN Webcast: A Primer to Proper SQL Server Development (Part 7 of 10): Understanding Plan Caching and Optimizing Procedure Performance (Level 200)
- This webcast on Microsoft SQL Server development focuses on ways you can optimize your stored procedures and how to make the most of the resources you have available. What happens when you execute a statement? If a plan is used, how long does it stay in cache? Can you control...
- Tags: Cache, Microsoft Developer Network, Webcast, Performance, Microsoft SQL Server, Microsoft Corp., Digital Media, Consumer Electronics, Personal Technology
- Webcasts
- Consolidate all project management deliverables in the project plan
- A couple of extra deliverables?I'd recommend adding a couple of extra deliverables into that Project Plan:1. Scope Statement. Put simply, if you can't measure it, you can't manage it. So, it's always best to state for the record what's going to be done; and what's not going to be in...
- Tags: deliverable, lee_s_young@..., Quality Plan
- Discussion threads 2007-01-16
- Linking Strategy to Execution With Plan-to-Perform Blueprints
- Effective implementation of best practices in planning, budgeting and forecasting can be a daunting process. Simple, integrated, accurate, and dynamic plans that link strategy to execution shouldn't seem a lot to ask -- yet most organizations remain mired in overly complex and time-consuming planning processes that are of little ultimate...
- Tags: Penton Media Inc., Best Practice, Strategy, Management
- Webcasts
- SQL Assistant for Oracle (zip)
- SQL Assistant for Oracle is a GUI-based utility for Oracle management. Features include Object Management, SQL code completion, Session manager, Extract Wizard, Logminer Wizard, Query History, Preview dependent objects, fast search FK-dependent tables, SQL code insight, asyncronic (parallel-query) execution, and execution plan parser.
- Tags: Oracle Corp., SQL, SQLap, Programming Languages, Software Development, Databases, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2007-04-20
- Efficient Runahead Execution: Power-Efficient Memory Latency Tolerance
- Runahead execution improves memory latency tolerance without significantly increasing processor complexity. Unfortunately, a runahead execution processor executes significantly more instructions than a conventional processor, sometimes without providing any performance benefit, which makes it inefficient. This paper identifies the causes of inefficiency in runahead execution and proposes simple -yet effective-techniques to...
- Tags: Execution, Runahead Execution, Processors, Semiconductors, Hardware, Components
- White papers
- IT Business Continuity Plan
- What should an IT Business Continuity Plan include? Appreciate any inputs.This is a big questionFrom a high level, and by no means complete, some points...Your continuity plan should be hand in glove with your disaster plan. They are two different things, but had better work together. With that...
- Tags: Gina Laviste, criticality, IT Business Continuity Plan, information technology
- Discussion threads 2007-11-12
- A New CIO's 100-Day Plan
- When new CIOs start, they have to immediately create momentum and build credibility. High expectations are held by the business community, senior executives, and the IT organization itself — and starting off on the right foot is critical to managing those initial expectations. To manage this initial roller coaster ride,...
- Tags: CIO, Federal Government, Strategy, Government, Management
- Research reports 2007-04-23
- Oracle Advance Planning: Forecast to Plan
- This webcast gives an overview of Oracle's Advanced Planning product family and its key benefits such as how it enables demand-driven planning, collaboration, visibility and drives execution.
- Tags: Oracle Corp., Groupware, Benefits, Digital Media, Enterprise Software, Software, Human Resources, Consumer Electronics, Personal Technology
- Webcasts
- << Previous
- page 1 of 1
- Next >>
