Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,091 through 33,105 (of 59,099 total)

RE: Entity-Attribute-Value designs

Not so much EAV's and certainly not OTLT's, but I do use their smaller cousin, NVP's (Name/Value Pair), a fair bit especially if reporting is required. They're also quite...
--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)

July 27, 2011 at 9:08 pm

#1359787
RE: Split Column

rocky_498 (7/27/2011)
Hi guys,
Here is my data
Add,Street_Number,Street_Name
123 Johnson St,Null,Null
22 Main Blvd, Null, Null
I want to split "Add" column end result should be like this
Add,Street_Number,Street_Name
123 Johnson St,123,Johnson
22 Main Blvd,...
--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)

July 27, 2011 at 8:54 pm

#1359786
RE: Red Gate Data Generator

I agree... what are you going to do with the data generator once you've restored a copy of prod? Are you simply trying to obfuscate data?
--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)

July 27, 2011 at 8:49 pm

#1359785
RE: Clean Code

Ninja's_RGR'us (7/27/2011)
Jeff Moden (7/27/2011)
btull89 (7/27/2011)
Thanks for all of the feedback! It was helpful.
I'll add to all of this. Use thoughtful comments and section headers. IT makes life 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)

July 27, 2011 at 8:45 pm

#1359784
RE: How to use temporary table in function

Jim Wolgamot (7/27/2011)
A table variable seems like a better solution to me
In most cases, I'd agree. It's nice to have this wonderful trick available, though.
--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)

July 27, 2011 at 6:19 pm

#1359759
RE: dynamic pivot maybe?

Here we go... think "Teach someone to fish...". 😉
If we take the working code that I previously posted and mark the sections that are static and those that are dynamic,...
--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)

July 27, 2011 at 5:59 pm

#1359758
RE: dynamic pivot maybe?

ng.work (7/27/2011)
It does get me the display I'm looking for given I know all of the training names in advance. The number of columns needs to be dynamic.
If 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)

July 27, 2011 at 5:02 pm

#1359743
RE: nvarchar(100) shows length nvarchar(200) for sp_help

opc.three (7/27/2011)
Jeff, I figure you were trying to dilute things a bit here, which I do too depending on the forum as it were, but I want to make sure...
--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)

July 27, 2011 at 4:59 pm

#1359742
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (7/27/2011)
I don't control the announcement. I assume it will be a business day or two afterward.
From the website... kind of a buried link...
Important dates
1.Deadline for...
--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)

July 27, 2011 at 4:33 pm

#1359735
RE: Are the posted questions getting worse?

Roy Ernest (7/27/2011)
WayneS (7/27/2011)
Roy Ernest (7/27/2011)
Not much traffic on my blog I am afraid. Or else I would have written it already.. 🙂
Where is your blog?
Here in SSC. I 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)

July 27, 2011 at 4:28 pm

#1359732
RE: Are the posted questions getting worse?

GilaMonster (7/27/2011)
Jim Murphy (7/27/2011)
Useless post just to make 500.
I hate when people do this.
I'd do one, but it appears I'm off by more than one this time...
Congrats on blasting through...
--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)

July 27, 2011 at 4:19 pm

#1359730
RE: How to find performance difference before and after changing the query in SP

With exceptions, of course, many While loops will register 2 or 3 times the number of rows as there end up being in the result set.
--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)

July 27, 2011 at 4:14 pm

#1359724
RE: Clean Code

btull89 (7/27/2011)
Thanks for all of the feedback! It was helpful.
I'll add to all of this. Use thoughtful comments and section headers. IT makes life a whole lot easier...
--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)

July 27, 2011 at 2:30 pm

#1359673
RE: How to find performance difference before and after changing the query in SP

Ninja's_RGR'us (7/27/2011)
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2
I just use the basic cpu, reads, writes, duration columns.
Those events are nice to use in their own rights :
Performance:Showplan XML Statistics Profile
SP:StmtCompleted
SQL:StmtCompleted
I also throw in ROWCOUNT... 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)

July 27, 2011 at 2:28 pm

#1359671
RE: result set gets truncated

ekant_alone (7/27/2011)
Hello,
I am working on a huge XML file. I am trying to update a XML file. I am saving the broken parts into a variable of nvarchar(max) type Datatype....
--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)

July 27, 2011 at 2:23 pm

#1359666

Viewing 15 posts - 33,091 through 33,105 (of 59,099 total)