Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,066 through 19,080 (of 59,098 total)

RE: Rethinking Hiring

Ed Wagner (12/3/2015)
Jeff Moden (12/3/2015)
"Required: At least 5 years experience with SQL Server 2016"
"Required: Strong performance tuning experience with SQL Server 2013"
I've seen something like that before....
--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 3, 2015 at 10:18 pm

#1843973
RE: How to execute a Powershell script via SSIS

stan.geiger (12/3/2015)
Personally I think executing Powershell scripts within SSIS sets a really bad precedent. There is probably a better solution. Just my opinion, but I would never...
--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 3, 2015 at 10:06 pm

#1843971
RE: ETL and Data Analysis

Heh... <heavy sigh>... when will people learn? The two teams need to learn to embrace the talents of each team and exploit those talents for the good of the...
--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 3, 2015 at 9:55 pm

#1843970
RE: Generate sequence of numbers between values

Aditya Daruka (12/3/2015)
It may be slower, but still quite an interesting way of playing with t-sql
Everything is not always about speed!
I am happy with tally function, great way to tackle...
--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 3, 2015 at 9:32 pm

#1843968
RE: Generate sequence of numbers between values

Lynn Pettis (12/3/2015)
Jeff Moden (12/3/2015)
himanshu.sinha (12/1/2015)
Thanks Jeff for the idea of putting the while loop in TRAN , I think I understand the logic behind that . I hope...
--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 3, 2015 at 9:20 pm

#1843966
RE: Execute Stored Procedure into Temp Table

gmrose (12/3/2015)
Thank you both for your help. I found that inside the stored procedure was already code similar to that which you each proposed. When I entered the...
--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 3, 2015 at 1:54 pm

#1843896
RE: SQL interactive book

wallywizard (12/3/2015)
Does anyone know of a good sql book that comes with an interactive cd so I can practice the code along with the reading?
thank you
With the understanding 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)

December 3, 2015 at 1:48 pm

#1843889
RE: Update all values in a row or just what changed? Several considerations...

It's also a bitch for "field level auditing".
--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 3, 2015 at 1:33 pm

#1843887
RE: Rethinking Hiring

Rod at work (12/3/2015)
markedconn (12/2/2015)
Agree 100%. To many job descriptions are written by HR. I have seen some that look like they were pulled off of some generic web...
--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 3, 2015 at 1:29 pm

#1843885
RE: Generate sequence of numbers between values

himanshu.sinha (12/1/2015)
Thanks Jeff for the idea of putting the while loop in TRAN , I think I understand the logic behind that . I hope if anyone who uses...
--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 3, 2015 at 1:09 pm

#1843878
RE: Execute Stored Procedure into Temp Table

gmrose (12/3/2015)
I would like to execute a stored procedure and have its results sent to a temp table so that I could do further actions on those results. 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)

December 3, 2015 at 1:08 pm

#1843877
RE: Can someone point me to a good resource in the internet

Gail Shaw (The "Gila Monster") has an awesome mini-series on the subject right here on SSC.
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
Kimberly Tripp also has a great video on the subject. Don't let the word...
--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 3, 2015 at 4:43 am

#1843726
RE: Flag the old column to 0 when new record is inserted!

If you have dates (Changed_Date column) in the history table, then why do you need a flag to tell you whether a row is active or not? You have...
--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 1, 2015 at 11:08 pm

#1843399
RE: Generate sequence of numbers between values

himanshu.sinha (12/1/2015)
I think using a while loop this should be achievable
DECLARE @rng-2 TABLE ( seq int identity(1,1),Id INT, RangeStart BIGINT, RangeEnd BIGINT, Category INT, NumberCount INT)
DECLARE @RNG_output TABLE (...
--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 1, 2015 at 10:48 pm

#1843395
RE: Generate sequence of numbers between values

kiril.lazarov.77 (12/1/2015)
Hi, Thanks for your response. Not sure if I want to follow that approach due to the BIGINT data types. I'm looking for a simple way of doing this,...
--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 1, 2015 at 10:29 pm

#1843391

Viewing 15 posts - 19,066 through 19,080 (of 59,098 total)