its done ........

Give me your email address and i will send you the tempdb PPTX for the triage that I took @ microsoft ..

🙂 size of the transaction log depends on the number of transactions logged every hour in your case .....

I dont think that there is any need to worry ...

Regards

Abhay

your answer is here : http://support.microsoft.com/lifecycle/?p1=2855

if its SQL 2005 and above you can use snapshot isolation level to avoid locking as committing so many times inside the loop will have the performance hit .

The best...

if you have kept the third file group as readonly then there is no need to take the log backup of that filegroup except once assuming there might be something...

you cant run repair_allow_data_loss as its not suggesting you to do that .

if its not suggesting then its not going to help you .

There is only one object which is...

This is an assertion which is throwing the dump.

An assertion is thrwn when a certain condition in the code is not met and is false .

the result is a dump...

then there is no need to use the query analyzer .

you can use SQLCMD using DOS prompt ...

use this : http://technet.microsoft.com/hi-in/library/cc966413(en-us).aspx

Background : background threads like logwriter .You cant find what its doing

Runnable : are the ones waiting for their turn to run on CPU .So , actually waiting because...

Create the same user in your database in advance that you application creates in the begening ...

In short make sure that the database you are going to replace has all...

in order for the OS to see more than 4 GB or RAM you need to give it eyes . this is PAE .Once you add /PAE virtual memory pointers...

Yes you are correct .SQL Server is non-preemptive as opposite to OS which is preemptive .

this is a short answer .let me know if you want to know how SQL...

If you are using QA then : on the key board press ALT+Q and then m .

in the Query menu there is SQLCMD mode option

HTH