Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,746 through 35,760 (of 59,102 total)

RE: TSQL CSV issue

churlbut (12/9/2010)
I have a cool function that I use for just this reason:
Create a table function:
CREATE FUNCTION [dbo].[ParseValues]
(@String varchar(8000),
@Delimiter char(1)...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 9, 2010 at 6:53 pm

#1260860
RE: Are the posted questions getting worse?

Jack Corbett (12/8/2010)
I still haven't seen any valid excuses...
Travel money, hotel money, earn money... I'd love to make the trip from Detroit to Florida this time of year but I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 9, 2010 at 12:36 pm

#1260742
RE: Need advice to improve SQL Server 2000 performance

thang_ngo_2002 (12/6/2010)
Yes, of course I will upgrade to Enterprise version
But as my second question, I'm worry about stabilization of Windows because at that case Windows has only 1GB for kernels.
Please...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 9, 2010 at 12:32 pm

#1260735
RE: SQLServerCentral Webinar Series #6: Gathering and Interpreting Server Metrics including SQL Monitor

Heh... dammit. That's on the same night as my local PASS group and they've also got an incredible subject that night. Hmmmm... maybe the folks in the MS...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 8, 2010 at 7:26 am

#1260086
RE: Which data type don't accept "Blank Value"

rocky_498 (12/8/2010)
Phil it is more than 60k rows my first thought was blank value giving me problem, but after you guys suggest find out which fields don't accept blank value...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 8, 2010 at 7:22 am

#1260083
RE: Parse text in a string

ScottPletcher (12/7/2010)
I don't know... you have 4 instances of CHARINDEX vs just 2
Quite true. A valid point.
3 of them are exactly the same function. Unfortunately,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 8, 2010 at 7:18 am

#1260081
RE: TSQL CSV issue

Sorry for the delay... have been working some strange hours. On my way to work. Will get to this tonight if no one beats me to it (and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 8, 2010 at 7:15 am

#1260079
RE: Group Islands of Contiguous Dates (SQL Spackle)

Geoff A (12/7/2010)
yet another GREAT spackle article. (Polyfilla for the people on the other side of the pond) 😛
thanks Jeff.
Thanks for the feedback and for stopping by, Geoff. 🙂
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 7, 2010 at 8:07 pm

#1259880
RE: Group Islands of Contiguous Dates (SQL Spackle)

Craig Farrell (12/7/2010)
RStarr, while your code seems functional (I didn't extensively test it), take a look at the million row test.
If you look near the bottom of the article, Jeff...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 7, 2010 at 7:55 pm

#1259878
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Mike McIver (12/7/2010)
The article's title/subtitles and other wording imply ISNUMERIC does not work properly. Here's a better way to explain the issue:
http://www.simple-talk.com/community/blogs/johnm/archive/2009/06/11/73729.aspx
Heh... nope. That's just the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 7, 2010 at 11:38 am

#1259718
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Mike McIver (12/7/2010)
Really . . . I don't know where to start. I suppose the thing to say is having command of data types is an essential for any...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 7, 2010 at 10:54 am

#1259699
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Hugo Kornelis (12/7/2010)
Mike McIver (12/7/2010)
This article is an example of how poor coding propagates.
I have to disagree.
Yes, you are right - all the examples are indeed valid string representations of...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 7, 2010 at 10:50 am

#1259697
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Mike McIver (12/7/2010)
The issue is ISNUMERIC returns true for values which are valid numeric data types and are not "only numeric digits" (look at the article intro again). I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 7, 2010 at 10:43 am

#1259693
RE: Group Islands of Contiguous Dates (SQL Spackle)

mtassin (12/7/2010)
As always when I read an article by Jeff two things happen.
1. I find a very useful tip that I'm sure I'll need within 1 month of reading the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 7, 2010 at 10:05 am

#1259668
RE: Group Islands of Contiguous Dates (SQL Spackle)

JJ B (12/7/2010)
This was new to me and you did an excellent job of explaining how it works. I was with you every step of the way. 5...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 7, 2010 at 10:02 am

#1259666

Viewing 15 posts - 35,746 through 35,760 (of 59,102 total)