Viewing 15 posts - 16,801 through 16,815 (of 22,213 total)
It looks basically OK, but I'm curious why you're aggregating the data & selecting the max value. Are there multiple entries with the same key value? That's a bit of...
August 3, 2009 at 7:10 am
You wouldn't by chance be running the Profiler GUI against this server? If so, I'd suggest turning that off and using scripts to create a server-side trace routine. I say...
August 3, 2009 at 7:04 am
I "answered" this post, but I didn't provide a solution to the guy. If someone else would like to take a swing at providing a possible solution for him, he...
August 3, 2009 at 6:59 am
You want an honest answer? Don't do this. Don't use functions in this manner. I've seen an entire application written exactly the way you described. It looked great and when...
August 3, 2009 at 6:55 am
Lynn Pettis (8/2/2009)
August 3, 2009 at 5:26 am
mazzz (7/31/2009)
Steve Jones - Editor (7/24/2009)
clean, used books? give me a battered, dirty, bent copy any day, as long as all the pages are in there!
Same here- the first...
July 31, 2009 at 9:50 am
Sorry, WITH X AS (SELECT), is the syntax for a common table expression, CTE.
Can you post the structure & some sample data. I can play with the proc then. Index...
July 31, 2009 at 8:39 am
I agree. Go ahead and give people as much as they feel they need without endangering your system. They may need it.
July 31, 2009 at 7:55 am
Is there an index in Opportunities on the AccountID? Are your indexes defragmented and the statistics up to date? How selective is the data within the Account table?
Based on what...
July 31, 2009 at 7:53 am
It looks OK. You don't need to use a CTE to do the UPDATE, you can simply UPDATE... FROM and select what you need, but it won't change the overall...
July 31, 2009 at 7:34 am
I guess my question is, why would you NOT go to one of these events? Fear that maybe the people presenting don't know what they're talking about? So leave the...
July 31, 2009 at 7:32 am
It could be compile time or the time needed to move the data into cache or both.
July 31, 2009 at 6:02 am
You must be getting a scan because you're not going to see an index seek when you have functions on columns like that. Like Gail says, post the code, structure,...
July 31, 2009 at 6:01 am
No, an index hint doesn't change the order. The only way to affect the order of the data returned is to use an ORDER BY clause. That will take advantage...
July 31, 2009 at 5:50 am
Viewing 15 posts - 16,801 through 16,815 (of 22,213 total)