Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,016 through 15,030 (of 59,097 total)

RE: t-sql 2012 parse out multiple values in one field that is varchar(1200)

wendy elizabeth - Friday, May 19, 2017 3:44 PM
In a t-sql 2012 database, I am suppose to count the number of times...
--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 19, 2017 at 11:05 pm

#1943409
RE: BEFORE TRIGGER Idea Posted to Microsoft Connect

I definitely voted that bad boy up. That was one of the things that I really liked about Oracle for the short 3 year stint that I had to 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)

May 19, 2017 at 7:18 pm

#1943406
RE: Array Element by Agonizing Array Element

xsevensinzx - Friday, May 19, 2017 6:58 AM
Yeah, I normally just stick to Python for most looping simply because it's easier 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)

May 19, 2017 at 7:02 pm

#1943405
RE: Are the posted questions getting worse?

Grant Fritchey - Friday, May 19, 2017 7:47 AM
Who is going to SQLSaturday NYC?
I'm doing the keynote.
Wow. I'd like to see 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)

May 19, 2017 at 6:54 pm

#1943404
RE: Are the posted questions getting worse?

Ray K - Friday, May 19, 2017 3:38 PM
I suppose this is as good as a place to post as anything...
As of...
--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 19, 2017 at 6:50 pm

#1943403
RE: string to time conversion problem

To be honest, using a scalar function here is a bit insane not to mention how complex it's been made. Like Perry...
--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 19, 2017 at 6:16 am

#1943277
RE: Creating a temp table with dynamic SQL

And another here...
http://sqlhints.com/2013/04/14/sequence-in-sql-server-2012/
--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 19, 2017 at 5:49 am

#1943271
RE: Are the posted questions getting worse?

Michael L John - Thursday, May 18, 2017 2:48 PM
Anyone else ever do this?
https://www.sqlshack.com/how-to-spoof-production-environment-resources-for-performance-tuning/#.WRr9Do_GEfw.linkedin
Looks rather interesting...
I've not heard of 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)

May 18, 2017 at 7:05 pm

#1943218
RE: Creating a temp table with dynamic SQL

If you use a "sequence" object instead of an IDENTITY, there will be no need for a dynamic Temp Table nor even a need to determine what the next sequence...
--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 18, 2017 at 4:09 pm

#1943213
RE: How to pivot the row?

Sorry. Post deleted. Misread a couple of 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)

May 17, 2017 at 6:47 am

#1942889
RE: Array Element by Agonizing Array Element

Phil, the link in your first paragraph isn't working. It's pointed at some "C:" drive file somewhere.
--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 17, 2017 at 6:04 am

#1942875
RE: DBA Challenge! I've spent 4 hours trying to figure how to extract data from XML in a hierarchical form.

With no reflection on the OP because he's the poor consumer of this data and not the perpetrator... you just have to wonder what the heck is on people's minds...
--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 17, 2017 at 6:00 am

#1942871
RE: Are the posted questions getting worse?

Ed Wagner - Wednesday, May 17, 2017 5:09 AM
Brandie Tarvin - Wednesday, May 17, 2017 4:47 AM
--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 17, 2017 at 5:33 am

#1942861
RE: To Delete / Truncate / Drop & Create

Perry Whittle - Tuesday, May 16, 2017 3:16 AM
Jeff Moden - Tuesday, May 16, 2017 2:47 AM
--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 16, 2017 at 9:49 am

#1942720
RE: To Delete / Truncate / Drop & Create

Perry Whittle - Tuesday, May 16, 2017 1:20 AM
I agree, you probably won't even use it but the statement that a truncate...
--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 16, 2017 at 2:47 am

#1942657

Viewing 15 posts - 15,016 through 15,030 (of 59,097 total)