Obviously, i won't be able to cahnge existing file allocation unit size. As when i check the existing file allocation unit size it shows following.

Version : ...

Please excuse me if i may sound ignorant here but when you say "if you block size allocation drives" - do we actually have an option there? If so then...

Thanks a lot everyone for your replies.

It seems like most of the replies are suggesting that the potential cause of degradation in performance seems to be poorly performing queries, missing...

I absolutely concur with what you are saying.

Along with running performance tuenning, I have also had a close look at this queries for possible index creation and continueing to do...

We are SQL 2000 32-bit.

Also, after my initial look at this 3rd party product database i have found that the database has been poorly designed. I don't think it...

Hi everyone,

I am also having similar problem when i try to restore database using command;

RESTORE LOG [test] FROM DISK = N'C:\restore\test.2.log' WITH FILE = 1, NORECOVERY, ...

if you are using sql 2005 onwards, you can even use SQL Server in-built reports to find out about space usage.

"I am having some difficulty with converting (moving) my Access 07 queries to SQL Server 2005. Is there a way you can link the queries similar to the way you...

Did you try checking all the system objects size to start with? This will allow you to findout if all the objects in the database are really utilising that space.

Vivek

humm... I do think transactional replication would be the best bet.

Hi there,

It seems like you have considered important points that you need to while upgrading from SQL Server 2000 to SQL Server 2008.

However, i'd still share what i have figure...

No worries. I have found the solution.