A few comments on that.

While you can alter table alter column to add an identity, you can't use alter table alter column to remove the identity propery. What Enterprise manager...

Few questions and a couple comments. I'm going to focus on indexes and tuning.

CREATE UNIQUE CLUSTERED INDEX [PK_Response_1000] ON [dbo].[Response_1000]([RpsRespondent], [RpsQuestion], [RpsMatrix], [RpsMention], [RpsType]) WITH FILLFACTOR = 90 ON [PRIMARY]

GO

CREATE...

You certainly don't need a cluster of machines to handle a 3 million row table. I've got tables 100 times that size. and a few 10 times that size all...

The main difference is that access is a file-based database. There's no server-sde components, everything runs at the client.

SQL Server is a full database server. Even if there are...

It's easiest for us to help if you post your table structure as a create table statement, if you give us some sample data to work with and if you...

That makes no sense. All NoCount does is remove the line X Rows affected which SQL by default returns for all queries.

Where were you running the stored procedure from? Query...

If it's a reporting database then index it heavily. It's not uncommon for a reporting database to have more indexes per table than it has columns.

However, don't create indexes for...

Agree with above. I would also run performance monitor and check for memory usage, page swapping, hard disk usage, processor usage.

Is the server dedicated to SQL Server? If not, what...

Because of the group by. What you're asking for in the first statement is the maximum customerName for every unique customerNum. Hence, you'll get one row for every customerNum

The third should return...

Most likely you've got some non numeric values in the field. See what this returns

SELECT Jan_Hours FROM employeepayments WHERE ISNUMERIC(Jan_Hours) = 0

It's not perfect, isnumeric sometimes returns true for...

There's something wierd going on there. Please post the trigger code and the vb code that you call the inserts from.

Triggers fire within the connection and the transaction that did the initial insert/update/delete. If 4 users all update different records of a table and there's an update trigger on the...

I recomend clusters on unchanging, increasing, narrow, unique columns (priority in that order), especially if you have a lot of queries that sort by that field, do ranged searches or...

1433 and 1434 are the tcp/ip ports used by SQL if it's using TCP sockets to communicate. 445 is for named pipes.

I think the reason that 445 isn't mentioned is...

I just want to give a great big 'shout-out' to Gila for the information about avoiding the use of functions in where clauses.

My pleasure.