Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,796 through 24,810 (of 59,099 total)

RE: Data from Previous Row_2

Mike Osborne (1/10/2014)
caution: there are about a million rows in the raw table
Any chance that you'd like to have the original data in the table updated? If not, 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)

January 11, 2014 at 1:53 pm

#1679388
RE: Cursor Help

pietlinden (1/10/2014)
So sue me.
Pretty much an uncalled for statement.
--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 11, 2014 at 1:41 pm

#1679387
RE: Cursor Help

rocky_498 (1/10/2014)
Thanks, this topic is Delete
Deleting your original question is a really good way to have people mentally black ball you in the future. 😉
--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 11, 2014 at 1:40 pm

#1679386
RE: A few reflections on RBAR by a weary application developer

Tavis Reddick (1/9/2014)
I see that you do not have to do RBAR to get row error details for BULK INSERT from a data file.
Is there a set-based/declarative/T-SQL way of getting...
--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 11, 2014 at 1:34 pm

#1679385
RE: So Simple, But Yet ....

sestell1 (1/10/2014)
Your first query returns 0 rows because of the null email addresses in tableb.
IN is essentially a shorthand for a series of equality clauses, so
WHERE A NOT 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)

January 11, 2014 at 7:42 am

#1679369
RE: Determine the most recent datetime out of 3 columns

logitestus (1/10/2014)
Thank you Luis. <insert facepalm here/> That was exactly what was in UDF, I guess thats what I get when I assume.
There's still much room for performance...
--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 11, 2014 at 7:39 am

#1679368
RE: Query was executing fine and suddenly started taking time

Shadab Shah (1/10/2014)
Just thought of giving a Update.
The query is running with in the stipulated time.
Nothing has changed over a period of time no server settings have changed not...
--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 11, 2014 at 7:07 am

#1679367
RE: Are the posted questions getting worse?

BWFC (1/10/2014)
There is a philosophical question, often kicked around our office, about what happens when two people who know everything have an argument.
It's ironic... it they argue like that, then...
--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 10, 2014 at 7:23 am

#1679162
RE: The Desktop Setup

To be honest, I don't want or need much either as a DBA or and SQL Server Developer. I've learned to use the basic tools to get along just...
--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 9, 2014 at 10:00 pm

#1679033
RE: Last 3 months data

sharonsql2013 (1/9/2014)
Thanks.
Do you understand how the formulas work?
--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 9, 2014 at 9:36 pm

#1679032
RE: DBAs Need to Learn to Develop

eccentricDBA (1/9/2014)
What's the saying? "If all you have is a hammer every things a nail".
--Carlton
The problem is that a lot of people keep going to the store in 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)

January 9, 2014 at 2:35 pm

#1678978
RE: Need help with max value in date column

dwain.c (1/8/2014)
Always the bridesmaid and never the bride.
Heh... Like Granny used to say, "Kissin' don't last... cookin' do". 😀
--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 9, 2014 at 8:59 am

#1678826
RE: A few reflections on RBAR by a weary application developer

Tavis Reddick (1/9/2014)
Jeff Moden (12/11/2013)
To tell the truth, though, there should be 0 failures all the time even if the data is bad because the data should be imported into...
--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 9, 2014 at 8:52 am

#1678820
RE: A few reflections on RBAR by a weary application developer

craig 81366 (12/13/2013)
Would you please stop abusing the word exponential.
It really wrecks the credibility of your otherwise valid comments when you get this concept so fundamentally wrong.
The fact is that...
--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 9, 2014 at 8:50 am

#1678818
RE: query giving unexpected results

xp_DirTree returns the names of files AND directories. If you want to count just the files, then you have to include the "secret" 3rd operand for xp_DirTree and then...
--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 8, 2014 at 1:26 pm

#1678573

Viewing 15 posts - 24,796 through 24,810 (of 59,099 total)