WayneS

Forum Replies Created

Viewing 15 posts - 4,351 through 4,365 (of 5,588 total)

RE: Using IDENTITY as a key column

Toreador (4/20/2010)
"SQL Server does not have an efficient way to retrieve rows based on a known value for PersonID."
There have obviously been too many trick questions lately, as I thought...
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

April 20, 2010 at 5:44 am

#1154470
RE: comparing two tables and exporting the differences in sql server

jeremy williams-435563 (4/19/2010)
Hi all !, i am trying to compare four columns in two tables(both are in the same schema), table a has two columns for firstname and last name...
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

April 19, 2010 at 11:53 pm

#1154324
RE: MCJ - The Missing Link

Jeff Moden (4/19/2010)
Good. Because of my inherent distrust in all the other certifications, I'd like to see this one materialize provided that less fortunate folks can actually afford 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

April 19, 2010 at 11:41 pm

#1154316
RE: Are the posted questions getting worse?

CirquedeSQLeil (4/19/2010)
I am putting the finishing touches on draft 1 of a new article. Anybody out there willing to give it a review?
Fire it my way. PM me if...
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

April 19, 2010 at 6:19 pm

#1154215
RE: Convert Function

Jeff Moden (4/17/2010)
mister.magoo (4/17/2010)
(I was just about to post my reply when yours popped up Jeff - and it covers everything I was going to say...)
Heh... I finally beat someone...
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

April 19, 2010 at 12:17 pm

#1154071
RE: How to order rows as specified

cjohn5552 (4/19/2010)
Hey all,
So, I have a list of people whose names I want to query the database for. I get the IDs from an Excel spreadsheet, paste it into Notepad++,...
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

April 19, 2010 at 11:37 am

#1154036
RE: Understanding and Using APPLY (Part 2)

Paul - another excellent article on using APPLY. Thank you so much for doing this... now I need to find the time to disect these two articles, and get 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

April 19, 2010 at 8:31 am

#1153872
RE: Are the posted questions getting worse?

Steve Jones - Editor (4/17/2010)
Wayne,
Hadn't seen that before, but it's great. I bookmarked it to use it for some question.
You're talking about the blood-n-gore 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

April 17, 2010 at 10:31 am

#1153359
RE: Comparing Table Variables with Temporary Tables

Michael H Lutz (4/17/2010)
Great article. There is one thing I see though that is incorrect, the statement " This means that the execution plan for table variables will always...
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

April 17, 2010 at 8:39 am

#1153337
RE: Are the posted questions getting worse?

Grant Fritchey (4/17/2010)
WayneS (4/17/2010)
Steve Jones - Editor (4/16/2010)
I almost shudder to post this, but you all might like this:
http://lmgtfy.com/
as a sample, let me Google clustered index for you: http://lmgtfy.com/?q=clustered+index
Steve, surely...
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

April 17, 2010 at 8:04 am

#1153329
RE: How to tune/speed up a procedure

lmu92 (4/17/2010)
@Wayne: we're getting closer to the 00:45 you've been talking about 😀
We probably will even be able to beat it!
That's what I'm talking about!
So, what the goal? 0:30? 0:15?
(41+...
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

April 17, 2010 at 7:07 am

#1153321
RE: Are the posted questions getting worse?

Steve Jones - Editor (4/16/2010)
I almost shudder to post this, but you all might like this:
http://lmgtfy.com/
as a sample, let me Google clustered index for you: http://lmgtfy.com/?q=clustered+index
Steve, surely you've seen me...
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

April 17, 2010 at 7:01 am

#1153318
RE: How to tune/speed up a procedure

lmu92 (4/16/2010)
gregory.anderson (4/16/2010)
Lutz, before I read your last post, I updated the Update statement for the previous permits, this will do the successful inserts, as well as the failed inserts...
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

April 16, 2010 at 6:25 pm

#1153237
RE: Is Primary key clustered index different from Unique key clustered index??

Good answer Steve.
My answer was based on
My questions is now is the defined primary key a Clustered, unique primary key or just Clustered primary key??
, where the only difference...
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

April 16, 2010 at 6:18 pm

#1153235
RE: Continuing Education

Jack Corbett (4/16/2010)
I'll be in touch as we are planning our next SQLSaturday now. Early October is a nice time to be here.
Hey Jack, how about keeping me...
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

April 16, 2010 at 6:09 pm

#1153233

Viewing 15 posts - 4,351 through 4,365 (of 5,588 total)