You've heard some thoughts regarding performance gains.

Did you consider backup performance as well ?

Maybe not that much of a gain with sql2000, but with SQL2005 you'll also be able to...

Just my 2ct

- you have to followup size and actual usage anyway.

- if you set maxsize, you have controle and can build a "critical disk reserve" so when the db...

Can someone please explain why there is no base row for :

the easiest way is to open profiler and create a trace using your template.

Then export the trace-settings to a sqlscript.

Add a appropriate filename (see generated script)  and copy/paste it to...

check out http://www.sql-server-performance.com/awe_memory.asp

yes, you are right. Adding the /3Gb should do the trick.

gotchas ? The /3Gb is in the boot.ini so it will need a reboot.

If you do your action on the...

Thanks for the support

Being sysadmin doesn't make you a god after all

indeed, the openrowset may be the "more dynamic" and "let's see what we get" way, but how will it behave regarding performance.

btw in house we are not alowed to use...

I've been to quick with my response using a text column

Aparently text/image operators cannot be used...

same goes for varcharcolumns of 8000

Indeed these kind of constructions will have a cost !

CREATE     FUNCTION [dbo].[fn_ALZDBA_GetFullDescription](@Index int)

RETURNS @tblFullDescription TABLE

 (RefIndex int not...

- did you run DBCC UPDATEUSAGE  ('master') with count_rows 

 followed by sp_updatestats

- I wonder what sp_helpfile returns ?

check out Distribution of Enterprise Manager registrations

maybe applying the Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 will help (or the latest cumulative hotfix 9.00.3161 )

KB 935356

- launch sql profiler and examine your most consuming queries.

- do you have "auto update statistics" activated ?

  if not, did someone run sp_updatestats ?

   changes in stats will...

do your connections use isolation level repeatable read (default for .net) in stead of read committed ?