Maybe I should start another thread... but is there a way to start a trace with the profiler, and save the execution plans at the same time?

Your trick is good, but it still has a small pitfall. I preffer that he knows what he gets into before implementing to production.

No disrespect intended

It's not a bug. It's been announced that this syntaxe would not be supported in Yukon. Download the sql server best pratices analyser and run it on your...

Let me first say that this is the kind of situation where it's better to sort at the client. But if it's not possible, then read on.

There's a catch...

It's always a good idea to have a clustered index. Make sure you don't just make a clustered index for the fun ot it. Be certain that it's...

I hate to guess... that's why I didn't bother to even try on this one.

No clue... keep me posted .

Can't help you with that.. never used RS before.

Can't you put a label or a textbox for that?

HTH

Select ColorNO from dbo.YourTable where OID = 666 group by ColorNO

having count(*) > 1

Still a pointless debate.

Use what you like and I'll keep using text datatype only when I need to, and it's still not known to be the case here. I've...

Yes just like the car is his, he just doesn't have the ????? box he's an administrator.. or past 5k posts??

Question about >>>> SQL Query Anylizer

nothing about a command object that would make me think it's about the apllication call of the parameter.

Open profil then click My Avatar

between "Your Signature" and "Profil picture"