Good question, learned something new. Thanks!

Great article! Thanks.

Good back to basics question - do not use 'select *' in a view defination! Thanks.

Good question! Thanks.

Thanks Gail! Well, alternate storage is probably not an option for us because of budget reasons.

90% of objects in this DB can be dropped and recreated and repopulated within...

Thanks Gail!

We will check and see what we find!

Great article! We had 2 instances of data corruption in last 3 weeks and so here I am...

The first instance was - "Unable to find index entry in index ID...

Thanks for the list Sebastien.

I have 4 temp db files each with an initial size of 10 GB because we have 4 quad-core CPUs. I did the shrink for...

Thanks David, this is good information. We have a system where a lot of temp tables are created and dropped continously by the adhoc reports. If the first page gets...

Thanks David Levy! After trying everything else mentioned in this article and not being successful at shrinking tempdev which is set to initial size of 10 GB but had...

Great article! Thanks. Looking forward to Part 3 and 4.

Great question! Thanks.

good question. Thanks!

Great question! Thanks.

Good question. Thank you!