When ever you change any Sproc or any object, it is done in a Branch. The Sproc will be promoted to the mainline only when they are released. Till then...

Well, We version every object that goes into production DB (That is the script to screate the object). But we do not keep version fo the physical table itself.

Could it it be Page swapping that it is using that much space?

There is an option in SSMS to specify if you want to Include a DROP statement as well when scripting any object in the Database. What both of them who...

Did you by any chance if you are not able to connect to the Domain Controller server to Authenticate the user? Thats the only thing I can think of.

Hi GilaMonster,

I set it up the same in SSMS and tried running the Same Stored proc and it ran fine. First run was 2900 Page reads and the next time...

ANSI_PADDING False in SSMS and the DSN Audit Login shows ANSI_PADDING ON

Same with ANSI_NULLS, ANSI Warnings

Could be parameter sniffing. I am not sure how I can fix parameter sniffing.

I ran both the contents and the Stored proc from SSMS. Both has the same number of...

Hi Gail Shaw,

That explains it. Thanks for the update. I have updated our DBA Review guidelines for the developers to make sure that they add a clustered Index on a...

The clustered didnt hurt at all. 🙂 It actually helped... And this was a mystery to me.

Thanks Everyone..:-)

Thanks Gail Shaw. You helped me out here. Really appreciate it.

Roy

Ah Darn... Thanks a Lot GilaMonster. That did the trick. So these are Ghost records. That thought did not go into my mind at all.

Now the question is why...

I did a Select * from sys.dm_db_index_physical_stats(DBID,ObjID,NULL,NULL,'LIMITED')

I got one row.

I cant copy it as it is since this system is not connected to the prodiuction network. But the values...

It is just a normal table. And there are no triggers on it. It is very strange.

Yes, Select count(*) returns 0 rows. That too does 6000 page reads when excuted.. :angry: . In this DB we have only one schema.

I am kind of lost here....