Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,681 through 43,695 (of 59,101 total)

RE: Long execution times when including simple SQL functions into a join

Are the 200 million rows all CDR's?
--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)

May 26, 2009 at 3:21 pm

#1000223
RE: Parse multiple dates from Text Field

Tim Daly (5/26/2009)
EXCELLENT!!!! Thank you VERY much Flo! Your code to extract the dates worked exactly right! I'll use this as the base for extracting the associated text.
And thank for...
--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)

May 26, 2009 at 1:56 pm

#1000168
RE: PIVOT QUERY HELP NEEDED

Chris...
I don't know if you saw the links... just in case...
http://www.sqlservercentral.com/articles/T-SQL/63681/
http://www.sqlservercentral.com/articles/cross+tab/65048/
I have to appologize for what they did to the code windows. They used to be almost full sized...
--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)

May 26, 2009 at 1:50 pm

#1000165
RE: The Real SQL Server Experts

Damus (5/26/2009)
Lynn Pettis (5/26/2009)
Damus (5/25/2009)
I am just a programmer. Been in the business for over 10 years now, I have changed the way I code so many times, but when...
--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)

May 26, 2009 at 1:40 pm

#1000156
RE: How to transfer the data from Excel to SQL2005

josephptran2002 (5/24/2009)
Hi Ike,
How are you doing? I am greatly appreciated your helps, I already solved the problem by using SSMS or Import/export wizard. You are very nice person, and may...
--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)

May 24, 2009 at 5:22 pm

#999531
RE: PIVOT QUERY HELP NEEDED

martin.edward (5/24/2009)
Ok guys, am not a SQL maestro, but I need to know it.
The parameters we were using were hardcoded. They need to be input by the user. I guess...
--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)

May 24, 2009 at 5:10 pm

#999529
RE: Query Help

Allister Reid (5/24/2009)
Ok Jeff, again thanks a lot for your time and patience, turns out your article http://www.sqlservercentral.com/articles/cross+tab/65048/ and subsequent discussions answered all the queries I had — must spend...
--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)

May 24, 2009 at 4:59 pm

#999527
RE: Long execution times when including simple SQL functions into a join

After seeing how fast the various renditions of the function run on a million rows, I'd say that it is NOT the function that is the problem. Adding such...
--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)

May 24, 2009 at 4:43 pm

#999524
RE: To write a query

Florian Reischl (5/24/2009)
Jeff Moden (5/23/2009)
Florian Reischl (5/23/2009)
Maybe it's time for your 5 bugs 😀
Ok... I'll bite. What do you mean here? I blame it on failing memory 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)

May 24, 2009 at 11:02 am

#999471
RE: The Real SQL Server Experts

ta.bu.shi.da.yu (5/24/2009)
Absolutely! I'm just saying that I think that open source projects are more influencable or are quicker to implement changes than closed source companies. My $0.02.
You and I both...
--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)

May 24, 2009 at 10:57 am

#999469
RE: Introduction to Bitmasking in SQL Server, Part 2

marshall.jones (5/23/2009)
That would be the case if I was actually doing what's happening in that example.
In practice other constraints on the datasets ensure that the number of reads is in...
--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)

May 24, 2009 at 12:24 am

#999421
RE: SQL 2008 - DBA

dbpatel.2784 (5/22/2009)
Thanks for the interest but i think i got the resolution. Thanks for helping ...
Heh... I'm thinking "Check Valve" right now.
--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)

May 23, 2009 at 10:11 pm

#999416
RE: Original Theatrical Release of Star Wars

Lynn Pettis (5/23/2009)
David Burrows (5/23/2009)
but she who must be obeyed would have fit.
It's easier to ask for forgiveness than it is for permission. :w00t:
Would not matter, if she isn't happy,...
--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)

May 23, 2009 at 10:03 pm

#999415
RE: The Real SQL Server Experts

ta.bu.shi.da.yu (5/23/2009)
Well, bare in mind I'm talking about organized projects, not little snippets of code. Look at the Samba project - they're about to get to the point where you...
--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)

May 23, 2009 at 10:01 pm

#999414
RE: Parse multiple dates from Text Field

The TEXT column in question is that of a "log" maintained by humans. Likely as not, it has some hidden delimiters in it. Please check the data for...
--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)

May 23, 2009 at 9:52 pm

#999413

Viewing 15 posts - 43,681 through 43,695 (of 59,101 total)