ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,366 through 1,380 (of 10,143 total)

RE: Checking if a string value includes a value from a field

DSC123 (7/27/2016)
Morning all,
Please could someone advise me on the correct syntax for highlighting if an email address includes a year of birth?
So far I have created the following, the last...
^{“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

July 27, 2016 at 4:46 am

#1892222
RE: Complex join and sorting the parent and child data

Eirikur Eiriksson (7/26/2016)
Piling on, the demonstrated expected output does not fit the description, can you please clarify?
😎
The rows for citycode 'MRO' are upside down 🙂
^{“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

July 26, 2016 at 9:20 am

#1892080
RE: Complex join and sorting the parent and child data

J Livingston SQL (7/26/2016)
cant fathom your sort order...please explain
cant see how "Order data based on latest year first and then City code and then Subcitycode " delivers what you 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

July 26, 2016 at 9:19 am

#1892079
RE: Fibonacci Series in TSQL

Thibaut Blanchin (7/26/2016)
100 is the max number that can be passed to the function due to recursivity depth limit.
From BOL:
"MAXRECURSION number
Specifies the maximum number of recursions allowed for this...
^{“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

July 26, 2016 at 7:48 am

#1892046
RE: Fibonacci Series in TSQL

patrickmcginnis59 10839 (7/26/2016)
where's the set oriented version? 😉
Over to you, Patrick 🙂
^{“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

July 26, 2016 at 6:50 am

#1892027
RE: Fibonacci Series in TSQL

Iwas Bornready (7/26/2016)
Michael Meierruth (12/18/2014)
OK, so it's a cute CTE exercise.
But has anyone ever used the Fibonacci series values for anything in the real world?
I would be curious to know.
It...
^{“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

July 26, 2016 at 6:49 am

#1892026
RE: Are the posted questions getting worse?

BrainDonor (7/26/2016)
Somewhere deep within the bowels of Microsoft there's a team of developers who believe that there's nothing at all wrong with the way SSIS ascertains the metadata for the...
^{“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

July 26, 2016 at 4:55 am

#1892007
RE: Fibonacci Series in TSQL

This was covered in 2009 by Peter Larsson.
^{“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

July 26, 2016 at 4:35 am

#1892004
RE: Are the posted questions getting worse?

Alan.B (7/25/2016)
Maybe it's Monday a Monday morning thing but even the small things are annoying me today. Just ran accross this:
[Gender] varchar(100) NULL,
It's fine! I've seen NVARCHAR for gender today....
^{“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

July 25, 2016 at 9:22 am

#1891841
RE: Pivot without an aggregate?

Think of it like this: you have to take data from all 7 rows for John, but somehow only return 1 row with data from all of them. That's an...
^{“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

July 22, 2016 at 10:01 am

#1891626
RE: Identical Query, Different Execution Stats

matt.gyton (7/21/2016)
So it turns out my earlier optimism was slightly misplaced....the code change did not provide the fix 🙁
However, I noticed that it temporarily improved performance until the SP ran...
^{“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

July 21, 2016 at 4:50 am

#1891270
RE: Are the posted questions getting worse?

Hugo Kornelis (7/21/2016)
GilaMonster (7/21/2016)
ThomasRushton (7/21/2016)
BrainDonor (7/21/2016)
Does anybody know who the "Hotshot SQL Guru" is?
https://tmblr.co/Z14uHt29WaOS7
https://tmblr.co/Z14uHt29Ww0kS
https://tmblr.co/Z14uHt29ZP3zF
Somebody wasn't impressed.
Celko?
The first wouldn't apply to Celko. Traceflags aren't ansi standard.
Some people, unfortunately, have an elevated...
^{“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

July 21, 2016 at 3:17 am

#1891244
RE: Identical Query, Different Execution Stats

matt.gyton (7/20/2016)
Think I may have a solution!
I experimented with the plans by comparing the two XML versions on a diff checker and they came up almost identical with the...
^{“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

July 21, 2016 at 3:03 am

#1891241
RE: Today's Random Word!

Revenant (7/14/2016)
djj (7/14/2016)
Ed Wagner (7/14/2016)
Luis Cazares (7/14/2016)
crookj (7/14/2016)
Ed Wagner (7/14/2016)
Grumpy DBA (7/14/2016)
Ed Wagner (7/14/2016)
ThomasRushton (7/14/2016)
Ray K (7/13/2016)
Lucy
Lastic
Elastic
Plastic
Melt
patty
burger
Beef
Pork
Porcupine
Concubine
^{“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

July 14, 2016 at 8:39 am

#1890131
RE: Are the posted questions getting worse?

Luis Cazares (7/14/2016)
jasona.work (7/14/2016)
ChrisM@Work (7/14/2016)
SQLRNNR (7/13/2016)
ChrisM@Work (6/29/2016)
tindog (6/29/2016)
ChrisM@Work (6/29/2016)
tindog (6/29/2016)
ChrisM@Work (6/29/2016)
tindog (6/29/2016)
Now Wales are after independence from England to 'safeguard' their future...despite the fact that they also voted in favour...
^{“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

July 14, 2016 at 6:50 am

#1890077

Viewing 15 posts - 1,366 through 1,380 (of 10,143 total)