Viewing 15 posts - 2,296 through 2,310 (of 4,080 total)
Trudye, since you are obviously a beginner, I will help you out a little on this one. BB is absolutely right, though. If you...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 26, 2009 at 1:57 pm
Is that wrong or is it 12 of one, half dozen of the other?
That would be SIX of one, half a dozen of the other. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 26, 2009 at 1:38 pm
Is it just me, or are we starting to get a lot of "homework" questions again? I've seen several lately that seemed to be absolutely basic,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 26, 2009 at 1:23 pm
Jeff has posted about this type of update before. Basically, it's a time bomb waiting to explode, and when it does it will cause extreme slowness in your server.
Thanks for...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 25, 2009 at 1:20 pm
Where row_number() ceases to be the most efficient technique depends on a number of variables, like the row size being retrieved and the existence of index. The...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 24, 2009 at 11:23 am
I thought this was a good question because I've run across a number of people who didn't realize it was possible, but the example troubles me. It just...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2009 at 11:09 pm
For low volume queries, you can also use a cte with ROWNUMBER() using both partition and order by, then testing for where rownumber = 1.
Look up the syntax for ROWNUMBER()...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2009 at 9:51 pm
AllRIGHT! Extra effort paid off. I just got approval to go to PASS. 😀 😀 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2009 at 9:42 pm
Have you tried looking this up? Or even taking a guess? It's really terribly awfully simple.
I'm guessing this is part of a...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2009 at 9:31 pm
I might finally be ready to stop cross-joining master..syscolumns.
I can't stop either, Barry. It's a sickness, I tell you. :w00t:
Maybe we should form...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2009 at 1:50 pm
Fine article, Lynn, and another rocking discussion, everyone.
I'm cussing now because work is taking away from my reading time in here.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2009 at 9:28 am
Spend enough cache and you can buy a better query plan?
(Sorry, Emperor Paulpatine. I just couldn't resist.)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 22, 2009 at 10:19 am
In the NFL all my ties are to the Giants, but they didn't look that great on offense last night. To me, the Cowboys beat them everywhere...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 21, 2009 at 10:57 am
People
Eating
Tasty
Animals
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 20, 2009 at 5:05 pm
We all know SQL is not really great for running totals, but two things it does outstandingly well are summary queries and looking stuff up. Your percentage calculations...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 20, 2009 at 7:29 am
Viewing 15 posts - 2,296 through 2,310 (of 4,080 total)