What about autogrow on the database? Is it have to expand every 5 minutes.

Monitor Page Splits on tables and indexes. Use a Fill Factor.

ThomBeaux

Thanks foir the reply, our Network admin is checking for the "Lock in memory" setting.

Thanks and God Bless,

ThomBeaux

http://msdn2.microsoft.com/en-us/library/ms143241.aspx

Good article!!!

Scored 39 at new job.

ThomBeaux

Thanks for the article, very nice, and I look foward to the continuation on this subject.

ThomBeaux

I watch videos from many different sites, espically from Microsoft all the time.

Our network here is not a problem.

ThomBeaux

Steve,

I do not believe you can say "...don't think that any other CEO would have acted much differently in building their business.", because there are some people out in the...

Where is a link to Part I.

Thanks,

ThomasLL

Can you explain why this code did NOT "close the transaction". I see the Begin Trans and Commit, why would this code "hang"?

Thanks,

Thomas LeBlanc MCP

I got an error trying this. I 3 column table with hr, Source, and Description as the column headings:

hr

0x800401F3

Source

ODSOLE Extended Procedure

Description

Invalid class string

Thanks,

ThomBeaux

Thanks for y'all's comments.

I have always used "codes" for lookup type tables, and multi column primary keys for transaction tables because most applications I have programmed do not have a...

Good idea.

ThomasLL