sorry but 300Gb is not a large database. I seem to recollect that the definition of a large database is when you can't back it up within a 24 hour...

I like the fact you show it's a code issue not a sql issue. I'm constantly asked to index queries to improve them when the reality is that often the...

it's nothing to worry about

http://www.sqlservercentral.com/articles/Administering/fragmentation101/1346/

I got someone to write me an excel spreadsheet which I just entered the figures and it worked it out for me!

In most cases database growth is pure guesswork unless...

what you are in effect providing is the ability to write total ad-hoc queries against a table, these types of queries are almost impossible to tune ( with efficient...

make the proc name a filter in text

sadly navision, a product from microsoft, uses almost exculsively client side cursors executing ad-hoc and dynamic sql. So if you're trying to tune this ERP system expect to see lots...

always be wary of removing nvarchar/nchar just in case they were actually put there for a reason, likewise reducing column widths should be done with great care with regard to...

you should not name user stored procedures sp_

I'd suggest a T-SQL training course which will help you to understand set based ops.

you may be able to view waits, sometimes these shows as sos_schedulers, if I remember correctly.

What I will say is that this state of affairs should not happen so there...

it's very important that when you create objects you don't include collate statements unless there is a precise reason to do so, that way your objects pick up the database...

I have to admit I've never tried installing BOL without management studio. Just get the latest net framework 2.x and I assume it should work.

no worries - I find myself often trying to explain why a fill factor of 80% is such a waste of space on etl import tables, or even read only...

you all seem to be using old 2000 tables instead of the 2005 dmvs !

as to original post, logic should dictate that the size of the stored data will not...

no sorry, as I say, I don't use maint plans.