WayneS

Forum Replies Created

Viewing 15 posts - 556 through 570 (of 5,588 total)

RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Jeff Moden (1/30/2014)
Jerry Kelk (1/30/2014)
Fair comment Jeff. Point taken.
Fortunately, I don't have huge data or paying customers, so on a horses-for-courses basis, the method suits me well enough.
Food for...
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 30, 2014 at 1:19 pm

#1684833
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (1/15/2014)
WayneS (1/15/2014)
Steve Jones - SSC Editor (1/13/2014)
I'm hoping to get back to SQLBits this year, but with surgery coming, timing will matter. I hope they...
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 15, 2014 at 1:06 pm

#1680423
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (1/13/2014)
I'm hoping to get back to SQLBits this year, but with surgery coming, timing will matter. I hope they announce something soon.
Steve, did I miss...
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 15, 2014 at 7:48 am

#1680275
RE: Are the posted questions getting worse?

Greg Edwards-268690 (1/10/2014)
Ed Wagner (1/10/2014)
I like to think I've gotten better at both of these items with age. Knowing everything and talking over other people is something that many...
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 10, 2014 at 10:12 am

#1679245
RE: The new Analytic functions in SQL Server 2012

Hi Dwain,
Thanks for your kind remark. And thanks again for responding to these questions.
dwain.c (1/1/2014)
j-1064772 (1/19/2012)
How do the newfangled Analytics functions compare with the Quirky Update method used for -...
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 2, 2014 at 3:09 am

#1676818
RE: New Year's Eve

Since the QotD is all about learning, allow me to point out a few things:
First of all, none of these solutions really work...
Msg 137, Level 15, State 2, Line 6
Must...
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

December 31, 2013 at 12:33 pm

#1676666
RE: The new Analytic functions in SQL Server 2012

Thanks Thomas and Alan!
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

December 27, 2013 at 3:24 pm

#1676184
RE: Are the posted questions getting worse?

Revenant (12/24/2013)
Steve, I have a QA request: please add a 'Do not count towards messages posted' check box for a reply.
Or perhaps, don't count messages posted in "The Thread"??? Not...
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

December 26, 2013 at 9:19 am

#1675964
RE: Are the posted questions getting worse?

I'm curious as to the different ways that you fine folks have seen / dealt with being on-call, and what you perceive the pros/cons of these are?
For instance:
on-call for...
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

December 20, 2013 at 9:00 am

#1675193
RE: Are the posted questions getting worse?

Jack Corbett (12/17/2013)
So is that an automatic standby generator or a portable you need to hook up. I have portable that I have to hook up. ...
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

December 18, 2013 at 10:51 pm

#1674703
RE: Are the posted questions getting worse?

Ed Wagner (12/16/2013)
WayneS (12/16/2013)
Hehe.
When I built our house, I designed it to use radiant-floor heat. Hot water is heated by an outdoor wood furnace. Gas (propane) range. Only electrical needs...
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

December 18, 2013 at 10:48 pm

#1674702
RE: Are the posted questions getting worse?

Jack Corbett (12/16/2013)
WayneS (12/13/2013)
Greg Edwards-268690 (12/13/2013)
jasona.work (12/13/2013)
Ed Wagner (12/13/2013)
jasona.work (12/13/2013)
OK, where did the year go?
I mean seriously, 12 days until X-Mas? It feels like it was only...
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

December 16, 2013 at 9:27 am

#1673760
RE: Are the posted questions getting worse?

Greg Edwards-268690 (12/13/2013)
jasona.work (12/13/2013)
Ed Wagner (12/13/2013)
jasona.work (12/13/2013)
OK, where did the year go?
I mean seriously, 12 days until X-Mas? It feels like it was only a couple weeks ago I...
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

December 13, 2013 at 7:18 am

#1673246
RE: Are the posted questions getting worse?

Dupe, removed
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

December 9, 2013 at 6:46 pm

#1672188
RE: Windowing Ranges

KWymore (12/9/2013)
Nice question Steve! I wish we would upgrade to 2012 around here so we could use these new functions.
Good stuff.
Ken
The upgrades to the OVER clause alone are, IMHO, worth...
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

December 9, 2013 at 12:43 pm

#1672104

Viewing 15 posts - 556 through 570 (of 5,588 total)