Randy Dyess

Bookmark Lookups

Building high performance applications with SQL Server can be a challenge if you do not understand how the query processor works and how the server uses indexes. SQL Server expert Randy Dyess brings a look at how bookmark lookups are used when satisfying a query and how this can impact the performance of your query.

4.48 (31)

2008-07-18 (first published: )

37,253 reads

Obtaining Query Execution Plans Through SQL Profiler Traces

Did you know that you can obtain the execution plans for your SQL Server 2000 queries using Profiler? It is an interesting concept, especially when you need to troubleshoot the queries on a system that you did not develop and cannot obtain source code for. SQL Server guru andy Dyess brings us the technique you can use to find those queries and execution plans.

5 (1)

2005-04-18

16,108 reads

Optimizer Join Methods

Understanding the different types of joins used by the optimizer will help developers and DBAs understand how the optimizer is routing their queries. Developers often create queries without knowing that it would only take a few tweaks to produce an execution plan that utilizes one optimizer join method over another. These small tweaks can have dramatic effects on the optimization of the query and the ultimate satisfaction of the query by the end-users.

4 (1)

2005-02-09

21,098 reads

Blogs

Azure SQL Database – Azure Portal Updates

By

A small but useful change has been made to the Azure Portal for Data...

SQL Server Quick Tips

By

Earlier this year I made a series of videos that were played before the...

The 2019 State of DevOps Report–Webinar

By

Tomorrow I get to chat with another giant in the world of DevOps: Jez...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Tsql/SP Code Optimization

By sizal0234

Hi, I am working on optimizing some of Tsql code for SP's. I know...

Powershell

By sizal0234

Does PS help in performance. Like instead of TSQL code used in sql agent...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers