Viewing 15 posts - 1,606 through 1,620 (of 5,678 total)
Chrissy,
One approach to this that helps keep your code intact and allows for manipulatable result ordering is using temp tables. If you do something like the following:
CREATE PROC abc
@sortdescriptor...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 25, 2012 at 2:36 pm
aballard (4/24/2012)
SELECT m.* FROM dbo.t_main m INNER JOIN dbo.t_main_ref ref on (m.id = ref.mainid) WHERE (ref.FK1 = @Condition1) and (ref.FK2 = @Condition2) and (m.Column5 = @Condition3) and (m.Column6 < GETDATE())
The...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 25, 2012 at 2:30 pm
It can be a bit confusing, but basically what you end up having to do is clean off the 'year' and replace it.
There's a few approaches, but direct datediff/dateadd math...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 24, 2012 at 7:33 pm
Grant Fritchey (4/24/2012)
GilaMonster (4/24/2012)
The Dixie Flatline (4/24/2012)
I just finished reading "Shadows In Flight", if you've ever read Orson Scott Card and like Bean better than Ender. Recommended.
Intriguing......
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 24, 2012 at 7:29 pm
aballard (4/24/2012)
I have a table with the structure
(ID Guid
FK1 Guid
FK2 Guid
FK3 Guid
Priority Bit)
The ID in this table...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 24, 2012 at 7:19 pm
GilaMonster (4/24/2012)
Evil Kraig F (4/24/2012)
Heh, you guys reminded me that I want to order up the final books in the Dresden series and finish that... 🙂
Final? <sob>
If it finishes where...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 24, 2012 at 7:12 pm
Chrissy,
Is this to allow passing the sorting components down to a pagination proc? That's the time I see items like this the most often. If it is, there's...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 24, 2012 at 5:41 pm
GilaMonster (4/24/2012)
The Dixie Flatline (4/24/2012)
I just finished reading "Shadows In Flight", if you've ever read Orson Scott Card and like Bean better than Ender. Recommended.
Intriguing... I loved...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 24, 2012 at 4:28 pm
Heh, you guys reminded me that I want to order up the final books in the Dresden series and finish that... 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 24, 2012 at 4:23 pm
GilaMonster (4/19/2012)
Considering trying out EVE. Thought I'd download the client while I'm in the UK and see how it goes, nothing much to lose.
I should have mentioned Eve, I played...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 19, 2012 at 5:56 pm
GilaMonster (4/19/2012)
#declare NewTopic;
Who plays MMOs and which ones?
I've just quit the one I played for a few years, they added a 'pay to...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 19, 2012 at 5:19 pm
GilaMonster (4/19/2012)
Evil Kraig F (4/19/2012)
*sniff*http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/
Ah hah! There it is. I got my keywords all confuzzled. :crying: Thanks Gail (both for the blog post AND linking it for...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 19, 2012 at 4:10 pm
SkyBox (4/19/2012)
So basically, if you can create or keep an index that can cover serveral others, then queries can use the larger index with more coverage just as efficiently?
If...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 19, 2012 at 3:53 pm
The Dixie Flatline (4/19/2012)
Evil Kraig F (4/19/2012)
The Dixie Flatline (4/19/2012)
Well I was... except for the part about dying at PASS. 😉
Please remember this year that "Extreme programming...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 19, 2012 at 3:44 pm
The Dixie Flatline (4/19/2012)
Well I was... except for the part about dying at PASS. 😉
Please remember this year that "Extreme programming styles" does not usually include stunt...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 19, 2012 at 3:35 pm
Viewing 15 posts - 1,606 through 1,620 (of 5,678 total)