Viewing 15 posts - 3,136 through 3,150 (of 5,685 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...
May 24, 2011 at 11:30 am
SQLRNNR (5/23/2011)
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
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!
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....
May 23, 2011 at 3:53 pm
Stefan Krzywicki (5/23/2011)
GilaMonster (5/23/2011)
LutzM (5/23/2011)
GilaMonster (5/23/2011)
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
May 23, 2011 at 3:14 pm
GilaMonster (5/23/2011)
LutzM (5/23/2011)
GilaMonster (5/23/2011)
May 23, 2011 at 3:03 pm
Steve Jones - SSC Editor (5/23/2011)
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...
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...
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...
May 23, 2011 at 2:12 pm
PhilDaniels (5/23/2011)
May 23, 2011 at 1:32 pm
PhilDaniels (5/23/2011)
May 23, 2011 at 12:51 pm
Brandie Tarvin (5/23/2011)
GilaMonster (5/23/2011)
May 23, 2011 at 12:44 pm
Viewing 15 posts - 3,136 through 3,150 (of 5,685 total)