Check the FillFactor on the index. It is also possible to have a badly fragmented index bloating it's size.

If it is an either/or situation, you can do the logic before calling the select statement:

IF @Col = 'FirstName'

BEGIN

SELECT * FROM MyTable WHERE FirstName LIKE @val + '%'

END...

I would say your bigger problem is that starting the LIKE condition with a wildcard means the database engine cannot use an index. So, if you have a single...

The MS Active/Active cluster solution is a bit misleading. Clustering is for HA only, it is not a load balancing solution.

In an Active/Active cluster, you need two instances of...

What is it you are really trying to do?

You can add the sharepoint databases to your existing instance and leave the cluster exactly as it is. What is wrong...

Here is an option - you could just join back to the table three times:

[font="Courier New"]declare @TestTable table

(

startdate datetime,

...

My suggestion is to stop the services on the original servers, copy the databases (including the system databases) to the new servers, and start the services on the new servers....

If it is only two tables, table locks are probably the way to go.

That can get a bit tricky with SSIS if you have multiple steps in your control flow...

Single-user mode will limit you to a single connection to the database. You can do this, but you would have to set your connection manager to RetainSameConnection and make...

The servers are physically different, but can you convince them to retain the original server names and IP addresses?

If so, keep everything simple. Stop the services on the servers...

To add to this, it is a bit risky to develop on one version of a database and have your production systems running on another. They behave differently -...

No.

You cannot in any way restore a SQL 2005 database backup on a SQL 2000 server. Compatibility mode will not help you.

Your only option would be to copy the...

You have not given me any clue what "it" is, but I will still try one last post.

Add a derived column component to the data flow.

in the component, add two...

It will look something like this:

[font="Courier New"]CREATE PROC MyProc

@InputVal VARCHAR(20)

, @OutputData VARCHAR(20) OUTPUT

AS

/* do something */

SET @OutputData = 'MyOutputVal'

RETURN(0) --Good practice to return 0 on success[/font]

Look in...

You want to either use a derived column component or a conditional split. If you post more details, I could be more specific on what you need to do.