thanks for the quick response.  the server did start successfully and is running ok.  without the setting, it just gave a warning message.

Basically, you are leaving space for the data to grow.  Check BOL, but in short, when a page runs out of room it splits the page.  more splitting means more...

I spoke with the GURU.  There was no specific reason for doing this.  He just wanted to "code his DDL easier".  It was an interesting discussion non the less.  Thanks...

Normally I would agree with you, I've met some of those "GURU's".  This one really knew his stuff.  I'll find out if there was a reason and put the post...

Andrew -- you can index # tables.  I'm asking the question because we had a GURU, who seemed to know everything about MS SQL Server.  He created temp table using...

thanks PW, I'm aware of those, I was looking for performance/memory advantages/disadvantages any ideas?

At this stage in my career, with wife and three kids, more vacation time, but more importantly time to take it.  Have 3 weeks now and usually take about a...

can someone provide some examples of how you do the reindex.  What we currently do is loop through the table and exec DBCC DBREINDEX for each table.  I get an...

the basic diff is this:

blocking - one process is waiting on another process.  that other process could be doing whatever, not related o what the first process is doing

Deadlock -...

that what i thought.  but that  is not what is happening.  when i use the group by clause with the second line i get incorrect results.  if i take the...

found a copy of SP4.  It fixed this problem.

found this is Google groups: someone was having same type of problem and said that SP4 corrected the problem.

814113 - FIX DTS Designer May Generate an Access Violation After You...

Any solution to this problem yet???  Im having the same problem today, and have had it in the past.  This seems to be a "bug".  A couple of thing to...

having same problem, has anyone found a solution yet.  Not a problem just very very annoying.

I'm experiencing the same problem, did anyone find an answer to this?