See the insert into... delete from... suggestions on page 1 of this thread. They should work ust fine and won't require a complete replacement of the table.You can put those...

Makes absolutely no difference on an inner join. On a left or right join, filters the joined table before it's joined in. Doing this can be difficult to understand, at...

Not always. See below

CREATE

TABLE #Temp(

ID int NOT NULL,

Yeah, that's better than mine. Why didn't I think of that...

However

BEGIN TRANSACTION

SET IDENTITY_INSERT Services ON...

Nope, he's asking (from my reading) how to add a filter to pull only last month's records.

You can only do that if one, or both tables contains a field that...

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...