Viewing 15 posts - 4,891 through 4,905 (of 18,926 total)
Why does he make you choose either or?
Once you have a server under control, being a DBA doesn't take a lot of time.
July 14, 2011 at 6:17 am
As a side note it'd be interesting to see if it's worth posting a connect item about this.
I personally think it isn't... because if you look at the plan you...
July 14, 2011 at 6:03 am
Actually july 15th is not the correct date either. You HAVE TO use order by with top to garantee the correct results.
SELECT MAX(TB.dt) AS dt
FROM (SELECT TOP 7...
July 14, 2011 at 5:56 am
GilaMonster (7/14/2011)
Ninja's_RGR'us (7/14/2011)
Steve Jones - SSC Editor (7/14/2011)
GilaMonster (7/13/2011)
Jim Murphy (7/13/2011)
Gail, aren't you a moderator still? Maybe you can just whack that whole thread in Steve's absence.
I've never been...
July 14, 2011 at 5:51 am
SELECT B.* FROM dbo.tableB B INNER JOIN dbo.tableA A ON B.Field LIKE '%' + A.Field + '%'
Now keep in mind that this can be slow as hell on if either...
July 14, 2011 at 5:50 am
Steve Jones - SSC Editor (7/14/2011)
GilaMonster (7/13/2011)
Jim Murphy (7/13/2011)
Gail, aren't you a moderator still? Maybe you can just whack that whole thread in Steve's absence.
I've never been a moderator...
July 14, 2011 at 5:20 am
Steve Jones - SSC Editor (7/14/2011)
GilaMonster (7/13/2011)
Jim Murphy (7/13/2011)
Gail, aren't you a moderator still? Maybe you can just whack that whole thread in Steve's absence.
I've never been a moderator...
July 14, 2011 at 5:19 am
We all agree on that Lutz but...
krypto69 (7/13/2011)
I talked to the dev and he says he must use that function -
So I'm guessing that this is a dynamic parameter and...
July 13, 2011 at 4:00 pm
I just had to have fun with this.
I had to try like 15 different things to whack any sort of loop. Anyhow this is really nice and usable. ...
July 13, 2011 at 3:58 pm
LutzM (7/13/2011)
table valued yes, but not in-line...I expected a string delimiter function.... 😉
Search this site for DelimitedSplit8K to find a much better performing solution.
http://www.sqlservercentral.com/Forums/Topic1101315-203-6.aspx#bm1129283
July 13, 2011 at 3:30 pm
krypto69 (7/13/2011)
it does run faster (3 sec) if I take out the last joinI talked to the dev and he says he must use that function -
Please post the function's...
July 13, 2011 at 3:07 pm
Jeff Moden (7/13/2011)
Freddie-304292 (7/13/2011)
July 13, 2011 at 2:58 pm
Does it run way faster if you take out the last join?
Why do you use nolock? http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
Can you post the actual execution plan?
July 13, 2011 at 2:14 pm
Yup those settings should be off.
Happy blitz-hunting!
July 13, 2011 at 2:00 pm
SQLkiwi (7/13/2011)
Ninja's_RGR'us (7/13/2011)
Am I missing a really easy joke or you didn't post the correct picture?The joke is he is using FireFox 😉
Tx!
July 13, 2011 at 1:55 pm
Viewing 15 posts - 4,891 through 4,905 (of 18,926 total)