issuing a checkpoint will clear any data which is committed. I take it you are talking about the physical tempdb files here? There is a situation that space taken by...

you can't do this in 2005, I've tried!

I'm not sure why you'd want to do this through perfmon, the dmvs are much better for this sort of thing.

one thing I've found in tuning client applications is that table variables when you populate them with a large number of rows, for example 15k and then put them back...

reversing would not make any difference as you'll get just as many starting with 1, 2, 3, 4 etc. ( no I'm not that sad to sit down and work...

oh and to add to the mix there are a number of issues in w2k3 prior to sp2 which affect sql server AND you need a couple of post sp2...

there are a number of memory issues which can cause quite severe performance problems - I know because I had a couple of long running incidents with ms, these were...

we've posted this to death and to death - however -

you can only lock pages in memory for enterprise sql server:: if you have enterprise then lock pages.

IMPORTANT always...

Mine comes down to interviewing certified and non certified dba's - I remember one who had a number of certifications in both o/s and sql - I asked how to...

I have to agree with Jeff - there needs to be a better way of becoming certified without cramming with transender. I did one exam which I failed, back in...

there's rarely any issues moving databases x32 to x64 - most people have issues with the config of the o/s and sql server. Maike sure you're at sp2 + cu6...

this is often a problem - you might try optimising the code so it takes less than 30 seconds ???? Most likely there will be timeouts set in connection strings...

that kb is pre sp1 - you should be running sp2 with all the rollups + the fixes for rdp, large file copies ( registry change ) and look out...

1.7GB is the standard x32 memory used when no switches are enabled. with 8gb of ram I'd advise you forget the 3gb switch and enable awe and set sql server...

No, wish it were that easy. I find it all very interesting, sadly, but the optimisers are so different that some queries run so much better and...