Gregory Larsen

This is the first article of a series where I’ll be exploring Indexing Guidelines. Having appropriate indexes on your database is critical in making sure your application is retrieving records quickly. However, having too many indexes can also slow down your application. In this series of articles, I hope to help you understand how to […]

Bill Graziano, VP of marketing for PASS, was first on the stage at today’s keynote. He said that he would provide the shortest keynote address of the week and I think he met that promise. Bill recognized the current board members, and introduced the new board members. He then invited Wayne Snyder on stage to […]

At this morning’s keynote session, Rushabh Mehta (executive vice president) was the first on the speaker platform. He talking about what makes PASS run. A big part of it is the people like the attendees at annual PASS summit, and of course all the volunteers that make this organization tick. But PASS could not operate […]

Today the keynote address started out with Wayne Snyder welcoming all the PASS attendees. He mentioned that 43% of the attendees where first time PASS attendees, then Wayne said “Where have you been all these years?”. The PASS summit is truly an international event. This year participants come from 45 different countries. After Wayne completed […]

I arrived at the Washington State Convention and Trade Center around 8:45 AM this morning to register for the 2009 PASS Summit. Most of the morning attendees were already in their pre-conference sessions that started at 8:30 AM, but there were still a few people milling around and stopping by the registration desk. Click for […]

Making sure your queries run as fast as possible is important to ensure your application gets the kind of performance that users require or expect. Query performance can be affected by lots of different factors. In this article I will be introducing another best practice of how and how not to use a function within […]

This article is an extension of my T-SQL best practices series. In this article, I’ll be exploring how SQL Server optimizes and caches stored procedure execution plans based on the parameters that are passed the first time a stored procedure (SP) is executed. This discussion will explore a concept called “Parameter Sniffing” and how this […]

In my prior T-SQL best practices articles I’ve talked about different coding styles that led to slow and fast query executions, and ways to minimize cached plans. This article will be an extension on those concepts discuss in previous articles. I this article I will talk about parameterized queries. I will discuss how the SQL […]

This article is the third article in my T-SQL Best Practices series. First two articles can be found here: Part 1 and Part 2. In this article, I’ll be talking about how to write your code to promote cached plan re-usage. Understanding how white space and comments impact whether a plan is cached or an […]

In my article last month, I started a new series to discuss T-SQL best practices. This is the second article in that series. This series of best practices will help you write T-SQL code that performs better, and promote coding practices to help minimize the number of application failures. This month I’m going to focus […]

Application performance is driven by a number of different factors. One of those items that typically affect performance is how long it takes SQL Server to process your T-SQL statements. Sometimes the database design and the complicated query requirements hinder the speed at which your T-SQL statements can run. Other times the way the T-SQL […]

More and more shops are implementing web services. Doing this provides an architecture that allows applications to consume services to retrieve data. These services could be within your own organization or from a business partner. One of the problems you might run into when building applications that consume web services is how you can use […]