ChrisM@Work

Forum Replies Created

Viewing 15 posts - 2,596 through 2,610 (of 10,143 total)

RE: Are the posted questions getting worse?

Lynn Pettis (2/26/2015)
... Mark one off, 1 day on the calendar to go. 1 day on the calendar to go, 1 day to go, ...
Happy travels Lynn, hope everything goes...
^{“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

February 27, 2015 at 6:56 am

#1780576
RE: Are the posted questions getting worse?

Brandie Tarvin (2/26/2015)
ChrisM@Work (2/26/2015)
BWFC (2/26/2015)
Ed Wagner (2/26/2015)
Jeff Moden (2/25/2015)
Lynn Pettis (2/25/2015)
... Mark one off, 2 days on the calendar to go. 2 days on the calendar to go, 2 days...
^{“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

February 27, 2015 at 6:54 am

#1780575
RE: Are the posted questions getting worse?

BWFC (2/26/2015)
Ed Wagner (2/26/2015)
Jeff Moden (2/25/2015)
Lynn Pettis (2/25/2015)
... Mark one off, 2 days on the calendar to go. 2 days on the calendar to go, 2 days to go, ...
And...
^{“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

February 26, 2015 at 6:23 am

#1780214
RE: Are the posted questions getting worse?

Jeff Moden (2/25/2015)
Brandie Tarvin (2/25/2015)
Need some advice, all. I'm about to rewrite a novel of mine and I need references for research. My protagonist (the star) is humanoid but 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

February 26, 2015 at 1:27 am

#1780130
RE: Sql query need to be updated as group by

Wild guess:
SELECT
a.U_Empid AS [SAP ID],
OHEM.U_IQId AS [Iqama No],
ISNULL(OHEM.firstName,'') + ISNULL(' ' + OHEM.middleName,'') + ISNULL(' ' + OHEM.lastName,'') AS [Employee Name],
OUDP.Remarks AS [Department],
a.U_PyrlMnth AS [Work Month],
a.U_ProjectCode AS [Project...
^{“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

February 25, 2015 at 6:59 am

#1779897
RE: WHERE 1 = 1,who uses this besides me

SQLRNNR (2/24/2015)
ChrisM@Work (2/24/2015)
Dogma spawns bad code as efficiently as laziness and ignorance.
Nice. Great quote. I'm gonna use it now.:-D
That’s Plan B. Plan A was one of those 30-plus-letter...
^{“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

February 24, 2015 at 9:58 am

#1779657
RE: Dynamically Query a 100 Million Row Table-Efficiently

gary.strange-sqlconsumer (2/24/2015)
Adam is my brother, an awsome System Admin.
and Chris must be his colleague. Took me a little while to figure that one out. 😀
He is awesome, but don't tell...
^{“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

February 24, 2015 at 6:56 am

#1779572
RE: WHERE 1 = 1,who uses this besides me

PHYData DBA (2/23/2015)
ChrisM@Work (2/23/2015)
PHYData DBA (2/23/2015)
Care to divulge?
Since you did not specify I am going to just restate one that this discussion is about -
Never add a where statement 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

February 24, 2015 at 2:10 am

#1779506
RE: Dynamically Query a 100 Million Row Table-Efficiently

Very good article Gary, I gave it five stars because you covered the ground with some excellent explanations. Two omissions stood out however - the cost of recompiling, and why...
^{“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

February 24, 2015 at 1:37 am

#1779498
RE: WHERE 1 = 1,who uses this besides me

PHYData DBA (2/23/2015)
bantrim (2/22/2015)
Eric M Russell (2/22/2015)
On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into a temp table that is derived from...
^{“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

February 23, 2015 at 8:24 am

#1779276
RE: Are the posted questions getting worse?

rodjkidd (2/21/2015)
Chris,
I've just realised I'm going to Shepherds Bush Thursday night - Trevor Horn Band is playing a one off gig with Seal as special guest. So it will 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

February 23, 2015 at 1:59 am

#1779201
RE: Query Causing Blocking, Locks Table for 1000 Seconds, Help Needed!

sgmunson (2/18/2015)
Velveeta22 (2/17/2015)
Matched the column names to the original stuck query and added friendly alias'. Results pull matching data in both test and prod (fresh data). My hope...
^{“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

February 19, 2015 at 1:42 am

#1778558
RE: WHERE 1 = 1,who uses this besides me

DonlSimpson (2/18/2015)
...
I think it's just lazy though.
When "lazy" translates to "quick, easy and accurate" it's not so bad.
^{“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

February 19, 2015 at 1:35 am

#1778555
RE: WHERE 1 = 1,who uses this besides me

Eric M Russell (2/18/2015)
Eric M Russell (2/18/2015)
Resender (2/2/2015)
ok this is something of a best practice of mine in my queries
I always do
WHERE 1 = 1
I can't remember where I picked...
^{“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

February 19, 2015 at 1:32 am

#1778554
RE: WHERE 1 = 1,who uses this besides me

Eric M Russell (2/18/2015)
Resender (2/2/2015)
ok this is something of a best practice of mine in my queries
I always do
WHERE 1 = 1
I can't remember where I picked this habit up...
^{“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

February 19, 2015 at 1:29 am

#1778552

Viewing 15 posts - 2,596 through 2,610 (of 10,143 total)