SQL Server with Mr. Denny:

Query tuning


March 27, 2008  8:21 PM

Joins vs. Exists vs. IN: Not all filters are created the same.



Posted by: Denny Cherry
Query tuning, SQL

Not all filter commands are created equal.  Different filtering operations should be used at different times to get the best performance our of your SQL Server. While the JOIN, EXISTS and IN filters can give you the same results the way that SQL Server gets to the data is very different and can...

March 21, 2008  6:11 AM

I had a great time speaking at the San Diego SQL User Group



Posted by: Denny Cherry
In Person Events, Query tuning, Service Broker

I'd like to thank the San Diego SQL Server User Group for having me come and speak to them tonight.  I had a great time presenting both my


March 18, 2008  10:24 AM

Slide Decks and Sample Code for San Diego SQL Users Group Meeting



Posted by: Denny Cherry
In Person Events, Query tuning, Service Broker

Below you will find links to download file files with the MS PowerPoint slide decks and sample files which I'll be using at this weeks presentation at the San Diego SQL Users Group Meeting. There is a lot of sample code in the Query Tuning file.  We'll look through as much of it as we can...


March 6, 2008  3:12 AM

I’ll be speaking at the San Diego SQL Server Users Group



Posted by: Denny Cherry
In Person Events, Query tuning, Resource Governor, SQL

The good folks of the San Diego SQL Server User Group has invited me to come speak to them on March 20, 2008.  The meeting starts at 6PM.  If you are in the area I urge you to come and check it out.  The topic of my talk will be Query Tuning as well as a bit of Query Governor.  If you...


January 28, 2008  11:56 PM

Slide Decks and Sample Code from SoCal Code Camp



Posted by: Denny Cherry
Beta, Cache, CLR, Config, In Person Events, Query tuning, Resource Governor, SQL, SQL Server 2005, SQL Server 2008, SSMS

The SoCal Code Camp was this last weekend.  I had a great time attending and speaking at the code camp this time around.   I hope that everyone who attended my sessions had as much fun attending the sessions as I did speaking at them.  I did my best to make them as much fun and interactive as I...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: