Your Tally table isn't. Please read the 4th article I reference in my signature block below regarding Tally Tables. Trust me, it will be enlightening, it was for...

And a newbie sees the light :w00t:

Hens have teeth. 😛

Okay, you are adding 4GB, so how much total??

Sample data? INSERT INTO statements.

I think that is what you are going to have to in order to determine which sprocs are being used.

Lynn Pettis (1/8/2010)

It depends,

PLEASE ANSWER THE FOLLOWING:

What is the configuration of the development server (total server memory, disk drives (raid type or not,...

It depends,

PLEASE ANSWER THE FOLLOWING:

What is the configuration of the development server (total server memory, disk drives (raid type or not, etc)? How...

Tested, and looks like the same as above.

create table dbo.TestTable (

A char(2),

B int,

C int,

V...

It would help if you provided the table defination(s) as CREATE TABLE statement(s) and the sample data as a series of INSERT INTO statements.

Agree I must with this comment. Much learning have...

As Gail said, the OP is converting code using the *= style joins to ANSI-92 joins.

You can change the compatibility level of the database in SQL Server 2005 all you want. What you can't do is take a backup of the database and restore...

Scared him off, I think we did.

GSquared (1/8/2010)

Lynn Pettis (1/8/2010)

Thankfully, NO! I (actually the family) did get a few good (IMHO) movies: Star Trek, GI...