it depends 😉

SQL Standard can use all of memory which OS can see. So if you have Windws 2003 Ent (x64/x86) or Windows 2003 Std (x64) you can use 32GB...

you can run trace without profiler, is it interesting to you ?

maybe transaction isolation level has changed ?

it depends. maybe you are looking for high availability? or you want to be more proactive on your monitoring tasks ? there are many options - give us more informations.

yeah Solid Quality Learing are real gooooood 😉

SSIS or Import/Export wizard is good idea

othere options are:

1) insert/select (but not entire table at once, you should divide it into smaller pieces)

2) use bulk copy to export to file...

in case of exists/no exsits - it is the only place where you can use star without loosing performance and maitainability

in BOL you can find more information about what LOB_DATA means:

"The LOB_DATA allocation unit contains the data that is stored in columns of type text, ntext, image, varchar(max), nvarchar(max), varbinary(max),...

give us more information about procs ? how many core you have assigned to this vm ? adding cores seems to be good idea.

Paul - i'm impress! your links .. are awesome ! 😉 can you share some more of them ? email?

Yes, bpowers you missed somethin it is called best practicies ;-))

1) you shouldnt shrink database/database files/log files ! there are no reason to do this!

2) what about dbcc checkdb...

he dont need to use trace flag. it is possible to add network backup device and then backup to it. you can add this backup device from UI or by...

But you can run DBCC checkdb on master database and it perform tests on resource database too. I hope this will help you to keep your resource in a good...

Silverfox I think you are wrong - 75% of memory = max server memory ? it may be good for servers with less then 8-12GB RAM, but for biggers boxes?...

i think that vinod.km was talking about something else ... "how to use my datatabase (which is in full recovery model) to bring my systemems online"...

the answer is:

1) are you...