WayneS

Forum Replies Created

Viewing 15 posts - 541 through 555 (of 5,588 total)

RE: Are the posted questions getting worse?

TomThomson (2/18/2014)
Luis Cazares (2/18/2014)
Steve Jones - SSC Editor (2/18/2014)
Ed Wagner (2/17/2014)
EL Jerry (2/17/2014)
G'Day Everyone!!
Have you noticed the community has grown over 1.7M members?
Congratulations to Steve et al who...
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

February 20, 2014 at 8:57 am

#1690736
RE: Locking, Blocking and Deadlocking

prakashr.r7 - Your comment means that I met my objective - 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

February 17, 2014 at 8:32 am

#1689556
RE: Issue shredding Deadlock Graph XML

David Benoit (2/14/2014)
This is so COOL! I was starting to look at how to do this and thought "I'll just search it to see if anyone has done this..." 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

February 14, 2014 at 9:39 pm

#1689270
RE: Transaction Isolation Levels

jemerson 16199 (2/13/2014)
As you point out Read Committed Snapshot provides a transactionally consistent set of data at the time the Statement began. Therefore, if T1 reads a row;...
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

February 14, 2014 at 10:14 am

#1689138
RE: Transaction Isolation Levels

Thank you Anuj, Misha and Jason.
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

February 14, 2014 at 10:09 am

#1689137
RE: Are the posted questions getting worse?

SQLRNNR (2/10/2014)
Lynn Pettis (2/10/2014)
Ed Wagner (2/7/2014)
Lynn Pettis (2/7/2014)
jasona.work (2/7/2014)
Lynn Pettis (2/7/2014)
I have been home since Sunday afternoon and today is the first day it has been warmer than it 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

February 10, 2014 at 4:26 pm

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

davoscollective (2/2/2014)
Wow thanks for what was effectively part 2 in this spackle 🙂 You've written an article in its own right to answer my question...
I completely agree. That's one of...
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

February 5, 2014 at 11:28 pm

#1686451
RE: Updated Explanation on Parsename

Sounds like another fun one. I'll do this also.
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

February 5, 2014 at 10:41 am

#1686293
RE: T-SQL Comparing Rates

Steve, I'll take this one.
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

February 5, 2014 at 10:40 am

#1686290
RE: Get list of all workers having same SET of Rates

Another possibility might be to use the intersect operator
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

February 5, 2014 at 10:37 am

#1686285
RE: Are the posted questions getting worse?

Sean Lange (2/4/2014)
What a crazy day! Lots of snow falling around Kansas City. Pretty much the whole city is shut down today and quite probably tomorrow. The snow got started...
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

February 5, 2014 at 10:34 am

#1686282
RE: Are the posted questions getting worse?

L' Eomot Inversé (2/4/2014)
WayneS (2/3/2014)
Jeff Moden (2/3/2014)
Personally and just as a non-confontational point of view, I think GUIDs as a clustered index is a really bad thing to do especially...
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

February 4, 2014 at 3:31 pm

#1686027
RE: Are the posted questions getting worse?

SQLRNNR (2/3/2014)
rodjkidd (1/29/2014)
Talking of Grant, did anyone see the picture of him on the SQLCruise yesterday- almost as red as the livery of that company he works for!
Rodders...
Why yes, yes...
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

February 3, 2014 at 3:47 pm

#1685666
RE: Are the posted questions getting worse?

Jeff Moden (2/3/2014)
Personally and just as a non-confontational point of view, I think GUIDs as a clustered index is a really bad thing to do especially since the advent of...
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

February 3, 2014 at 3:43 pm

#1685665
RE: Are the posted questions getting worse?

Grant Fritchey (2/3/2014)
wolfkillj (2/3/2014)
EDIT: Any word on when Jonathan's book will hit the streets (or "drop", as the kids today seem to say)?
Not a clue. I've gone through three chapters....
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

February 3, 2014 at 3:37 pm

#1685664

Viewing 15 posts - 541 through 555 (of 5,588 total)