Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,721 through 45,735 (of 59,101 total)

RE: The Set-Based Limit

So, Kit... can I see your code like I asked, 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)

January 21, 2009 at 12:24 pm

#930617
RE: 16 digit unique number

Matt Miller (1/20/2009)
The only way you're going to ENSURE that it's unique is to keep track of all of the ones previously generated. Use whatever methodology you like to...
--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)

January 21, 2009 at 12:23 pm

#930616
RE: Questions on looping and grouping data

GROUP BY ..... WITH ROLLUP
Only thing is, it's gonna be a pain to add things that are a mix of datatypes like "Cost $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)

January 21, 2009 at 12:17 pm

#930608
RE: How to correctly create a Flat File on export?

Just as a suggestion to get away from kludge code, take a look at BCP with a format file... it'll do just what you want.
--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)

January 21, 2009 at 11:59 am

#930600
RE: Stumbling on a SQL query - Help!!

Lynn, you have the patience of a saint. Yoda be da man!
--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)

January 21, 2009 at 11:54 am

#930594
RE: Best performance Row by row loop (SQL2K)

agh100 (1/21/2009)
Hi GSquared,
I have been sick for some days now, so I haven't been able to try your script until now.. And thanks very much, it works splendidly on SQL...
--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)

January 21, 2009 at 11:48 am

#930590
RE: convert DateTime to BigInt

munishprathap (1/20/2009)
Thanks friends for all your support
i can achieve this task by the following Query,please let me know your feedback
IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Note'
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)

January 21, 2009 at 6:32 am

#930275
RE: VM... Setting up new "box"

Michael Earl (1/21/2009)
I think you are seriously underestimating the number of people that are not thinking.
Not sure what you mean by that, Michael...
--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)

January 21, 2009 at 6:28 am

#930270
RE: Why do people need to do this?

RBarryYoung (1/20/2009)
Jeff Moden (1/20/2009)
Truer words never spoken... it's a pig and I was trying to name the pig. 🙂 I believe the label of "Procedural Mystery Code Requirement"...
--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)

January 20, 2009 at 9:54 pm

#930081
RE: create view problem

rio_briones (1/20/2009)
View definition cannot contain the following
TOP
Text, ntext or image columns
DISTINCT
MIN, MAX, COUNT, STDEV, VARIANCE, AVG
SUM on a nullable expression
A derived table
Rowset function
Another view
UNION
Subqueries, outer joins, self joins
Full-text predicates like...
--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)

January 20, 2009 at 9:51 pm

#930080
RE: VM... Setting up new "box"

Steve Jones - Editor (1/20/2009)
VMs don't kill servers, server administrators kill servers.
Don't blame VMS, it's an ignorance thing, same as any other new tool we get. Usually we give them...
--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)

January 20, 2009 at 9:48 pm

#930078
RE: backup failure

Ok... something big just changed. It couldn't see the files in that directory before, but suddenly it can. Try running the backup again.
--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)

January 20, 2009 at 9:45 pm

#930076
RE: Select Where_Min()

Heh... limits are good. Neither my driving a million rows through something nor the speediest pork chop that I can muster up will ever have the impact that a...
--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)

January 20, 2009 at 9:42 pm

#930075
RE: Quick Question about Using Functions, creates 30k lines in profiler

You bet... thank you for the feedback.
--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)

January 20, 2009 at 9:35 pm

#930073
RE: Share data (Parameters) between datasets in SSRS 2005

htilburgs (1/20/2009)
Yes, I'm using ReportServer and I'm using the parameters to make selections, so I need them.
I'll try the method of Jeff, to fill my parameter.
If it doesn't work, I'll...
--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)

January 20, 2009 at 9:30 pm

#930070

Viewing 15 posts - 45,721 through 45,735 (of 59,101 total)