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 🙂
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
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...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
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...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
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!!
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
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...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
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...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
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...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
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 🙂
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
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...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
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...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
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,...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
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...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
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...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
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...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
RE: Today's Random Word!
Ray K (12/9/2010)
WOTD: nothing (as in I don't have a WOTD!)Null!
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Viewing 15 posts - 6,901 through 6,915 (of 10,143 total)