"Buffer Cache Hit ratio is around 65% on average."

That's still surprising on a 1.8 Terrabytes system with only 1,7Gb ram for sqlserver.

Maybe you can optimize by investigation partitioned tables...

every litle bit of ram helps in this case !

Keep in mind windows itself needs some memory, I guess the 500mb you're leaving will do if it's a dedicated...

In the servers Boot.ini file add :

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINNT="whatever windowssystem " /fastdetect /3GB

You will have to reboot the server to activate it

By default windows only allows an application to use up to 1,7Gb ram.

Adding the /3Gb windows startup parameter, for systems up to 4Gb ram, windows will allow an application to...

Seems to me that your server is on the small tiny side

Adding /3Gb to your startup parameters of Windows may have your sqlserver...

What I mean is that if you want to e.g. select data with a where-clause which has your UTC time used as a predicate, it's best to convert your search-criteria...

keep in mind that if you access an indexed column to which you apply a function, will make the predicate non-sargeble. Meaning the index will not be used and the function...

I'd say that would be good.

How mutch is SQLserver actualy using (task manager) ?

If sqlserver has not enough memory, it has to swap and _that_ may be what's strangling you.

In...

SSIS/Bi-dev studio :

- now they can build packages in a way programers should be used to, debug them and implement them into SSIS like one would implement a program.

-...

-- 1204 Returns the type of lock participating in the deadlock and the current command affect by the deadlock.

-- 1205 Returns more detailed information about the command being executed...

- don't forget to mention the scripting capabilities of SSMS / SMO.

- solution-oriented (cfr VS2005) script libraries

- enhanced (out of the box) templates

- XML datatype and XML-schema-binding !

- XML-docs for...

use SQL2005 SSMS and you'll find it very usefull.

copy/past keeps the colors

the SQL-prefixed ones are collations used by sql2k.

Aparently MS did some optimisations for unicode handling with the new collations.

- Only performance factor i read about is for...

there is a chance someone else will get into the db during the time that you switch sessions !

Executing the alter and restore in a single batch avoids this risk...