Jeff Moden

Forum Replies Created

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

RE: Cte for String in random order

peter.cox (6/27/2014)
hi
anyone got an idea for a CTE that takes a string, and puts it into a table with the words in any order.
so the variable would be 'tesco mixed...
--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 8:24 pm

#1725708
RE: sa password reset automatically

sandy-833685 (6/28/2014)
Hi,
I am running SQL express 2012 on Win 2008 R2 64 bit server, from past few days I am observing my sa password is getting reset automatically, I had...
--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 8:18 pm

#1725707
RE: Stored Procedure Performance

p.s. Just to be sure, you would need to change the column names in the code that creates the PERSISTED COMPUTED COLUMN to match whatever column it 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)

June 28, 2014 at 7:53 pm

#1725706
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

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