thx a million Andrew! Your assumptions were right by the way. Actually this question came to me from via a colleague dealing with the SCOM 2007 database (I will not...

Hi again

oh yes, I forgot XML strings are not displayed in the web page

This is what it should be:

&ltparameters&gt&ltparameter0&gtKevin&lt/parameter0&gt&ltparameter1&gtoff&lt/parameter1&gt&lt/parameters&gt

I was thinking about XQuery as well but I'm not too...

I don't really understand how this reduces server resource utilization except for network traffic. If a user is paging through the data screen, only a screen full of rows (10,20...)...

Hi again TC

well duh...

When I started investigating and reading articles about the /3Gb switch my feeling (because all info IS INDEED confusing) was that things are exactly as you...

Thanks for the reply TC

info like this is always appreciated by a junior dba like myself!

We are running 32bit and we have AWE enabled. I removed the /3Gb switch from...

thx for the reply David

We have an optimization job every Sunday. Takes about 6h to complete.

This morning I found a msg in my mailbox from a co-worker in another office...

Seems a lot. How do you come to this conclusion?

Hi

I'm just starting to explore the LINQ thingie. Been reading a lot and trying stuff out. I especially like the sqlmetal tool that you can use to create the DAL....

Thx for the quick reply! I kinda expected this answer. But I seldom feel comfortable with these situations. You never know what the installer is doing. Or, it's probably just...

gij onnozel manneke...

just to let you know I'm not picky either. Sorry if I seemed to be from my reply

I just wanted to state that it was confusing (for me at least)....

aggree with the collation thingie

also, the question mentions all lowercase strings while in the answer you mention VALUE1, which is all uppercase...

confusing, that's what I think...

Great stuff! Although I'm one of those guys who loves to find this out himself (you forget less if you need to search yourself) it kinda eases the mind with...

As I wrote, just my opinion...

Haven't read all items, just wanted to share my opinion.

Been programming C, C++, c# for 15 years or so (Hungarian notation, Camel case, ...). Big fan of tidy and well...