That is true. Specifying...

I decided to go back and test this on SQL 2008 after my last post.

I verified both Model database settings, and created a new database. I have not altered...

b0b555 (1/20/2010)

---

This statement doesn't make sense to me:

"The default size for an mdf is 2MB and 1MB for an ldf, based on the model database".

It can't default to 2mb/1mb AND...

I couldn't have said it better myself. This very notion is evident in SSC with some of the heavy hitters constantly giving of their time to help others.

FAMILLE

Jeff Moden (1/17/2010)

---

zafarthesultan (1/17/2010)

---

I will give you an example to make things clear. The project is a web application. A person registers with the website by purchasing a product for...

Compact Large Objects is an option in your maintenance plan. It is not required to be enabled. Thus, you should be safe in disabling it.

If you are getting grilled during the interview - it might be a good thing too.

If I feel that an interviewee is faking it, I will end the interview more...

Have you tried disabling Named Pipes?

SQLPirate is correct on the space info. Run the query he suggested. You will likely see the discrepancy there.

Some good things I like to do include User Group participation like the local PASS chapter, SSC participation, exercise and flat out getting away from work.

There is also the big...

I agree with Jeff. Since the growth start is somewhat random - there is a query that is firing off, that needs tuned, at the root of the problem.

You...

suresh.theyyath (1/20/2010)

---

Dear all,

First of all the question was intended to subject Sql 2005 and as there is a mistake the required answer was not supplied to the valueble...

dan-572483 (1/20/2010)

---

The SQLServer instance is configured with 1433 on IPall. In Windows Firewall I have a Exception for TCP Port 1433 and an exception for sqlservr.exe. ...

Thanks for taking the time to write this article.