Lynn Pettis (3/10/2010)

---

Paul White (3/10/2010)

---

C'mon guys, think outside of the box! Ok, so...

My preference has always been to use dbcc shrinkfile in SQL 2005. This allows one to shrink below the initial database size. This could also be a time...

curse the double post...

Nice question. Keep 'em coming.

Working late comes with the territory.

As far as the editorial, I try to implement as many automated solutions as I can - limits the hours. I couldn't imagine the...

Another nice editorial Steve.

GTR is correct.

One addendum. Avoid using the SA account where possible. You will typically setup an SA account password during installation. Upon completion, I would create an...

Let's start with user account being used. Make sure it has adequate permissions for the install files folder.

Next, where is the media you are using for the installation? ...

GTR (3/9/2010)

---

gupta1282 (3/9/2010)

---

Hi All

Our TempDB mdf file size is 32617 MB and Unallocated Space showing 32607 MB

but size of mdf file is not reducing after shrinking.

Why This happening ? ...

Thanks for that article. That might prove useful in a current project.

Click the blogs link on the left. Once the page refreshes, you can click control panel on the right hand side of the screen (under the label (My Profile)....

I like how you think. There are plenty of great things on thinkgeek....

Thanks for the article. Unfortunately there are plenty of 2000 servers still in production (75% of mine are 2000). It was quite a refresher course when coming from...

Thanks Lowell and Thorv.

Long days and lots of hours. I think one essential thing to remember is to remember that you can't learn it all at once. Take notes, be organized...