WayneS

Forum Replies Created

Viewing 15 posts - 946 through 960 (of 5,588 total)

RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (1/6/2012)
Since inception, here are the posts
Year Mo Posts
20121249
201112806
201111906
201110862
20119974
20118909
20117837
20116894
20115763
20114812
20113888
20112740
20111798
201012824
201011972
2010101457
201091613
201081057
20107833
20106492
20105582
201041325
201031575
201021139
20101568
200912810
200911625
200910674
20099508
20098690
20097772
200961167
200951284
20094740
200931018
20092993
20091603
200812364
200811161
How about who were the top 5/10/x (your choice) posters...
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 6, 2012 at 9:21 am

#1429709
RE: Are the posted questions getting worse?

Lynn Pettis (1/6/2012)
Case insensitive vs case sensitive, one of the reasons I write all my queries and t-sql code as if everything was case sensitive. Don't have to worry...
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 6, 2012 at 9:17 am

#1429704
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (12/30/2011)
SQLRNNR (12/28/2011)
How much did that barn cost? I need one that is about 60'x100'
$100k. 72x140, Big Top Structures.
Hmm. I think I need to figure...
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 30, 2011 at 2:05 pm

#1427126
RE: Are the posted questions getting worse?

SQLRNNR (12/27/2011)
I am putting the finishing touches on an article. Anybody interested in reviewing/critiquing it?
Feel free to toss it my way if you so desire...
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 28, 2011 at 11:08 am

#1426192
RE: Are the posted questions getting worse?

GilaMonster (12/21/2011)
Not a DBA, but...
You may not be one, but you're better than most of them. (BTW - thanks for 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

December 21, 2011 at 8:49 am

#1424296
RE: Are the posted questions getting worse?

Greg Edwards-268690 (12/20/2011)
WayneS (12/19/2011)
bitbucket-25253 (12/19/2011)
Another quirk - those old machines when shut down were restarted by reading a series of commands from a roll of punched paper tape. ...
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, 2011 at 1:53 pm

#1423917
RE: Are the posted questions getting worse?

bitbucket-25253 (12/19/2011)
Another quirk - those old machines when shut down were restarted by reading a series of commands from a roll of punched paper tape. Doubt if 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

December 19, 2011 at 4:00 pm

#1423339
RE: Are the posted questions getting worse?

jcrawf02 (12/15/2011)
Dev (12/15/2011)
Brandie Tarvin (12/15/2011)
Dev (12/15/2011)
Symptom of cross post:
SSC refreshes the page while posting.
Workaround:
Browser's back button & hit Post. 😉
Not quite. If you don't refresh the...
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 15, 2011 at 10:33 am

#1422104
RE: Are the posted questions getting worse?

jcrawf02 (12/12/2011)
WayneS (12/9/2011)
Hmmm. I think I just found a bug in SQL 2012 - one of the new Analytic functions returns a different value when called from within a cte....
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 12, 2011 at 9:05 am

#1420136
RE: Are the posted questions getting worse?

SQL Kiwi (12/10/2011)
Turns out the parser is sending 'range between unbounded and current' for both FIRST_VALUE and LAST_VALUE with the CTE. This doesn't cause a problem for FIRST_VALUE (naturally!)...
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 10, 2011 at 8:02 am

#1419711
RE: Are the posted questions getting worse?

Hmmm. I think I just found a bug in SQL 2012 - one of the new Analytic functions returns a different value when called from within a cte. Anyone willing...
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, 2011 at 10:01 pm

#1419677
RE: Complex joins

L' Eomot Inversé (12/6/2011)
It's another one where I'm surprised by the failure rate - 78% wrong answers is amazing. Does that mean that 78% of people here never write...
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 7, 2011 at 3:30 pm

#1418400
RE: Are the posted questions getting worse?

jcrawf02 (12/7/2011)
Steve Jones - SSC Editor (12/7/2011)
Koen Verbeeck (12/7/2011)
Dev (12/7/2011)
The only valid countries are USA (except a few states), Canada (except Quebec), UK (except North Ireland) and Australia....
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 7, 2011 at 1:39 pm

#1418361
RE: Slow Running Stored Proceudre

1. Add an index to the #temp table for the columns that you are grouping by.
I see a lot of MONTH(CONVERT(SMALLDATEDIME, CONVERT(CHAR(8), TradeDateKey))) calls. It looks like TradeDateKey is an...
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 5, 2011 at 11:36 am

#1416935
RE: Are the posted questions getting worse?

Congrats Grant for making the Top 10 Community Choice Bloggers list! Keep up the good work!
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

November 18, 2011 at 2:08 pm

#1410198

Viewing 15 posts - 946 through 960 (of 5,588 total)