Viewing 15 posts - 2,341 through 2,355 (of 4,080 total)
having the column would make all queries faster and more performant
Ask him how it is supposed to do that? Fewer rows will fit on a page, so arguably...
__________________________________________________
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 14, 2009 at 10:15 am
I've set mine up where the primary key consists of both columns (uniqueness) and then make one nonclustered key with the columns reversed (It is automatically a covering index). ...
__________________________________________________
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 14, 2009 at 10:07 am
If you can run your script from SMSS, try this:
Tools\Options\Query Results\SQL Server\Results to Text ... then choose your options.
At least that's what it is in 2008. I can't...
__________________________________________________
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 14, 2009 at 10:02 am
It means Ni?
Does it always?
It is a mystery.
__________________________________________________
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 14, 2009 at 7:39 am
Do a quick search at SSC (search function is to the upper right) and you will find plenty of examples of how to handle this. The key terms...
__________________________________________________
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 14, 2009 at 7:37 am
We forgive you for agreeing with us, PP 🙂
__________________________________________________
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 14, 2009 at 7:33 am
I apologize to Barry for agreeing with him.
__________________________________________________
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 14, 2009 at 7:28 am
Ni!
It's a funny word. I can't understand it. What does it mean? 😀
__________________________________________________
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 14, 2009 at 7:17 am
Hearing none opposed, the motion carries by acclamation.
So say we all.
__________________________________________________
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 14, 2009 at 7:04 am
Thanks for posting back your final solution, kabaari.
__________________________________________________
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 14, 2009 at 7:03 am
... and mine runs faster.
Game, Set and Match 😉
__________________________________________________
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 14, 2009 at 7:01 am
Paul and Matt,
I sincerely hope I wasn't too offensive.
As I said, it wasn't personal, I speak only for myself, and nobody else may mind at all....
__________________________________________________
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 13, 2009 at 9:47 pm
Great, just great. Now I've got to clean spam off the water cooler..... 😉
Speaking only for myself, I resent this intrusion into what is normally 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 13, 2009 at 9:03 pm
You're welcome, Jeff. You will find "PARTITION" under ROW_NUMBER() in books online. If you do a generic search on "partition", it will take 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 13, 2009 at 3:50 pm
Many thanks, Roger.
__________________________________________________
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 13, 2009 at 10:27 am
Viewing 15 posts - 2,341 through 2,355 (of 4,080 total)