WayneS

Forum Replies Created

Viewing 15 posts - 571 through 585 (of 5,588 total)

RE: Are the posted questions getting worse?

Fal (12/9/2013)
GilaMonster (12/6/2013)
Thanks everyone
L' Eomot Inversé (12/6/2013)
I guess the next thing is for your number of posts to surpass the number of posts in the thread. 😎
I did have more...
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 11:31 am

#1672083
RE: SQLServerCentral apologizes and you can win a book

There has been quite a bit of very useful scripts being posted. I'd like to share one that utilizes a neat technique that I learned about right here on SSC.
First...
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, 2013 at 10:51 am

#1671245
RE: SQLServerCentral apologizes and you can win a book

SQLTuna (12/5/2013)
I'm glad you named and shamed the culprit!
At the prompting of sqlrnnr, we would like to also maim this person.
Seriously, I've very pleased to see this public apology....
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, 2013 at 9:55 am

#1671214
RE: High-Performance Transact-SQL with Window Functions

People reading this thread: Beware! As GordonLiddy noted a few posts earlier, the text of this article is a direct copy/paste from Itzik Ben-Gan's fantastic book "Microsoft SQL Server 2012...
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 4, 2013 at 7:54 am

#1670728
RE: Are the posted questions getting worse?

Paul White (12/3/2013)
dwain.c (12/3/2013)
Steve,
I thought you might want to see this:
http://www.sqlservercentral.com/Forums/FindPost1519227.aspx
By alerting you, I am not vouching for its veracity.
I have a copy of Itzik's book, and I can vouch...
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 4, 2013 at 7:46 am

#1670725
RE: Are the posted questions getting worse?

Jeff Moden (12/1/2013)
dwain.c (12/1/2013)
cow is referred to as wua[/b] - don't ask me why)[/i][/b]
FINALLY!!! AFTER NEARLY 40 YEARS, AN EXPLANATION!!!! When I was in the service, I had a...
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 2, 2013 at 11:07 am

#1670175
RE: Are the posted questions getting worse?

Grant Fritchey (11/22/2013)
I got to meet another Threadizen last night. Revenant is doing some seriously wild stuff with the technology we all use. If you get the chance to talk...
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 22, 2013 at 8:40 am

#1668441
RE: Locking, Blocking and Deadlocking

Thanks Dwain.
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 19, 2013 at 3:59 pm

#1667620
RE: Locking, Blocking and Deadlocking

desperadomar (11/18/2013)
Thanks for the info ,I will give it a try to sp_whoisactive, but when you use sp_who2 I can only see some spid's in the
blocked by
column...
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 19, 2013 at 3:57 pm

#1667619
RE: Locking, Blocking and Deadlocking

desperadomar (11/18/2013)
So how will I find the root blocker, whether is it a chained blocking etc...
Thank you
I like to use sp_who2 and/or Adam Machanic's WhoIsActive to determine the root blocker.
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, 2013 at 9:52 am

#1667191
RE: Locking, Blocking and Deadlocking

gand 29575 (11/18/2013)
Thanks Wayne. Good introductory article.
Thanks gand. I enjoyed putting it all together, and I hope many will get some use out of it.
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, 2013 at 9:47 am

#1667190
RE: Are the posted questions getting worse?

Speaking of Tally / Numbers tables - does anyone have a tally-table based query that you wish would run even faster? I'm going to be doing a test of 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

November 17, 2013 at 6:54 pm

#1666997
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (11/14/2013)
Greg Edwards-268690 (11/14/2013)
Show me the person who is a master of all things SQL Server.
They are as rare as seeing a unicorn!
No such thing, 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

November 16, 2013 at 3:23 pm

#1666906
RE: Are the posted questions getting worse?

Lynn Pettis (11/13/2013)
Lynn Pettis (11/13/2013)
It is 23:27 Afghan time. Three minutes until my phone interview. Wish me luck!
Just finished the interview, and I feel like a Junior DBA....
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 16, 2013 at 3:19 pm

#1666905
RE: Are the posted questions getting worse?

Stefan Krzywicki (11/13/2013)
You can't know everything. There is a hell of a lot to know in SQL Server and if the interviewers didn't set up expectations for the interview properly...
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 16, 2013 at 3:10 pm

#1666903

Viewing 15 posts - 571 through 585 (of 5,588 total)