I sometimes find reports take longer to run - you need to tune/optimise reports just the way you'd tune any other sql - try setting the reports to generate/create themslves...

and we've not even mentioned the vast range of or lack of skills that a person who calls themself DBA has ( or hasn't )

This is probably the most...

can you give me a clue? phone a friend ? ask the audience ?

inline functions tend to turn set based queries into cursor based queries, this would be probably worse within a view.

as far as I know this is correct - certainly this is what BOL says.

try using a while loop ( cursor in disguise )

enabling the 3GB switch is not always the best way to go as it restricts lower memory in 32 bit editions.

You can use awe without the 3gb switch with...

make sure you include the msqlsystemresource files too otherwise you might have some problems.

I agree, removing log files is irresponsible and flies in the face of what a DBA stands for. And why the obsession to shrink files, do you actually know what...

I don't really know how to test this properly - are you adding the login in the context of master database - which should be case insensitive rather than the...

I've used the -g command but with sql 2000, my probs with mem to leave were query plans but i've also heard that lite speed can suffer the same.

you...

I currently support a 1.5TB navsion on sql 2005 send me an email and we'll talk direct - there's just no way we could do this through the forum (...

I'd perfmon the server to look for a bottleneck, e.g. disk, cpu, memory. Don't have anything that size to compare or any other suggestion other than to find out what's...

one of the crucial changes in sql2005 was the reworking of the optimiser, like for like sql2005 should be faster than sql2000 and in basic testing I did this was...

unless something has changed or unless you're using 64bit sql std you can't use extra memory.