ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,651 through 1,665 (of 10,143 total)

RE: Accurate Time between Two Dates in Year, Month,Day Format

dplaut 49149 (3/29/2016)
The comment prefacing the code is "This is a function..." Yes, we can see that it is a function.
Why should I use your function vs. some other method...
^{“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

March 29, 2016 at 6:24 am

#1868192
RE: Accurate Time between Two Dates in Year, Month,Day Format

dplaut 49149 (3/29/2016)
When you post something like this please preface it with some text about why I should use this. If I don't know why then why should I bother...
^{“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

March 29, 2016 at 5:58 am

#1868188
RE: Recurring deadlocks

Here's a simple model utilising an index to seek on Invalid, Status, UserID in that order. There's one predicate for each of the Status values, and no residual predicate -...
^{“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

March 29, 2016 at 3:54 am

#1868166
RE: Recurring deadlocks

sql-lover (3/24/2016)
ChrisM@Work (3/24/2016)
Can you post the actual (not estimated) execution plan as a .sqlplan attachment please? It will answer a lot of questions.
Rule #1 when dealing with a deadlocking query...
^{“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

March 29, 2016 at 3:16 am

#1868158
RE: Split without delimiter based on postion into multiple columns

Ed Wagner (3/24/2016)
ChrisM@Work (3/24/2016)
Alan.B (3/24/2016)
I was curious and looked at the thread.
ChrisM@home (10/22/2012)
yuvipoy (10/22/2012)
Ok, thanks. Can you give an example of how the data from this output table would...
^{“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

March 29, 2016 at 2:50 am

#1868155
RE: Are the posted questions getting worse?

Grant Fritchey (3/24/2016)
Steve Jones - SSC Editor (3/24/2016)
WayneS (3/24/2016)
ChrisM@Work (3/24/2016)
Stage fright can hit anyone I suppose.
Yes it does... even those that speak frequently. I know of a fellow threadizen...
^{“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

March 24, 2016 at 10:34 am

#1867510
RE: Recurring deadlocks

sql-lover (3/24/2016)
ChrisM@Work (3/24/2016)
sql-lover (3/24/2016)
ChrisM@Work (3/24/2016)
Can you post the actual (not estimated) execution plan as a .sqlplan attachment please? It will answer a lot of questions.
Rule #1 when dealing with 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

March 24, 2016 at 9:03 am

#1867478
RE: Split without delimiter based on postion into multiple columns

Alan.B (3/24/2016)
I was curious and looked at the thread.
ChrisM@home (10/22/2012)
yuvipoy (10/22/2012)
Ok, thanks. Can you give an example of how the data from this output table would be used please?
ChrisM...
^{“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

March 24, 2016 at 8:58 am

#1867475
RE: Recurring deadlocks

sql-lover (3/24/2016)
ChrisM@Work (3/24/2016)
Can you post the actual (not estimated) execution plan as a .sqlplan attachment please? It will answer a lot of questions.
Rule #1 when dealing with a deadlocking query...
^{“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

March 24, 2016 at 8:41 am

#1867459
RE: Are the posted questions getting worse?

Brandie Tarvin (3/24/2016)
ChrisM@Work (3/24/2016)
Sean Lange (3/24/2016)
--I posted in another thread by accident a couple of days ago--
Thank you Mr. Moden. Another interview cut short with the simple "Name one way...
^{“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

March 24, 2016 at 8:30 am

#1867450
RE: Split without delimiter based on postion into multiple columns

satyasainadh369 (3/24/2016)
I am having a query i need to split the query based on the position i specify
Say
string is 12345678910111213141516........
i am having position as 1,1,2,5,4,2
i need as
Rid,col1,col2,col3,col4,col5,col6
1 ,1,2,34,56789,1011,12
Thanks
Your requirement looks...
^{“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

March 24, 2016 at 8:22 am

#1867444
RE: Are the posted questions getting worse?

Sean Lange (3/24/2016)
--I posted in another thread by accident a couple of days ago--
Thank you Mr. Moden. Another interview cut short with the simple "Name one way to get 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

March 24, 2016 at 8:13 am

#1867438
RE: Recurring deadlocks

Can you post the actual (not estimated) execution plan as a .sqlplan attachment please? It will answer a lot of questions.
Rule #1 when dealing with a deadlocking query - reduce...
^{“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

March 24, 2016 at 7:52 am

#1867423
RE: Are the posted questions getting worse?

Beatrix Kiddo (3/24/2016)
ChrisM@Work (3/24/2016)
Google shows Slalom right next to Vinopolis, Borough Market and the Market Porter Bar. That's about 20 minutes walk from here (Picadilly). It's a fantastic little corner...
^{“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

March 24, 2016 at 4:31 am

#1867350
RE: Are the posted questions getting worse?

rodjkidd (3/24/2016)
ChrisM@Work (3/23/2016)
How many of you contractors have been so taken with a gig that you've signed up as a permie? I just did. I never expected that.
The idea 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

March 24, 2016 at 4:14 am

#1867343

Viewing 15 posts - 1,651 through 1,665 (of 10,143 total)