I would reccomend you search this site first, then check out some of these links below, then post more specific questions. it will save you time rather than wait for...

A composite clustered index is not a good idea if you mainly have inserts as this will cause unpredicatable page splits, a clustered index on an ID column would be...

Without knowing the DDL this is just a guess:

 create trigger blah on table 

for update, insert, delete

as

insert into table1 select * from inserted

insert into...

quote:

---

From glively: If you are getting a lot of inserts and updates, make sure you DO NOT have a clustered index on...

If you do not have recurring log backups your log will continue to grow as DB backups do not truncate the log file. If you do not require transactional recovery...

You don't have to drop and recreate them, just use an alter table statement and disable and then re-enable them. If this is a common practice you might create a...

If you have free space in your database you can use dbcc shrinkdb or dbcc shrinkfile. See BOL for syntax.

HTH

Ray Higdon MCSE, MCDBA, CCNA

This is due to ODBC tracing I believe, check out this page:

http://support.microsoft.com/default.aspx?scid=kb;en-us;268591

HTH

Ray Higdon MCSE, MCDBA, CCNA

For physical IO I agree, but when using "statistics IO" logical IO is only incremented if it is actually used in the query so logical IO or the number of...

Oops, looks like you are right, sorry. You have sp6 on the OS, do you have SP4 on the DB? Here is the fixlist for it http://support.microsoft.com/default.aspx?scid=kb;en-us;Q313980& , maybe one...

I agree with Jonathan in that you could do several things in the trigger to allow preferential treatment, using things like host_name() or suser_sname() to qualify what to allow through.

HTH

Ray...

Here's a thought, do you have the latest service pack to ensure you don't have Mr. Slammer?

Ray Higdon MCSE, MCDBA, CCNA

That would get SQLServerCentral more money as well 🙂

Ray Higdon MCSE, MCDBA, CCNA

I don't know the financial details but MS has something called software assurance that you can buy at an enterprise agreement or by the server which guanrantees you teh current...

Makes sense, sometimes you can get it a little smaller with dbcc shrinkfile.

Thanks for posting update!

Ray Higdon MCSE, MCDBA, CCNA