First, thanks for the article.

I am in agreement with your comment about having more than 16 files.

A possible exception would be where databases can be in the many terabytes range on machines...

Many thanks!!!

GaryA

kknudson

Better??? Yes

Do you know if unallocated space formatted or not formatted?

GaryA

tosscrosby

Some scattered thoughts.

There are maybe two types of fragmentation that affect DBs. 

One type.

When SQL Server asks for additional disk space, to increase a DB file size, from the operating...

SQLBill,

Are you suggesting that DBCC SHRINKDATABASE could be given a targetpercent of zero, if someone wants to squeeze out as much space as possible?

GaryA

First I don't know the answer to the question you are asking.

It seems to me that there are limitations to the shrinking process, possibly because of how the page/extent process...

Good questions to which I also would like to know the answers.

I do have some speculations about the difference between unallocated and unused space.

Speculations are:

When a database is first created...

I am not sure I understand your concerns, but please allow me to make the following comments.

I believe the following are true.

First, within SQL Server, what is not specifically allowed...

Here is another reference, which I find a little easier to understand.

http://www.sql-server-performance.com/awe_memory.asp

However, between the two articles (one by Ken Henderson on the MS site & my above reference), a more...

While your question is simple, since I don't know what it is your really trying to find out, I suggest you refer to BOL topic CREATE TRIGGER.

GaryA

I confess I am not knowledgeable in this area and because of that I ask the following question.

Why is full text search used in place of simply using LIKE.  In...

I believe the answer is yes.

Above sets the transaction isolation level for the entire user session.

So it seems to me...

I wonder if the following is a possibility, for moving the system databases on the same server.  Main thing to notice is Database restore process is not involved.

a.  Shutdown SQL Server

b. ...

Antares, Kudos!

GaryA

Gary Johnson, sorry but I don't understand your comments.

I looked at the columns in the sysjobhistory table. I saw no column that appears to indicate how/who starts a job.  There...