I know its transactional:cool:.I am asking something else i.e. about fetching static data.Static data means no DMLs..I guess. Vyas can you elaborate your point?

Vivek

You have mentioned about fetching static data from the transactional table.Please clarify what does it mean?If data is static, there will be no DMLs then. For reporting purpose, I guess...

I just cross posted it in SQL Server 2008 forum beacause I thought people might not be navigating enough in SQL Server 2005 forum.Thats it.:cool:

No reply yet..:crying:

Thanks.Appreciated.

Any suggestion will be appreciated.

If your database allow for switching recovery models for rebuilding idexes, then its acceptable.

I was saying what if you can't switch from Full to any other model due to any...

Try running DBCC FREESYSTEMCACHE('ALL') in tempdb and then shrink the file.Check if it works.

Options 1 & 2 are sometimes not possible to do on Production environment.If option 3 is true,then its fine.

After rebuilding indexes, log file size increases due to fragmented space released.Its not possible to keep bigger log file size if you rebuild indexes frequently.Thats why I am looking for...

Thanks.It helped.

Thanks for the reply.I know very well that identity is a property not a datatype.I asked this because I had in my mind what would happen if the column on...

After 2 billion insertions or max of the datatype limit the identity column has reached what will happen and how to tackle that?

Its in SQL Server 2008. How to do it in 2000 and 2005?

I am looking from the DBA perspective.