Viewing 15 posts - 3,136 through 3,150 (of 5,678 total)
Sweet! Thanks for getting involved Paul. Alright, let's take it from the top, boys! *drumroll starts*
SQLkiwi (5/23/2011)
It allows the Segment Top transformation without a sort, which is...
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
May 24, 2011 at 11:30 am
SQLRNNR (5/23/2011)
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
May 23, 2011 at 5:53 pm
If anyone wants an interesting optimization conundrum (at least to me), please swing by this thread I started: http://www.sqlservercentral.com/Forums/Topic1113705-392-1.aspx
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
May 23, 2011 at 5:27 pm
SQLRNNR (5/23/2011)
jcrawf02 (5/23/2011)
Not a fan of roses, Craig?Maybe he is saying he doesn't smell like roses??
I'm not a rose! I'm a free man!
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
May 23, 2011 at 3:55 pm
jcrawf02 (5/23/2011)
Not a fan of roses, Craig?
Not today, no. Was time for something different, was on my mind. However the full version of it isn't professional for here....
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
May 23, 2011 at 3:53 pm
Stefan Krzywicki (5/23/2011)
GilaMonster (5/23/2011)
LutzM (5/23/2011)
GilaMonster (5/23/2011)
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
May 23, 2011 at 3:16 pm
Flip the ordering, output before where. It actually goes in front of the FROM but you don't have that there.
See this for more details: http://msdn.microsoft.com/en-us/library/ms177564.aspx
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
May 23, 2011 at 3:14 pm
GilaMonster (5/23/2011)
LutzM (5/23/2011)
GilaMonster (5/23/2011)
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
May 23, 2011 at 3:03 pm
Steve Jones - SSC Editor (5/23/2011)
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
May 23, 2011 at 2:33 pm
spx (5/23/2011)
In the query-3, the 99% (of 104 secs) is used by the "Remote Scan/FullText Search Engine"
In the query-1, the 99% (of...
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
May 23, 2011 at 2:31 pm
Peter Trast (5/23/2011)
http://msdn.microsoft.com/en-us/library/cc949109(v=sql.100).aspx
The article by Paul has not sufficiently illuminated 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
May 23, 2011 at 2:23 pm
Couple of ideas.
Instead of a permanent table, teach them to use a #tmp and pull the data over into that. 5k rows shouldn't be that painful.
Use schema for this...
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
May 23, 2011 at 2:12 pm
PhilDaniels (5/23/2011)
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
May 23, 2011 at 1:32 pm
PhilDaniels (5/23/2011)
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
May 23, 2011 at 12:51 pm
Brandie Tarvin (5/23/2011)
GilaMonster (5/23/2011)
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
May 23, 2011 at 12:44 pm
Viewing 15 posts - 3,136 through 3,150 (of 5,678 total)