Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,326 through 23,340 (of 59,099 total)

RE: Stored Procedure Performance

cbrammer1219 (6/28/2014)
Could you provide any sort of example of what you mean, like I said I'm new to SQL development. I have always had a competent DBA that had things...
--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)

June 28, 2014 at 7:48 pm

#1725705
RE: show changes from and changes to in a history table

Is that table encrypted by any chance?
--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)

June 28, 2014 at 5:43 pm

#1725701
RE: The Product Centric Career

Heh... I found that the most intelligent people I know have all learned a great deal by trying, failing, and trying something else, sometimes in very long strings of trying...
--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)

June 28, 2014 at 4:03 pm

#1725696
RE: Stored Procedure Performance

cbrammer1219 (6/28/2014)
yes..The only thing I am converting is the date, it is of course a string in the text file and when I substring the text file I nvarchar it...
--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)

June 28, 2014 at 3:43 pm

#1725693
RE: Stored Procedure Performance

Looking back at the original query again, you might also want the persisted computed column to return a NULL if the first digit is a "0" or if the first...
--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)

June 28, 2014 at 3:39 pm

#1725692
RE: Stored Procedure Performance

cbrammer1219 (6/27/2014)
It is even messier than that, I created a ETL package that cleaned it up even more, but after importing all of the files I am processing, found there...
--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)

June 28, 2014 at 3:35 pm

#1725691
RE: Need help with query

While you're waiting, please see the first link under "Helpful Links" in my signature line below. If you post readily consumable data as prescribed in that article, it would...
--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)

June 28, 2014 at 3:22 pm

#1725690
RE: Creating Integer Primary key value using the following query

carrieathomer (6/26/2014)
do you see the url of this page, the id used inthe URL.
jumping 10000 everytime for server restart (happens in shared hosting environment) creates 7 digit or 8 digit...
--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)

June 28, 2014 at 3:01 pm

#1725689
RE: Are DMVs deprecated in 2014 SQL Instance

Stupid question, I know, but you didn't happen to accidently change the font color to White, did you? If that's not it, then I'd reinstall the client tools as...
--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)

June 28, 2014 at 1:50 pm

#1725688
RE: Best way to write stored procedures

Lynn Pettis (6/28/2014)
Jeff Moden (6/28/2014)
Lynn Pettis (6/28/2014)
Sana4u (6/28/2014)
HI
Is there a better way to write the following ?? Please view the below comments I have received in one of the stored...
--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)

June 28, 2014 at 1:48 pm

#1725687
RE: Best way to write stored procedures

Sana4u (6/26/2014)
Hi,
What is the best way to write stored procedures. Any tips on that also, I need to know how can I optimize stored procedures
To be honest, this is...
--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)

June 28, 2014 at 1:46 pm

#1725686
RE: Best way to write stored procedures

Lynn Pettis (6/28/2014)
Sana4u (6/28/2014)
HI
Is there a better way to write the following ?? Please view the below comments I have received in one of the stored procedure
Plenty wrong. For starters,...
--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)

June 28, 2014 at 1:32 pm

#1725684
RE: Are the posted questions getting worse?

SQLRNNR (6/27/2014)
Evil Kraig F (6/27/2014)
SQLRNNR (6/27/2014)
Evil Kraig F (6/27/2014)
Eirikur Eiriksson (6/27/2014)
The Dixie Flatline (6/27/2014)
Grant Fritchey (6/27/2014)
Koen Verbeeck (6/27/2014)
Grant Fritchey (6/27/2014)
Anyone think they can help this person? I think they really...
--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)

June 28, 2014 at 12:31 pm

#1725680
RE: no. of columns in excel may vary

ykonline (6/27/2014)
No, Columns positions will be same but we may receive new columns that
may not be exists in previous sheet which we received.
For Example,
First time, we receive the Sheet...
--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)

June 28, 2014 at 12:20 pm

#1725677
RE: Need help with query

My apologies. I'll blame it on a lack of caffeine. I overlooked the fact that you have a start and an end date.
I had a really good link...
--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)

June 28, 2014 at 12:01 pm

#1725675

Viewing 15 posts - 23,326 through 23,340 (of 59,099 total)