One other method is declaring local variables, assigning them values from the parameters and then substituting the parameters with the local variables in the WHERE clause.  This speeds up the procedure...

Thank you for the information.  I think I will go for the multiple SELECT statements, one for each parameter rather than the recompile but the OPTION (RECOMPILE) will come in...

I agree with most of what is presented in this article.  You can go over the top with naming conventions but this is about right IMHO. 

The compound key constraint...

A very good article.  The part about trust and respect is very true. 

Not enough feedback about management is processed thoroughly both during and after an employee's tenure.  And even...

I have been using SQLPrompt for a while and still like it.  It doesn't always work but I've learnt to work around it.  The slowness is usually just when you...

Maybe it's just me but I find the combination of the issues below make it unusable.  I have reverted back to SQL2k QA after several thwarted attempts to use Man...

I've really enjoyed reading all of these posts and think that the article's title deserves 10/10 for marketing alone!  The amount of information contained in the forum is fantastic.  IMO...

I think if you use RAISERROR WITH LOG in your production stored procedures, users executing the procedure that aren't members of the sysadmin role will cause the procedure to fail...

You are getting prompted for sa because of the settings of the property CurrentProject.Connection.ConnectionString.  This can be changed to use NT authentication using File - Connection.  This always gets read...

Thanks for both of your comments.  I've realised that the varchar option has a big impact on the row size in that if a column does actually contain a record with...

Think you may need to post some more information on exactly what you need but..

DECLARE @StartDate smalldatetime

DECLARE @EndDate smalldatetime

SET @StartDate = '2005-07-01'

SET @EndDate = '2005-07-04'

Date smalldatetime

IF NOT EXISTS (SELECT *...

Nik,

Your example doesn't include a default value and should read:

ALTER TABLE [T1]

ADD [Fish] INT DEFAULT(0)

The statement you wrote below is exactly the opposite of what actually happens.  If you don't...

I agree with Sergiy on the indexes on datetime data types.  These are just represented by integers anyway, aren't they?  Is there a...