WayneS

Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 5,588 total)

RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Jeff Moden (5/7/2011)
Does anyone else have any other suggestions for a speed enhancement before I do that?
:ermm: Have you tested Peso's/Peter's code that he sent you yet? His code normally...
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 7, 2011 at 12:47 pm

#1321418
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

SQLkiwi (5/6/2011)
WayneS (5/6/2011)
Gianluca Sartori (5/6/2011)
This thread is getting more and more exciting.
Awesome.
I know what you mean. I, for one, am looking forward to the revealing of the ultimate DelimitedSplit function....
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 7, 2011 at 12:43 pm

#1321415
RE: Are the posted questions getting worse?

GilaMonster (5/7/2011)
Jeff Moden (5/7/2011)
GilaMonster (5/6/2011)
Off to SQLSaturday, the first one in Africa
You can only say that once. I don't know if you had anything to do with it 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 7, 2011 at 12:36 pm

#1321412
RE: Deprecating Procs ... is there any way to probe DTS for SP dependencies?

This will load the information into a temp table on your system, and show you which procedures are in which SSIS packages.
-- declare and initialize variables for this script.
DECLARE @path...
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 6, 2011 at 9:01 pm

#1321353
RE: Deprecating Procs ... is there any way to probe DTS for SP dependencies?

bvaljalo-1000038 (5/5/2011)
Thanks Wayne.
That sounds like a great solution.
Is there any way I could trouble you to expound a bit upon this methodology? I've used Bulk Import in procedures 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 6, 2011 at 8:45 pm

#1321352
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

peter-757102 (5/6/2011)
WayneS (5/6/2011)
Can we get someone to put Peter's and Nadrek's code into a new test script, so that all can easily test it? Just modify Jeff's script to remove...
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 6, 2011 at 8:11 pm

#1321350
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Gianluca Sartori (5/6/2011)
This thread is getting more and more exciting.
Awesome.
I know what you mean. I, for one, am looking forward to the revealing of the ultimate DelimitedSplit function. It would...
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 6, 2011 at 8:10 pm

#1321349
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

peter-757102 (5/6/2011)
Nadrek (5/6/2011)
Peter: On my machine, you've definitely beat the article's original try, and beat my Union version, but the 0 based permanent temp table is still better.
Wayne: thank 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

May 6, 2011 at 2:53 pm

#1321312
RE: Are the posted questions getting worse?

Brandie Tarvin (5/6/2011)
Whoot! Did I mention I just got another story accepted? "The Hunt for Liberty Jones," my second science fiction story. And yesterday, I received the edits request.
Editor's Note:
...
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 6, 2011 at 12:31 pm

#1321220
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Nadrek (5/6/2011)
peter-757102 (5/6/2011)
New graphs would be nice, I got the feeling that the on-the-fly generated tally is now just as fast, if not faster then a 0 based physical tally...
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 6, 2011 at 12:20 pm

#1321213
RE: Table valued Function Performance

rootfixxxer (5/6/2011)
The same times 1,3 minutes....
Need to redesign the cursors, but i don't see how to ... 🙂
I see three things that can be involved in the slow performance:
1. Cursors...
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 6, 2011 at 9:59 am

#1321131
RE: Pivot the rows to columns

Check out the link in my signature on cross-tab and pivot tables.
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 6, 2011 at 7:02 am

#1320976
RE: Version Control for SQL Server

cgrammont (5/5/2011)
Yep.
cgrammont (5/4/2011)
Version control for application code (VB, CSharp, etc) I know. But version control for SQL, not really sure how to approach it, much less what to use for...
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 5, 2011 at 9:27 pm

#1320772
RE: need help with XML tag

ISNULL(upper(VCTYCLB), '')
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 5, 2011 at 8:31 pm

#1320768
RE: Version Control for SQL Server

Have you looked here[/url]?
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 5, 2011 at 2:17 pm

#1320682

Viewing 15 posts - 1,396 through 1,410 (of 5,588 total)