Kalen Delaney
|
|
Kalen Delaney has been working with SQL Server for 20 years and provides SQL Server training and consulting to clients around the world. Her most recent book is Inside Microsoft SQL Server 2005: Query Tuning and Optimization (Microsoft Press).
Email address: kalen@insidesqlserver.com
Web site: http://www.insidesqlserver.com
|
182 results found for Kalen Delaney, displaying items 1 - 20
|
 |
Are You a Developer or an IT Pro?
This year, Microsoft has decided to split TechEd into a developer week and an IT pro week. Kalen looks at how DBAs are deciding which week to attend.
SQL Server Magazine
The Search for the True Definition of DML
Kalen discusses the steps she took to find out what DML is really supposed to stand for.
SQL Server Magazine
Microsoft Research Labs Fuel Innovation
Kalen takes a look at Microsoft Research's history and discusses Microsoft Research's newest facility, the Microsoft Jim Gray Systems Lab.
SQL Server Magazine
Ask for a Service Pack and You Shall Receive
Kalen discusses the announcement of SQL Server 2005 SP3 and the release of Cumulative Update 7.
SQL Server Magazine
Familiar SQL Server Tools in a New Wrapper
Kalen discusses SQL Server 2008's Data Collection suite, which contains the Data Collector, performance and diagnostic monitoring, and Management Data Warehouse.
SQL Server Magazine
SQL Server 2008 Launch Sequence Initiated
This week, Kalen discusses preparing for her presentation at the SQL Server 2008 launch event in Seattle.
SQL Server Magazine
Further Explorations in Plan-Cache Metadata
Uncover more valuable metadata that can aid you in troubleshooting and performance-tuning your queries.
SQL Server Magazine
SQL Server 2005 Metadata I Couldn’t Live Without
Kalen discusses what she plans to cover in her upcoming SQL Server Magazine UPDATE commentaries, and which SQL Server 2005 Dynamic Management Objects she couldn't live without.
SQL Server Magazine
Column Statistics Give the Optimizer an Edge
Column statistics—statistics on unindexed table columns—complement index statistics and give the optimizer additional information to use in determining the most efficient query plans.
SQL Server Magazine
Examining XML Plans in Cache
A large plan cache can seriously impact performance. By using plan-cache metadata in SQL Server 2005, you can analyze any user query without actually running the query and avoid expensive queries by comparing many plans at once.
SQL Server Magazine
A Brief History of Plan Caching in SQL Server
Changes in plan caching over successive versions of SQL Server affect its memory usage.
SQL Server Magazine
Managing Plan-Cache Size
SQL Server 2005 doesn’t limit plan-cache size but still provides ways to control it. Learn how to keep an eye on cache size and tricks to trim down a bloated cache to improve performance.
SQL Server Magazine
Making the Most of Automatic Statistics Updating
Tune performance by using UPDATE STATISTICS and trace flags to improve the quality of index statistics by ensuring they’re regularly updated.
SQL Server Magazine
Combining SQL and TEMPLATE Plan Guides
By using both TEMPLATE plan guides, which enable autoparameterization, and SQL plan guides, which let you specify many query-processing hints, you can optimize query performance.
SQL Server Magazine
Controlling Parameterization
Two query hints in SQL Server will autoparameterize queries so that query plans can be reused, but you need to keep a close eye on query performance to get the most benefit from these hints.
SQL Server Magazine
|
July 19, 2007 |
|
Query Elements That Preclude Autoparameterization
By default, SQL Server 2005 will not autoparameterize queries containing the constructs in this list.
SQL Server Magazine
Help for Query Hints
SQL Server 2005 plan guides let you instruct the optimizer about when to use a particular hint, to boost a query's performance—but you should use them sparingly.
SQL Server Magazine
Help with Examining Parallel-Query Plans
Here's how to simulate multiple processors by changing a setting in SQL Server Configuration Manager, so that you can examine plans for parallel queries.
SQL Server Magazine
The XML Query-Plan Treasure Trove
Viewing SQL Server 2005 query plans in XML format gives you more-detailed insights into query performance, and Microsoft's free XML Notepad 2007 tool makes such plans easier to read.
SQL Server Magazine
A Look Back at SQL Server Magazine’s Beginnings
Kalen Delaney, whose Inside SQL Server column has been an integral part of SQL Server Magazine since the first issue, reminisces about the magazine’s origins.
SQL Server Magazine
|
|
Register
