Parameter list query - peformance 32bit vs 64bit

Question

Post reply

Parameter list query - peformance 32bit vs 64bit

Viewing 2 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

markl-793889 SSC Rookie Points: 47 More actions · Answer 1

Yes it does,

CREATE TABLE [dbo].[Tally](

[N] [int] IDENTITY(1,1) NOT NULL,

CONSTRAINT [PK_Tally_N] PRIMARY KEY CLUSTERED

(

[N] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]

) ON [PRIMARY]

Jeff Moden SSC Guru Points: 1004642 More actions · Answer 2

Wow... I guess 64 bit isn't ready for primetime...

Of course, I still say that about 2k5 when the optimizer makes the wrong choice... 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)