Lee Markup explains why you want to pay attention during SQL Server installations:
There’s one sure-fire way to set yourself and your applications up for failure when using SQL Server. I’ve seen all kinds of people do this.
It will cost you performance and create maintenance headaches down the road.
Let me explain what it is and why it causes trouble.
Click through for some of the specific problems you might run into.