Forum Replies Created
Viewing 15 posts - 6,901 through 6,915 (of 10,143 total)
-
RE: Where are you?
Koen (da-zero) (12/28/2010)
I'm writing from Belgium, the land of chocolate, french fries and beer......and mussels mmmm and the Grand Place in summer 🙂
-
RE: Are the posted questions getting worse?
GSquared (12/16/2010)
I like the Red Gate intellisense more than the SSMS default, but I have to admit, they both get in the way as often as they help, till you... -
RE: Are the posted questions getting worse?
Dave Ballantyne (12/16/2010)
Brandie Tarvin (12/16/2010)
So, I have this query that yesterday is working fine and quick when I left out......<Snip>
It's going to be one of those weeks, isn't it?
Sounds dangerously...
-
RE: Are the posted questions getting worse?
Brandie Tarvin (12/15/2010)
...Money rounds funny...That's an Abba song. Now I can't get it out of my head - darn, that's a Kylie song...we gotta get out of this place....aaaaagghhh!!
-
RE: Today's Random Word!
Ray K (12/15/2010)
Daniel Bowlin (12/14/2010)
Ray K (12/14/2010)
crookj (12/14/2010)
Ray K (12/14/2010)
crookj (12/14/2010)
WOTD - "Korean Pears" (love them this time of the year! Man are they good!)Joe
Or would that be Korean...
-
RE: Performance where <> in <> inner join
Abhijit More (12/15/2010)
To answer your question...JOINS always perform better than IN clause. Why ? IN clause is basically performs sub query funcitonality, for each row in outer query it execute...
-
RE: filter in join vs filter in where clause
winston Smith (12/15/2010)
I have two queries. they both return different data, despite looking very similiar. The only difference is that one of the filters has been moved out of the... -
RE: Are the posted questions getting worse?
GilaMonster (12/15/2010)
Chris Morris-439714 (12/15/2010)
I *think* Gail has blogged on this, will look.http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/
http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/
Heh cheers Gail 🙂
-
RE: Are the posted questions getting worse?
Stefan Krzywicki (12/15/2010)
Paul White NZ (12/15/2010)
Stefan Krzywicki (12/14/2010)
Wow. I was having problems with an older query taking too long, so I made what I thought was a little switch to... -
RE: Are the posted questions getting worse?
Stefan Krzywicki (12/14/2010)
I had an idea about the problem I mentioned earlier and I just wanted a quick sanity check.If I run the process with around 15 days in the...
-
RE: Are the posted questions getting worse?
CirquedeSQLeil (12/14/2010)
Does this frighten anybody else?No kidding. Reminds me of Dr Who from the 70's when it was truly scary. We've recently had a sofa installed right near my workstation,...
-
RE: Optimizing This Query
dibbydibby (12/13/2010)
ChrisM@home, I tried your query but it didnt return me the same resultset. Also it was reading the whole table contents into a tmp table and that in itself... -
RE: Wrong "row_number" behaviour
The results are exactly as expected from these trivial statements.
PARTITION BY choice results in 5 rows returned from the first query with dupes eliminated from two of them.
What were...
-
RE: Today's Random Word!
Daniel Bowlin (12/9/2010)
Chris Morris-439714 (12/9/2010)
Ray K (12/9/2010)
WOTD: nothing (as in I don't have a WOTD!)Null!
Interesting.....is nothing the same as null or '', I vote ''
Sorry for the SQL discussion in...
-
RE: Today's Random Word!
Ray K (12/9/2010)
WOTD: nothing (as in I don't have a WOTD!)Null!
Viewing 15 posts - 6,901 through 6,915 (of 10,143 total)