WayneS

Forum Replies Created

Viewing 15 posts - 5,521 through 5,535 (of 5,588 total)

RE: Using XML to Enhance the Performance of String Manipulations

lucian (8/21/2008)
But I want to return a table that I can use in a inner join with other tables, or in my where clause.
I understand. I mistakenly thought that you...
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

August 21, 2008 at 10:13 am

#861398
RE: Using XML to Enhance the Performance of String Manipulations

lucian (8/21/2008)
Very useful.
I use it to process a comma delimited list of keys or any other list of values that is passed as a parameter to a stored proc.
Now I...
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

August 21, 2008 at 6:18 am

#861159
RE: Using XML to Enhance the Performance of String Manipulations

nvanesch (8/21/2008)
I really good performance improvement on string concatenation. I guess these problems weren't present in SQL 2000 so much as we didn't have 2GB varchar variables to work 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

August 21, 2008 at 6:08 am

#861153
RE: Using XML to Enhance the Performance of String Manipulations

anil_mootha (8/20/2008)
Hi Paul,
It looks like nobodys bothered to answer our question. To me till I dont get a satisfactory answer, this topic doesnt make any sense!
Have a wonderful day!
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

August 21, 2008 at 5:58 am

#861147
RE: Using XML to Enhance the Performance of String Manipulations

Paul DB (8/20/2008)
WayneS (8/20/2008)
Paul DB (8/20/2008)
anil_mootha (8/20/2008)
Hi,
Why would you prefer to build XML strings manually when you can do it with FOR XML statement.
The very purpose of FOR XML statement...
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

August 20, 2008 at 12:31 pm

#860826
RE: Using XML to Enhance the Performance of String Manipulations

Paul DB (8/20/2008)
anil_mootha (8/20/2008)
Hi,
Why would you prefer to build XML strings manually when you can do it with FOR XML statement.
The very purpose of FOR XML statement would be void...
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

August 20, 2008 at 8:30 am

#860648
RE: Using XML to Enhance the Performance of String Manipulations

Steve Jones - Editor (8/20/2008)
The code edits have been made, so things should be OK now.
Thanks Steve!
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

August 20, 2008 at 8:21 am

#860639
RE: Using XML to Enhance the Performance of String Manipulations

JPJ (8/19/2008)
I agree with you wayne.
I have a small issue in addition to that, this line gave me error:
select @MyXMLString = @MyXMLString +
...
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

August 20, 2008 at 6:28 am

#860574
RE: Using XML to Enhance the Performance of String Manipulations

Hey all...
I don't know how it happened, but the code in the article is missing some spaces from what I submitted. They should be pretty obvious where that is, 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

August 19, 2008 at 9:33 pm

#860379
RE: SQL Server 2005

The links for Database Mail and SQL Mail are the same.
I thought that Database Mail replaced SQL Mail?
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

August 19, 2008 at 6:06 am

#859940
RE: References Permission

The first choice is also correct:
From BOL:
The REFERENCES permission on a table is needed in order to create a FOREIGN KEY constraint that references that table.
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

July 23, 2008 at 4:47 am

#846899
RE: Things You Didn't Know About Temp Tables and Table Variables

Is there really any difference or advantage between Temp Tables and Table variables? If there is not enough cache on hand and both will eventually hit TempDB - 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

July 17, 2008 at 6:23 am

#844318
RE: DIY

Well, I think building my own house qualifies me as a DIY-er (with lots of advice from the building inspector). I'll work on almost anything... until it involves an engine....
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

July 11, 2008 at 6:51 am

#841429
RE: The Daily Commute

Currently: I drive 4 hrs (260 miles) twice a week (Sunday pm, Friday pm)
Last job: drove 1 hr each way (50 miles) once a week (WFH remainder of week)
Last job...
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

July 10, 2008 at 7:23 am

#840795
RE: The Daily Commute

Steve Jones - Editor (7/8/2008)
Well I'm lucky. It's either 3 ft to grab the laptop off the dresser and RDP downstairs, walk 75 ft downstairs to the office, or another...
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

July 10, 2008 at 7:04 am

#840777

Viewing 15 posts - 5,521 through 5,535 (of 5,588 total)