ChrisM@Work

Forum Replies Created

Viewing 15 posts - 2,056 through 2,070 (of 10,143 total)

RE: Are the posted questions getting worse?

Ed Wagner (10/14/2015)
ChrisM@Work (10/14/2015)
Alvin Ramard (10/14/2015)
An important difference between cats and dogs is how they react when punished.
Punish a dog for doing something bad and it thinks: "I'd better not...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For 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

October 14, 2015 at 8:20 am

#1833253
RE: Are the posted questions getting worse?

Alvin Ramard (10/14/2015)
An important difference between cats and dogs is how they react when punished.
Punish a dog for doing something bad and it thinks: "I'd better not do that again."
Punish...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For 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

October 14, 2015 at 7:57 am

#1833244
RE: Are the posted questions getting worse?

djj (10/14/2015)
Found a handkerchief in the living room today that had been on a shelve in the bathroom. This from a cat who has several toys.:hehe:
Perhaps she has a...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For 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

October 14, 2015 at 7:56 am

#1833242
RE: Are the posted questions getting worse?

Brandie Tarvin (10/14/2015)
A couple of my cats play fetch. The toy mouse (or feather on a string) gets dropped in front of my feet and I know it's time to...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For 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

October 14, 2015 at 4:38 am

#1833170
RE: Are the posted questions getting worse?

Sean Lange (10/13/2015)
Grant Fritchey (10/13/2015)
Brandie Tarvin (10/13/2015)
GilaMonster (10/13/2015)
Put the keyboard down, pet the cat. Priorities!
Now she's hissing at me because I made the mistake of trying to move my other...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For 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

October 14, 2015 at 1:39 am

#1833134
RE: Are the posted questions getting worse?

Eirikur Eiriksson (10/8/2015)
dwain.c (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For 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

October 12, 2015 at 7:39 am

#1832810
RE: performance improvement

sushil_dwid (10/12/2015)
Performance issue on Query. Here is query which i ran and it takes around 7-8 min to give the output. Could you please suggest the alternate way to write...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For 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

October 12, 2015 at 6:44 am

#1832796
RE: Temp Table's Primary Key Default

ChrisM@Work (10/9/2015)
rchantler (10/9/2015)
You can even define the field to be UNIQUE in the table definition to get the effect.
That's enforced by a UNIQUE index, so it's the same as we...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For 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

October 9, 2015 at 8:31 am

#1832559
RE: Temp Table's Primary Key Default

rchantler (10/9/2015)
You can even define the field to be UNIQUE in the table definition to get the effect.
That's enforced by a UNIQUE index, so it's the same as we have...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For 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

October 9, 2015 at 8:14 am

#1832552
RE: Temp Table's Primary Key Default

rchantler (10/9/2015)
Yes, there are at least 2 questions - 1. why the poor performance with adding a UNIQUE constraint and 2. why does switching from left join to inner join...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For 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

October 9, 2015 at 7:57 am

#1832543
RE: No predicate join work around

ChrisM@Work (10/9/2015)
SQL_Surfer (10/8/2015)
I have two tables. Table A has 2162 rows and table B has 101 rows. There isn't any join keys that I can join on these two tables....
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For 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

October 9, 2015 at 5:49 am

#1832500
RE: No predicate join work around

SQL_Surfer (10/8/2015)
I have two tables. Table A has 2162 rows and table B has 101 rows. There isn't any join keys that I can join on these two tables. But...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For 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

October 9, 2015 at 2:17 am

#1832461
RE: Temp Table's Primary Key Default

Kim Crosser (10/8/2015)
Kristen-173977 (9/29/2015)
rchantler (9/28/2015)
CREATE CLUSTERED INDEX IDX_hidvals ON #hidvals(hid)
That is not declared as UNIQUE, so not quite the same thing as a PRIMARY KEY's Clustered Index (SQL will add...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For 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

October 9, 2015 at 2:06 am

#1832455
RE: Need help with a simple query from a one to many table relation.

Greg Edwards-268690 (10/8/2015)
NOT EXISTS, from what I understand, is a simple Boolean check.
Aggregates must first gather all results.
I am not at all surprised it is generally faster.
Many times I found...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For 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

October 8, 2015 at 10:03 am

#1832346
RE: Performance tuning of query for PDW

Jeff Moden (10/7/2015)
Jason A. Long (10/7/2015)
Jeff Moden (9/6/2015)
Grant Fritchey (9/6/2015)
Jeff Moden (9/6/2015)
Grant Fritchey (9/6/2015)
You've shown very simplistic queries that are hitting entire data sets. Your tuning opportunities here are limited...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For 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

October 8, 2015 at 5:30 am

#1832259

Viewing 15 posts - 2,056 through 2,070 (of 10,143 total)