Thanks guys. I'll be leaving the query as is for now. So far, the 'with recompile' change has done what we want and server impact has not been...

Yes but I'm not sure what to put as a default. The data is going to change over time and the spread between the different lines will not be...

Well, I added 'with recompile' at the beginning of the stored procedure, and the problem is gone!

It is now using a much more efficient query plan when it is provided...

It is much faster when I hardcode the value...what is parameter sniffing? and how can I get around it?

Jean

Thanks everyone for your replies.

I did update statistics this morning, so that should not be an issue. That was my initial reaction, but I was disappointed when the query...

Hi Remi,

Replacing LEFT JOIN with INNER JOIN doesn't help either.

Jean

Thanks Vasc for your quick reply. There is currently only one matching row in Production_Unit, two in Release, and 7 in Production_Detail. The end result is one row.

There...

In the case of independent servers, as long as the username/password combination used by SQL Server matches a username/password combination on the other machine, and that second login has the appropriate...

Is the MSSQLServer service running under a domain account that has access to this share?

SQL Server will access the filesystem and network shares in the security context of this user. ...

...followed by a group by:

group by [Product Code], [Part#],

Convert( Varchar(7), [Replacement Date], 120 )

JM

You can always try running a standard profiler trace overnight and saving the results to a table.  You can then report on that table the number of times each...

You can check this link:

http://support.microsoft.com/default.aspx?scid=fh;%5Bln%5D;LifeSrvr

Mainstream support will stop on Dec 31st 2005.

JM

Did you install SQL Server as the default instance or as a named instance?

If it is a named instance, it is probably not listening on the default (1433) port and...

Can you retrieve the event logs even if the workstation is not registered on the domain?

Also, how do you monitor remote jobs statuses? By querying the sysjobhistory table?

JM

Check this thread:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=18137&FORUM_ID=5&CAT_ID=1&Topic_Title=Managing+Memory&Forum_Title=Administration

JM