WayneS

Forum Replies Created

Viewing 15 posts - 1,276 through 1,290 (of 5,588 total)

RE: Are the posted questions getting worse?

Grant Fritchey (5/28/2011)
WayneS (5/28/2011)
Jim Murphy (5/27/2011)
<giggle>. This is probably Grant's biggest fear for the precon. Especially since Jen says that "book authors don't know anything" at SQLRally. For clarification, (inside...
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 28, 2011 at 10:49 am

#1331364
RE: Are the posted questions getting worse?

Jim Murphy (5/27/2011)
<giggle>. This is probably Grant's biggest fear for the precon. Especially since Jen says that "book authors don't know anything" at SQLRally. For clarification, (inside joke) Jen misspoke...
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 28, 2011 at 9:41 am

#1331353
RE: Gaps and Islands with multiple simultaneous insurance coverage?

peterzeke (5/27/2011)
WayneS (5/27/2011)
Pete,
2 questions:
1. Based upon the new row being added to the sample data, what are your expected results?
2. Does Drew's approach solve your issue?
Starting with #2 -- 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

May 27, 2011 at 2:49 pm

#1331231
RE: Are the posted questions getting worse?

GilaMonster (5/27/2011)
Precon and spotlight! Could this PASS Summit get any better?
So, you're aiming for a keynote address now?
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 27, 2011 at 2:44 pm

#1331225
RE: Are the posted questions getting worse?

Congratulations Gail and Grant for getting spotlight sessions at the PASS Summit this year!
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 27, 2011 at 1:37 pm

#1331212
RE: Gaps and Islands with multiple simultaneous insurance coverage?

peterzeke (5/27/2011)
peterzeke (5/27/2011)
Mark-101232 (5/27/2011)
Unless I'm misunderstanding this, I'm don't think this is a groups and islands problem, more
a case of just joining to the insurance for the latest month
WITH 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

May 27, 2011 at 1:11 pm

#1331205
RE: Whats the benefits to clustering

bopeavy (5/27/2011)
WayneS
Thanks, I was trying to set up where I have 3 sql servers on standard edition so that I have a failover and can log shipfrom node 2 with...
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 27, 2011 at 12:28 pm

#1331182
RE: Whats the benefits to clustering

bopeavy (5/27/2011)
WayneS
So if active/active does not have the same resource how is the sql server able to failover with ur copy of production db?
When an instance of SQL Server is...
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 27, 2011 at 11:57 am

#1331161
RE: I would like to get the distinct value from specified column. I would appreciate if any one provide the answer of this

Sean Lange (5/27/2011)
ohhh this is starting to sound like a show down. This is going to be a good one to watch!!! Ruban sit back and watch the masters go...
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 27, 2011 at 11:39 am

#1331154
RE: Whats the benefits to clustering

First, just as an FYI, Microsoft (at least the SQL Server High Availability team) is trying to get away from the "active/active" / "active/passive" nomenclature - they're trying to call...
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 27, 2011 at 10:48 am

#1331122
RE: I would like to get the distinct value from specified column. I would appreciate if any one provide the answer of this

Jeff Moden (5/27/2011)
Rani-434268 (5/26/2011)
I have table A_ having near 55 million rows. Name column having some duplicates, i would like to remove it.
Ex.
1. Dr Vasudev Narasima MD Vasudev Narasima MBBS
output
Dr...
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 27, 2011 at 10:20 am

#1331111
RE: Are the posted questions getting worse?

GSquared (5/27/2011)
jcrawf02 (5/27/2011)
GSquared (5/27/2011)
Gianluca Sartori (5/26/2011)
jcrawf02 (5/26/2011)
Gianluca Sartori (5/26/2011)
jcrawf02 (5/26/2011)
Wow, you thought that there were too many other DBAs that were better suited than Brandie? That's not very nice...
😛
Funny, but...
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 27, 2011 at 9:59 am

#1331099
RE: Yeah!

It's all those "yeah, that works" posts!
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 26, 2011 at 6:21 am

#1330233
RE: Can someone please explain this very simple problem to me

Ninja's_RGR'us (5/26/2011)
jshurak (5/26/2011)
No no no. It was simpler than that. Insert statements are for rows that don't already exist in the database......update statements are for rows 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 26, 2011 at 6:20 am

#1330231
RE: Are the posted questions getting worse?

GilaMonster (5/25/2011)
Grant and I are talking Execution plans for a whole day at PASS Summit this year.
You are all coming? Right?
If I can swing going to the summit, I'll...
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 25, 2011 at 3:45 pm

#1330005

Viewing 15 posts - 1,276 through 1,290 (of 5,588 total)