ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 10,143 total)

RE: Are the posted questions getting worse?

BLOB_EATER (9/30/2016)
Thanks to those that have given me advice! this is a great forum.
So you and Mrs Blobby are talking to each other again? 😀
^{“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 3, 2016 at 1:43 am

#1904331
RE: Are the posted questions getting worse?

BLOB_EATER (9/30/2016)
I'm super pumped at the moment 1 of my tutorials on Azure DWH will be moving over to the Microsoft website-wiki. :w00t:
Gosh, nice job Blobby!
^{“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 3, 2016 at 1:42 am

#1904330
RE: One to Many relations

moranamon (9/30/2016)
Hi Leo,
Thanks for your reply.
With your permission i would to explain again approach #1.
Three entities, let's name them all.
Employees, Houses, Cars. lets assume that each one of them should...
^{“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

September 30, 2016 at 8:16 am

#1904164
RE: Assign result of dynamic sql to variable

sanjaydut26 (9/30/2016)
I modified the query to
Declare @query nvarchar(max)
set @query = dbo.ufn_GetHcmDesignFields(3, 31418)
Declare @query2 nvarchar(max)
EXEC sp_executesql N'@query','@query2 nvarchar(max) output',@query2 output
select @query2 as Test
I get the same error
Can you post 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

September 30, 2016 at 8:01 am

#1904160
RE: Today's Random Word!

Kaye Cahs (9/30/2016)
djj (9/29/2016)
Grumpy DBA (9/29/2016)
HappyGeek (9/29/2016)
Coat
Paint
Brush
Hair
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

September 30, 2016 at 7:34 am

#1904154
RE: Method to compare on resultset to part of another

Some pointers in the right direction - and kudos for asking for them instead of a solution. The type of problem you are investigating is called "Relational Division".
The late...
^{“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

September 30, 2016 at 4:57 am

#1904115
RE: Deadlock error MERGE

javirsantos (9/30/2016)
I set up a test environment with S2 CU1 patch level and gives the same error, deadlock.
There's a strong relationship between transaction duration and deadlock occurrence. Speeding up your...
^{“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

September 30, 2016 at 3:49 am

#1904107
RE: Intentional Normalization Violation

BSavoie (9/29/2016)
...
Many of our queries could care less about the many statuses for a given Order, all they care about is the current status. For these queries, having to 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

September 30, 2016 at 3:37 am

#1904103
RE: Are the posted questions getting worse?

Eirikur Eiriksson (9/18/2016)
Now where is that crystal ball again?
😎
You're going to need a pair of those. The OP (or should that be "perp"?) has been posting for over three years...
^{“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

September 19, 2016 at 1:52 am

#1901567
RE: finding max value between dates

astrid 69000 (9/18/2016)
this is the result i need
i have attached an excel cause i dont know how to make a sample of a table to show it.
That's similar 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

September 19, 2016 at 1:49 am

#1901566
RE: Warning: The join order has been enforced because a local join hint is used. ( two views )

Kevin.J.Small (9/16/2016)
I was encountering this error also and did a search and found this thread. I think there is also an issue in SQL Server in reporting this error...
^{“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

September 16, 2016 at 8:03 am

#1901357
RE: Index guidance needed

MickyD (9/16/2016)
Thanks all some great topics for me to continue comms with the Devs there.
I will extract execution plan on the simple select I have been sent.
thanks again
Please could you...
^{“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

September 16, 2016 at 4:47 am

#1901304
RE: delete millions of rows

Jeff Moden (9/13/2016)
ChrisM@Work (9/13/2016)
Eric M Russell (9/12/2016)
4 million rows is actually not a lot, but it depends on the speed of your storage system and whether the table will need...
^{“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

September 16, 2016 at 1:34 am

#1901286
RE: Split string using multiple delimiters - version 2

Iwas Bornready (9/15/2016)
ChrisM@Work (9/15/2016)
Interesting. It does a lot of work for the result. Have you speed-tested it against the house splitter?
Here's one I knocked up in a couple of...
^{“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

September 15, 2016 at 8:40 am

#1901126
RE: Split string using multiple delimiters - version 2

Interesting. It does a lot of work for the result. Have you speed-tested it against the house splitter?
Here's one I knocked up in a couple of minutes to show...
^{“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

September 15, 2016 at 3:01 am

#1901047

Viewing 15 posts - 1,171 through 1,185 (of 10,143 total)