WayneS

Forum Replies Created

Viewing 15 posts - 121 through 135 (of 5,588 total)

RE: Are the posted questions getting worse?

David Burrows (5/6/2016)
Grumpy DBA (5/4/2016)
^ I agree with Brandie. Matter of fact that's how I came to my current employer, a former colleague has been here for 8 years...
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 6, 2016 at 8:42 am

#1877163
RE: Are the posted questions getting worse?

Anyone else having trouble receiving the SSC newsletters? I just received Saturday's "Database Weekly", and I haven't received any of the daily ones this week.
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 4, 2016 at 9:30 am

#1876648
RE: Are the posted questions getting worse?

xsevensinzx (5/3/2016)
Hey guys,
Need some advice. I got a really good job offer recently to work at a company as a DBA. I'm currently a data architect that built and manages...
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 4, 2016 at 9:27 am

#1876647
RE: View Deadlock Graphs

To all: the latest version of this script is up on my blog.
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 2, 2016 at 5:37 pm

#1876133
RE: Are the posted questions getting worse?

Anyone have experience loading ASCII flat files into tables where the files may contain some extended ASCII characters? Any special tricks involved to accomplish this load?
Thanks,
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 2, 2016 at 7:09 am

#1875877
RE: Are the posted questions getting worse?

Personally, I think this would be the most useful for the OP:
/* Version number binary from daily registy */
DECLARE @VERSION_STRING VARBINARY(MAX) = 0x666377247978767F6E2A6C803C3D7B8376808281817B42687E8D4A658F8A8D88419B8F8D8D8D474863A19C9190A2925F94A5A7A698656E9E59A69CA1695EABAEB5B7A8ACB5BDBABABBBC79ADB67DC2B1BA888674CACFCEC4C9C0CAC37DC7C3D4D5D991DACAC7D3DADDACD0CFE19FA4E9E092;
/* Inline Tally for parsing the binary string...
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 20, 2016 at 8:32 am

#1873356
RE: Are the posted questions getting worse?

Ed Wagner (4/19/2016)
SQLRNNR (4/19/2016)
GilaMonster (4/19/2016)
And more homework in the forums. Is it wrong to want to post a sensible-looking but completely incorrect query as answers?
Do it!
Are you thinking something along...
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 20, 2016 at 8:19 am

#1873346
RE: Splitting Strings in SQL Server 2016

Ed Wagner (4/19/2016)
Great article, Wayne. Thanks for putting it together. I especially liked your comparison of the different approaches and what each one does and does not do....
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 19, 2016 at 7:22 am

#1873059
RE: Splitting Strings in SQL Server 2016

Jeff Moden (4/13/2016)
Sk1ppy (4/12/2016)
Thanks; great post! I did have a question about the "failures" using CROSS APPLY vs OUTER APPLY though. Isn't that the expected behavior of using these functions?...
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 13, 2016 at 1:21 pm

#1871851
RE: TEMPDB Enhancements in SQL Server 2016

Trace Flag 1117 – The below screen shot shows that the is_autogrow_all_files value is 1 for only tempdb. This indicates that it is the only system database that supports Autogrow_All_Files...
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 13, 2016 at 8:22 am

#1871717
RE: Splitting Strings in SQL Server 2016

ducon (4/12/2016)
True, while the string test here is interesting, it's real JSON data that will make it (or not) relevant. I'm thinking integration services, message broker etc. that could make...
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 12, 2016 at 9:37 am

#1871445
RE: Splitting Strings in SQL Server 2016

RobertMcClean (4/12/2016)
"it needs to be escaped using the forward-slash character "\"."
Sorry to be picky, but you mean the back-slash character. :hehe:
The real use of OPENJSON will be for structured JSON...
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 12, 2016 at 9:33 am

#1871444
RE: Are the posted questions getting worse?

BL0B_EATER (3/31/2016)
Brandie Tarvin (3/31/2016)
GilaMonster (3/31/2016)
If it was my corruption session, then:
All severity 20 and above.
Error 825 (which is a severity 10 informational message that tells you that your IO subsystem...
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 31, 2016 at 9:23 am

#1868907
RE: Are the posted questions getting worse?

Sean Lange (3/24/2016)
Alan.B (3/24/2016)
Brandie Tarvin (3/24/2016)
<headdesk>
One of my coworkers just came up with the worst joke ever.
Three DBAs walk into a NoSQL bar. Soon after, they leave - they couldn't...
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 24, 2016 at 3:17 pm

#1867650
RE: Are the posted questions getting worse?

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 that is a very frequent speaker, yet has...
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 24, 2016 at 7:08 am

#1867403

Viewing 15 posts - 121 through 135 (of 5,588 total)