webrunner

Forum Replies Created

Viewing 15 posts - 166 through 180 (of 1,189 total)

Reply To: ISNULL vs COALESCE

Thanks for this question. I got it wrong but learned something important about COALESCE.

-- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

May 16, 2019 at 4:22 pm

#3644278
Reply To: Really Important Software
Thanks for this op-ed and for the links. I have zero engineering training, but when I heard the news of a second 737 Max crash that sounded so similar to...
- This reply was modified 7 years, 1 months ago by webrunner. Reason: Add book link
- This reply was modified 7 years, 1 months ago by webrunner.
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
May 6, 2019 at 6:58 pm

#3636602
Reply To: Renaming a login

Thanks for this instructive question.
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

April 16, 2019 at 2:28 pm

#3410298
Reply To: You're not really that good at SQL Server

Cuppadan wrote:
m_swetz, That I believe is the best post I read on this topic in a long time. Thank you for that.
Same here.
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

April 12, 2019 at 6:44 pm

#3166674
Reply To: You're not really that good at SQL Server
Your editorial is sad, but true. I guess somebody had to say it. I don't think this issue is unique to SQL Server, but the older I get, the more...
- This reply was modified 7 years, 2 months ago by webrunner.
- This reply was modified 7 years, 2 months ago by webrunner.
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 8, 2019 at 3:24 pm

#3019970
RE: T-SQL correlated queries

Thanks for this instructive question!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

March 14, 2019 at 8:06 am

#2024449
RE: The Extra Table

Thanks for this informative question.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

March 5, 2019 at 9:20 am

#2023579
RE: Stored Procedure Parameters

ZZartin - Monday, February 18, 2019 8:25 AM
The real question is at what point do you have to consider you're seriously doing...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

February 18, 2019 at 9:12 am

#2022286
RE: SQL Server Trace Flags - Complete list

Thanks for this impressively comprehensive list!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

February 15, 2019 at 3:36 pm

#2022195
RE: IDENTITY_INSERT

Thanks for this instructive question.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

February 12, 2019 at 8:43 am

#2021786
RE: REPLACE and NULLs

Yes, thanks. Seems like that is what ISNULL() is for, as I mentioned. And explains why REPLACE() was made to return NULL if any parameter is NULL.
Thanks again.
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

January 4, 2019 at 12:25 pm

#2018035
RE: REPLACE and NULLs

Sean Lange - Friday, January 4, 2019 10:39 AM
webrunner - Friday, January 4, 2019 8:18 AM
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

January 4, 2019 at 10:49 am

#2018022
RE: REPLACE and NULLs

Thanks for the instructive question. But why is it that the REPLACE() function returns NULL even if the search parameter is NULL? Why was that decision made? Just curious.
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

January 4, 2019 at 8:18 am

#2017985
RE: Why do NULLs appear in DMV queries?

Thanks for the info! It gives me a sense of when and why these values would be blank.
Regarding this question from insharh2297 "Which brings up the issue: How...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

December 20, 2018 at 9:22 am

#2016970
RE: Stumped trying to shred XML data into table rows

Jeff Moden - Sunday, December 16, 2018 8:46 AM
A fellow by the name of
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

December 17, 2018 at 8:44 am

#2016523

Viewing 15 posts - 166 through 180 (of 1,189 total)