WayneS

Forum Replies Created

Viewing 15 posts - 736 through 750 (of 5,588 total)

RE: Days Difference Between 2 Dates

Good question Dwain... thanks for submitting it. (I wonder how many that got this correct ran the code first...)
One minor nit-picking comment. You initialize the dates like this:
DECLARE @Date1 DATETIME...
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

October 2, 2012 at 10:12 am

#1544479
RE: APPLY - 2

Good question Ron.
If anyone wants to learn more about using the Apply operator, check out the "Using APPLY" links in my signature block for some great articles written by Paul...
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

October 1, 2012 at 7:52 am

#1543983
RE: Are the posted questions getting worse?

Koen Verbeeck (9/28/2012)
Grant Fritchey (9/28/2012)
Koen Verbeeck (9/28/2012)
laurie-789651 (9/28/2012)
Koen Verbeeck (9/28/2012)
Grant Fritchey (9/27/2012)
THREADIZENS!
Who is going to make it to any of the SQL in the City events coming up in 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

September 28, 2012 at 7:16 am

#1543401
RE: A simple T-SQL statement to create a list of lookup values

You need to remember that string manipulation in windows is horribly slow. I wrote an article on creating delimited lists using the FOR XML in 2011 here[/url]. Using this method,...
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

September 28, 2012 at 7:10 am

#1543397
RE: Are the posted questions getting worse?

Just figured out a solution to a SSRS report that I've been messing with for way too long.
:satisfied: (as long as the customer likes 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

September 27, 2012 at 9:00 am

#1542957
RE: Are the posted questions getting worse?

Stefan Krzywicki (9/21/2012)
WayneS (9/21/2012)
Hmm... how would that handle identical twins, etc with identical DNA?
Identical twins don't have identical DNA.
There are several reasons for this
Interesting. I hadn't heard this before, 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

September 21, 2012 at 12:50 pm

#1540911
RE: Are the posted questions getting worse?

Hmm... how would that handle identical twins, etc with identical DNA?
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

September 21, 2012 at 10:41 am

#1540852
RE: How to receive Deadlock information automatically via email.

Don't forget that in SQL 2005 +, that the default trace (which starts automatically) captures deadlock graph information. So you can set up a job that fires when this event...
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

September 21, 2012 at 7:10 am

#1540669
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (9/17/2012)
WayneS (9/17/2012)
Steve Jones - SSC Editor (9/17/2012)
FYI, if you're attending the Summit, we have a networking dinner set up again: http://networkingdinnerpasssummit2012.eventbrite.com/
Signed up.
Is there going 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

September 17, 2012 at 9:21 am

#1538668
RE: Never update systems tables directly - a study in Agent job scheduling

Nakul,
Good Article. Thanks for pointing out other areas where updating system tables can cause issues.
Out of curiosity, is the sp_configure option for Allow Updates set to 1 on your system?...
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

September 17, 2012 at 7:47 am

#1538609
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (9/17/2012)
FYI, if you're attending the Summit, we have a networking dinner set up again: http://networkingdinnerpasssummit2012.eventbrite.com/
Signed up.
Is there going to be a SQLServerCentral / RedGate party?
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

September 17, 2012 at 7:39 am

#1538603
RE: Are the posted questions getting worse?

Evil Kraig F (9/15/2012)
I was working on a massive threadizen post and... lost it due to the vagueries of IE 10.
Short form: Is there a yearly threadizen gathering that I'm...
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

September 16, 2012 at 2:30 pm

#1538354
RE: Are the posted questions getting worse?

SQLRNNR (9/14/2012)
GilaMonster (9/14/2012)
SQL Kiwi (9/14/2012)
GilaMonster (9/14/2012)
SQL Kiwi (9/14/2012)
Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?
My first reaction was, "LOL!". Posted a more serious comment.
Thank you, you saved...
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

September 14, 2012 at 4:49 pm

#1538217
RE: Are the posted questions getting worse?

Brandie Tarvin (9/11/2012)
It's nice to know that every once in a blue moon, I actually do have a clue and can answer some SQL Server questions here without making 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

September 11, 2012 at 11:14 am

#1536402
RE: Are the posted questions getting worse?

Brandie Tarvin (9/10/2012)
Scott D. Jacobson (9/9/2012)
Just saw this on Hacker News and immediately thought of this long running thread: http://mattgemmell.com/2008/12/08/what-have-you-tried/%5B/url%5D
The Hacker News comments are interesting as well.
Yeah, the comment 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

September 10, 2012 at 9:07 am

#1535746

Viewing 15 posts - 736 through 750 (of 5,588 total)