WayneS

Forum Replies Created

Viewing 15 posts - 31 through 45 (of 5,588 total)

RE: Are the posted questions getting worse?

Ed Wagner - Monday, July 30, 2018 11:32 AM
Michael L John - Monday, July 30, 2018 11:28...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 31, 2018 at 8:18 am

#1999682
RE: Are the posted questions getting worse?

Jeff Moden - Sunday, July 15, 2018 7:40 AM
JaybeeSQL - Sunday, July 15, 2018 6:08 AM
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 16, 2018 at 11:27 am

#1997716
RE: Splitting Strings in SQL Server 2016

Thanks Andy
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 15, 2018 at 2:22 pm

#1994186
RE: Are the posted questions getting worse?

Going to a picnic and taking a day off in the midst of issues... Am I sensing a serious lack of job devotion here??? 😀
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 13, 2018 at 6:47 pm

#1993931
RE: Are the posted questions getting worse?

Anyone down in the Mobile, AL area? I'll be down there next week - it would be nice to meet up with you!
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 16, 2018 at 12:16 pm

#1990719
RE: Are the posted questions getting worse?

Ed Wagner - Tuesday, April 10, 2018 6:24 AM
Michael L John - Sunday, April 8, 2018 9:56...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 10, 2018 at 8:07 am

#1986137
RE: Table Valued Function causing performance issue

ermuditsirohi - Tuesday, April 10, 2018 5:07 AM
Eirikur Eiriksson - Tuesday, April 10, 2018 3:47 AM
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 10, 2018 at 8:04 am

#1986135
RE: Adaptive Query Processing – Batch Mode Memory Grant Feedback

jasinski.andrzej - Thursday, March 29, 2018 4:03 AM
From what I remember sql will do around 30 (32 to be exact?) rounds before...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

March 29, 2018 at 7:54 am

#1984949
RE: Are the posted questions getting worse?

Michael L John - Thursday, March 22, 2018 2:57 PM
I like them sautÃ©ed with mushrooms!
Burnt until they are ash and blow away?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

March 26, 2018 at 10:39 am

#1984560
RE: Count with Merge

Gators_79 - Friday, February 16, 2018 6:15 AM
Phil Parkin - Friday, February 16, 2018 6:10 AM
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

February 16, 2018 at 9:26 pm

#1980153
RE: Adaptive Query Processing – Batch Mode Memory Grant Feedback

Jon Patterson - Thursday, February 1, 2018 10:05 AM
Hi WayneS,
1. What kind of variances, and how many, before the SQL Server engine...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

February 1, 2018 at 11:15 am

#1978243
RE: Adaptive Query Processing – Batch Mode Memory Grant Feedback

t.franz - Thursday, February 1, 2018 1:04 AM
What happens, if you call the procedure again with an ID which has only one...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

February 1, 2018 at 7:54 am

#1978196
RE: Are the posted questions getting worse?

jasona.work - Wednesday, January 17, 2018 12:27 PM
I find it amusing that someone responded to a topic (that I'd replied to and...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 18, 2018 at 8:32 am

#1976338
RE: Are the posted questions getting worse?

jasona.work - Friday, January 5, 2018 5:31 AM
Brandie Tarvin - Friday, January 5, 2018 5:27 AM
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 5, 2018 at 10:27 am

#1974728
RE: Are the posted questions getting worse?

Grant Fritchey - Thursday, January 4, 2018 2:40 PM
Lynn Pettis - Thursday, January 4, 2018 2:16 PM
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

January 4, 2018 at 5:37 pm

#1974596

Viewing 15 posts - 31 through 45 (of 5,588 total)