WayneS

Forum Replies Created

Viewing 15 posts - 511 through 525 (of 5,588 total)

RE: Are the posted questions getting worse?

TomThomson (5/20/2014)
Steve Jones - SSC Editor (5/20/2014)
Who's getting a Surface 3? Or wants one?
Up in the air on this whole thing, but I'll admit it's tempting, depending on price.
http://www.microsoft.com/en-us/news/press/2014/may14/05-20surfacepr.aspx
Why...
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 21, 2014 at 6:29 am

#1715309
RE: Are the posted questions getting worse?

Sean Lange (5/8/2014)
Luis Cazares (5/8/2014)
jcrawf02 (5/8/2014)
WayneS (5/8/2014)
Ed Wagner (5/8/2014)
No real surprise there. I checked out the site quite some time ago and remarked to myself how miserable the questions...
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 9, 2014 at 1:35 pm

#1712320
RE: Are the posted questions getting worse?

Ed Wagner (5/8/2014)
No real surprise there. I checked out the site quite some time ago and remarked to myself how miserable the questions were. I also saw that...
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 8, 2014 at 10:03 am

#1711946
RE: Cumulative sum of previous rows

Stefan Krzywicki (5/8/2014)
Good article.
I'm not sure what you meant by this though
I found something new in SQL Server 2012. You can now add an order by to the over( partition...
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 8, 2014 at 10:01 am

#1711943
RE: Cumulative sum of previous rows

rwatkins 25267 (5/8/2014)
I agree with SimonC, the RANGE clause is the better solution to the Running Total problem for read operations.
I disagree. For running aggregations (including totals), you need to...
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 8, 2014 at 9:52 am

#1711941
RE: Are the posted questions getting worse?

hisakimatama (5/7/2014)
SQLRNNR (5/6/2014)
hisakimatama (5/6/2014)
SQLRNNR (5/6/2014)
hisakimatama (5/1/2014)
Whew, busy times at work lately. I've been out of The Thread for a good bit :-).
Anyone else from The Thread planning to attend...
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 7, 2014 at 10:23 am

#1711605
RE: Open Source the MCM

Keith Tate (4/23/2014)
Taking the questions/scenarios out of the context of the lab environment (strange environment, limited time, no internet just BOL) would detract from the experience that most of us...
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 23, 2014 at 3:39 pm

#1708264
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (4/19/2014)
Greg Edwards-268690 (4/19/2014)
Steve -
Although attention to details is part of or job, I wonder if something could be done at some time to at least...
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, 2014 at 9:17 am

#1707328
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (4/16/2014)
OK, now I'll be keeping a better eye on y'all. For the first time in like 3 years I have no trips scheduled and no...
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 16, 2014 at 2:02 pm

#1706579
RE: Are the posted questions getting worse?

dwain.c (4/3/2014)
Steve Jones - SSC Editor (4/3/2014)
dwain.c (4/3/2014)
Many thanks to Steve for syndicating my blogs on SSC:
DwainCSQL[/url]
And my apologies for making you work so hard at it.
You are welcome 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

April 3, 2014 at 8:34 pm

#1703169
RE: Reaping the benefits of the Window functions in T-SQL

Eirikur,
This is an excellent modification to an already excellent function. Very well done!!! (And it was such a simple change at that.)
Jeff Moden (3/24/2014)
Eirikur asked me to review it (seems...
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 3, 2014 at 4:19 pm

#1703130
RE: Are the posted questions getting worse?

Sean Lange (4/3/2014)
Greg Edwards-268690 (4/3/2014)
it was clear they had no idea what they wanted or needed.
But finish it by Friday.
This is an everyday occurrence at my job.
You have until Friday?...
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 3, 2014 at 3:26 pm

#1703112
RE: Are the posted questions getting worse?

Ed Wagner (3/28/2014)
WayneS (3/27/2014)
Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces of sh code...
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 28, 2014 at 12:15 pm

#1701272
RE: Are the posted questions getting worse?

Luis Cazares (3/27/2014)
How is it possible that someone writes a cursor instead of using SUM()?
I'm afraid that this database is full of these pieces of sh code and it's slower...
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 27, 2014 at 8:48 pm

#1700962
RE: rewrite cursor to set based

Well, hello there.
Luis - thanks for linking to my article. However, I'm afraid that it doesn't do much for helping to learn how to remove cursors. For that task, my...
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 27, 2014 at 8:43 pm

#1700961

Viewing 15 posts - 511 through 525 (of 5,588 total)