Hi,
I have few tables in my database.Even though i dropped and recreated the indexes on these tables the scan density is not changing(less than 50%).I also got a stack dump when a report involving huge select statement is ran against the database.Before stack dump I noticed an error tempdb cannot allocate new page.I checked the size of tempdb it has space.It is set to auto grow and disk has more than 2.5 gig of free space.
I appreciate if anyone can help me to figure out what is happening on this database.
thanks
Mohan