I've been at a few seminars where Kim Tripp spoke and she is awesome.

Ray Higdon MCSE, MCDBA, CCNA

To add to guarddata's post...

Slower now when doing inserts/deletes than before? Have you added an exorbitant amount of indexes?

Do you update your statistics?

Do you use clustered indexes? This is a...

The nolock will actually have more logical IO than not using it (don't beleive me, test it)

Try this

set statistics IO on

SELECT max(id) FROM tablename WITH (NOLOCK)

Now look at logical IO

now...

Because you can not use an order by in a view without top 100 percent, give it a try.

THis will not work

use northwind

create view blah as

select * from customers

order by...

Frank, excellent link on CJ Date's opinions, I still like Celko but can see his points.

Thx

Ray Higdon MCSE, MCDBA, CCNA

If you've tried shrinkfile with no luck, Make sure you don't have long running transactions, check out dbcc opentran.

HTH

Ray Higdon MCSE, MCDBA, CCNA

OK, sounds like you solved it, when in simple you can not do a log backup

Ray Higdon MCSE, MCDBA, CCNA

THis would work, I think this one might be faster but not 100%

SELECT    ts.Store, tp.Department,  tp.Amount

FROM total_spending ts  where ts.store...

If you are on SQL2K, run dbcc sqlperf('logspace') and post the results here, also, what recovery mode are you in for the database? If you don't know you can run...

Try running this first

backup log dbname with truncate_only

Then you should be able to run your statement, I beieve that error pertains to the used portion of the log and virtual...

To add to Ant's post, the other reason to avoid composite clustered indexes is you will get unpredictable page splitting when doing inserts, updates or deletes on any column included...

Just curious, you found something by Celko less well researched? Would love to hear an example.

If you want to know the relational model and theory - Data and databases by...

Good call SQLBill, missed the forest for the trees

Ray Higdon MCSE, MCDBA, CCNA

You shouldn't care about number of pages retrieved but you should care about logical IO which is the number of times SQL had to hit a page. To see this...

IMO the best way to figure out indexes is to test, test, test. Also, you need to weigh your indexes with not only your queries but your inserts as well,...