Thanks BrainsDonor, the list looks perfect to me. Every flags I was searching today are on the list!

BrainDonor (12/13/2012)

---

The best resource is actually here, on SSC: http://www.sqlservercentral.com/articles/trace+flags/70131/. Otherwise you end...

Thank Bhuvnesh! The status is 0.

And I checked it back after some hours and it's been backed to normal. just wondering now if the only way to resolve this is...

Thanks Anthony. It's very clear!

I read the article. However, I'm still confused. My question is on the collations created with either type of temporary tables. Will table variable always use the collation in user...

Thanks for reminding.

I actually will add one datafile first and add two more later. Since another concern about tempdb on our server is that we've failed to apply SP2 CU6...

Hi Suresh, thanks for the good information. I'll add files to datafile only. 🙂

I wish it will resolve our issue here.

sounds good. thanks Suresh!

I'll add more files. we have 16 core on the server, so I guess I 'll put 4 files for both data files & Tlog files.

we have suspended sessions with command "INSERT" and wait_type "PAGEIOLATCH_IO" and the "blocked by" is 0. And those stroed procedures use temp tables a lot and only insert commend in...

Thanks both.

We have heavy IO on tempdb right now and the size of tempdb grow rapidly. We needed to restart service last to solve locking issue.

Our programmers use...