Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,946 through 18,960 (of 59,072 total)

RE: Convert Rows into Columns

pcanino70 (12/14/2015)
I did some further analysis on Jeff Moden's example and I'm convinced his cross tab method is the proper way to go, I just converted a query that 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)

December 16, 2015 at 2:21 pm

#1846440
RE: Incremental Loading using SSIS

RonKyle (12/16/2015)
there are a lot of BI developers who simply won't move data using T-SQL tasks, even when you point out that it's easier to code and 10x as fast....
--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)

December 16, 2015 at 2:18 pm

#1846439
RE: How to pad a string with spaces when size of data is unknown

ChrisM@Work (12/15/2015)
Jeff Moden (12/12/2015)
ChrisM@Work (12/10/2015)
Jeff Moden (12/9/2015)
ChrisM@Work (12/9/2015)
suvesh.sonker 2691 (12/9/2015)
-- Ten digit
Declare @field as varchar(20) = '559'
Select Replace(right(replicate(' ',10) + @field ,10),' ','0')
In what circumstances might this be preferable 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)

December 16, 2015 at 2:04 pm

#1846435
RE: Are the posted questions getting worse?

Ed Wagner (12/16/2015)
WayneS (12/16/2015)
Jeff Moden (12/16/2015)
Steve Jones - SSC Editor (12/15/2015)
Jeff Moden (12/15/2015)
@steve-2,
According to your blog, you might show up in Cleveland SQLSaturday for 2016. Any way of knowing...
--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)

December 16, 2015 at 10:43 am

#1846376
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (12/15/2015)
Jeff Moden (12/15/2015)
@steve-2,
According to your blog, you might show up in Cleveland SQLSaturday for 2016. Any way of knowing for sure?
No, Cleveland is out....
--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)

December 16, 2015 at 7:22 am

#1846297
RE: Incremental Loading using SSIS

Eric M Russell (12/15/2015)
Jeff Moden (12/15/2015)
larskandersen (12/15/2015)
Just to expand on Jeff’s “upsert“ comment for future reference.
This pattern can be replaced with a single “Upsert” on the source and destination...
--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)

December 15, 2015 at 5:40 pm

#1846229
RE: Are the posted questions getting worse?

@steve-2,
According to your blog, you might show up in Cleveland SQLSaturday for 2016. Any way of knowing for 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)

December 15, 2015 at 3:10 pm

#1846209
RE: Incremental Loading using SSIS

larskandersen (12/15/2015)
Just to expand on Jeff’s “upsert“ comment for future reference.
This pattern can be replaced with a single “Upsert” on the source and destination table. I find the merge...
--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)

December 15, 2015 at 2:55 pm

#1846207
RE: Any Risk when Sql Server Agent Startup Sql Job

suresh0534 (12/15/2015)
Sql Job - runs automatically when SQL Server Agent starts up is there any security risk.
Please give me details.
Thanks
What does the job 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)

December 15, 2015 at 11:05 am

#1846150
RE: Incremental Loading using SSIS

Oh my... all that just to do a simple "upsert".
--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)

December 15, 2015 at 11:04 am

#1846149
RE: Anti SQL Injection Function

JohnG69 (12/15/2015)
Hey Jeff,
The parameters are tablenames and columns. Right now, a Delphi software (procedure) has the same parameters and does it all withing the program. They want...
--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)

December 15, 2015 at 8:06 am

#1846095
RE: How to select 200k data faster in sql

ScottPletcher (12/14/2015)
Jeff Moden (12/12/2015)
ScottPletcher (12/10/2015)
Do you have a unique index on Word? You don't want SQL to have to sort the words every time -- that will be extremely...
--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)

December 15, 2015 at 8:04 am

#1846094
RE: How to select 200k data faster in sql

jaquino012 (12/14/2015)
Hi,
@jeff Moden
Yes, i have been working on a simple dictionary with a limited words and it is working fine.
but what if the words are so big the i cant...
--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)

December 15, 2015 at 7:57 am

#1846091
RE: Optimizing a table created at runtime

chaaarliship (12/13/2015)
hello
you are Optimizing a table created at runtime with help of html . this process is very easy and simple , to learn html and...
--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)

December 14, 2015 at 6:38 pm

#1845977
RE: Anti SQL Injection Function

I see nothing in your first two scripts that require any dynamic SQL whatsoever.
As for the 3rd script, I don't know why such a bit of "Catch All" C.R.U.D....
--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)

December 14, 2015 at 6:28 pm

#1845975

Viewing 15 posts - 18,946 through 18,960 (of 59,072 total)