[font="Courier New"]Select Action from ActionList where ActionID = @ActionID

OR NOT EXISTS (SELECT TOP 1 X.Action FROM ActionList X WHERE X.ActionID = @ActionID)[/font]

That's not going to be very efficient though, because...

Um...that's a lot of strings.

I don't have anything pre-made, but something like this is what comes to mind:

[font="Courier New"]; WITH CharSet (N, Chr)

AS (

SELECT N, CHAR(N) FROM dbo.Tally WHERE N...

The primary key does not have to be the clustered index, it is not unusual to have a clustered index that is not the PK. Don't create duplicate indexes....

It will depend on some of the deatils of the requirements.

It has been my experience that complete real-time is often not really what is needed (or even wanted). Do...

MAX DOP refers to a single executing process. If you have two different connections to your database, they will still get their own threads. So, splitting TempDB or...

SQL Server 2005 Standard and Enterprise Editions do not prevent access due to licensing. A server with a 5 CAL license will not prevent a 6th user - it...

There are lots of things that can cause this. Parameter sniffing, poor cached execution plans, etc.

If you cannot post the procedure, DDL, and execution plans, it will be nearly...

5 CALS means 5 clients. You can have 5 people using the same login and it is fine.

Figure out what the realistic number is. If this is an...

You can use CALS for any type of application. MS does not restrict on the technology used. You mus license every client that will be accessing the web...

Oh - yes, there I go not paying attention.

Yes, 32,767 databases per instance.

If you run into that being a problem, you probably have a design issue.

You do not need to store the packages in the MSDB database, you can store them on the file system as dtsx files and they will execute just fine.

However, you...

http://msdn.microsoft.com/en-us/library/ms143432.aspx

16 instances for workgroup edition.

50 instances for all others.

25 instances if using a failover cluster.

If the databases do not conflict, moving them to a single instance will reduce the overhead...

When did everyone become so efficient that they started using acronyms or abbreviations for everything?

Oh, sorry...

WDEBSITTSUAOAFE?

It would also give you a really easy ability to create language-specific views or even user-specific language views.

If you have a table with a user name and a primary language...

Sorry, I forgot about the literal issue. I try to avoide using the XML data types.

[font="Courier New"]DECLARE @VARCULTURE NVARCHAR(5)

SET @VARCULTURE = 'es-ES'

DECLARE...