About Jeremiah

I'm a senior database administrator with Cass Information Systems, a SQL Server MVP, director-at-large with PASS, and I also help out with my local chapter and the Application Development virtual chapter.

You can learn more about me or contact me directly.


Google Reader
Google Profile
delicious

A Simple Refactoring - Functions in the WHERE Clause

Putting functions in the where clause of a SQL Statement can cause performance problems. If you aren’t careful, these problems can add up and bring a powerful production system to its knees.
For this example, I’m using the Northwind database, but you could do this on any database.
The first thing to do is put an index [...]

February 17th, 2010 | Tags: , , , | Category: SQL, SQL Server, syndication | 5 comments

A Simple Refactoring

Refactoring SQL code can be pretty easy. Just like refactoring any other programming language, sometimes you have to look around to find the culprit.
We have a slow running query that frequently times out when run by the users. A quick look at the query told me what was wrong. I found this clause in the [...]

February 11th, 2010 | Tags: , , , , | Category: SQL, SQL Server, syndication | One comment

When is a Lookup not a Lookup?

Execution plans are great things. They give us an insight into how SQL Server is putting together queries and why they run slowly.
One immediate thing I look for in an execution plan is a Key Lookup. In a Key Lookup operation, SQL Server has to reference the clustered index on the table because a value [...]

February 2nd, 2010 | Tags: , , , | Category: SQL, SQL Server, syndication | Leave a comment

O/R-Ms: Panacea or Polio Braces?

In case you haven’t heard, there is a huge difference between the way that software developers and database professionals operate – there are accepted use paradigms and development methodologies for both worlds. Unfortunately for everyone, they don’t match up. Object-oriented programming languages operate on single entities: objects. Databases work with sets. Objects sometimes have relationships [...]

January 5th, 2010 | Tags: , , , , | Category: Code, syndication | 18 comments

SQL Server Performance Tuning Webcast

Looking for a quick overview of SQL Server performance tuning? Well, look no further! Way back at devLink, David Giard was kind enough to interview me about my thoughts on troubleshooting SQL Server performance. Check it out.
A little history on this, David talked to me many months ago at the Stir Trek convention, but the [...]

September 22nd, 2009 | Tags: , , , | Category: SQL, SQL Server, syndication | Leave a comment
 
  Older Entries »