According to the developer who is responsible for the application, he said the application generated a lot of temp table when running reports. The developer said it generated a...

It takes two parties to compromise. I find out even I am willing to compromise, the other party refuses. It is people's pride getting in the way. ...

The size of tempdb is 328 MB.

The waitresource is 20:1:6751, 20:1:1050, 9:1:11506

When I query the sysprocesses, I saw a lot of PAGEIOLATCH_SH. What is that meant?

The autoshrink is not turned on in tempdb but the unrestricted file growth is turned on. I am looking at the sysprocesses right now and hopefully I will get...

The datafile of tempdb is in e drive and has 328 MB with 10% auto growth.

The transaction log is also in e drive and has 40 MB with 10% auth...

The problem is the system hang when people start running tons of reports using up the tempdb. I am not responsible for the system. The 'DBA' that normally...

I love it!!! It is great!!!!!

What is the requirement of this position? Was it specified the position required certain number of years of DBA experiences? It seemed to me you just hired a...

I am just afraid if I stay at this company, there is not going to be much development work. My technical skills will not go anywhere, so being a...

First I am angry that the government uses tax payer money to bail out the greedy companies to lend money to people who could not afford the house or car...

I think it is a nice move for those companies. I live at Update NY area, the living standard here is much lower than NY city, Philly and California,...

Project management is necessary especially for big projects. Of course a good project manager makes a big differences. A good project manager helps to co-ordinate people from different...

I was getting excited too early. It still did not work but did not give me an error. No clue.

Thanks Pam. I have to sign on as SA in both servers in order to do the copy database wizard.