Viewing 15 posts - 34,336 through 34,350 (of 59,102 total)
... or not. I've found that sometimes it's more important to prevent parameter sniffing by letting it go ahead and recompile. "It Depends". 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2011 at 6:13 pm
The reason I was asking is that if you had special characters such as < or >, etc, then we'd have to add just a little more code (which also...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2011 at 6:10 pm
BWAA-HAAA!!! Maybe it's not a "stump" after all. Thinking back, I've always joined the tables that will return the smallest result set first so maybe I've seen it...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2011 at 8:11 am
Jeff Moden (4/7/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2011 at 8:02 am
rmechaber (4/7/2011)
I followed up on Craig's comment "Your...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 7, 2011 at 3:07 pm
skcadavre (4/7/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 7, 2011 at 3:02 pm
Either of the following is what I consider to be a "best practice". They're both very fast but the first one edges out the second when it comes to...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 7, 2011 at 2:57 pm
maneeshi_trivedi (4/7/2011)
Yes, I would like to take up your suggestion of looking in to what Moden can really offer.
So please indicate the route via your dad's Company...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 7, 2011 at 2:50 pm
Nadrek (4/7/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 7, 2011 at 2:46 pm
Brandie Tarvin (4/7/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 7, 2011 at 2:42 pm
I sent you another email via this site with my email address in plain text. Notice that it's a .Net and not a .Com address.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 7, 2011 at 2:37 pm
Ah... thanks, Brandie.
As a sidebar, I hate articles like the one on Simple-Talk and the duplicate on the Data Exchange link. There's absolutely no proof of performance of any...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 7, 2011 at 9:10 am
Chris Morris-439714 (4/7/2011)
You're welcome - and you have the benefit of a fully-documented method 🙂
... and no RBAR. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
April 7, 2011 at 8:52 am
Many thanks. Would you mind if I knew your first name? "Sturner said..." just sounds so base. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
April 7, 2011 at 8:41 am
David McKinney (4/7/2011)
I'm aware of the consequences of changing these settings.
Actually I'm not even changing them - the question relates more to scripting the existing setup. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 7, 2011 at 8:39 am
Viewing 15 posts - 34,336 through 34,350 (of 59,102 total)