Please could you run this and post the result:

SELECT @@VERSION

This is a script for 2008 and you are running it in 2005. Everywhere that the date datatype is used needs changing to datetime or smalldatetime. Or see if there...

Best practice is be to remove the system functions on the data source columns if at all possible, which in this case it is.

Similarly, using a language independent date...

Ha! Makes sense (although it would be nice if the validation checked the order of the symbols!). Thanks 🙂

Hello

In order to make use of an index.... AND date_time >= '20090901' AND date_time < '20091001'So those are your start and end times hard coded. Exactly how we parameterise these...

SELECT DATABASEPROPERTYEX('myDB', 'IsAutoUpdateStatistics')

peterzeke (10/20/2010)

---

I'll have to check with our new dba regarding the autoupdate statistics setting. (Is there a query that can be run to determine if autoupdate stats...

As mentioned, statistics are another avenue to investigate. Are autoupdate statistics on? And if not, do you have a regular maintenance routine to selectively update them?

The parameter sniffing is at the sproc level.

I would google parameter sniffing in SQL. Your options depend on your circumstances and SQL Server version.

What I would definitely do first however...

I first saw that technique described by Adam Machanic http://sqlblog.com/blogs/adam_machanic/archive/2006/08/04/scalar-functions-inlining-and-performance-an-entertaining-title-for-a-boring-post.aspx

Although perhaps superficially similar, Itzik is really solving a slightly different problem - getting a scalar inline whereas you...

Yup, 8k for everything.

Have as many as you like it makes no difference - they are a mirage.

http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%282630%29-nested-transactions-are-real.aspx

e.g.:

ALTER FUNCTION [dbo].[udf_RPT_NETWORK_PREVQTR_COND_RATE] ( @user-id INT )

RETURNS TABLE

AS

RETURN

(

SELECT

...

You could write that as an inline UDF - an inline UDF is a single SQL statement. Think of it like a view but that accepts parameters.

Do you see how...

peterzeke (10/20/2010)

---

Regarding parameter sniffing, how much of a performance impact does it have? Has anyone seen a query/report improve from hours to minutes or from a minute to a few...

You really need to specify if these are inline or multi statement. The SQL of Inline UDFs is decomposed into the entire execution plan. Multi statement table UDFs are like...