Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,226 through 18,240 (of 59,102 total)

RE: The Dangers of Algorithms

Here's the upcoming danger of "algorithms"...
http://www.imdb.com/title/tt0119177/plotsummary
Too far fetched for you? How about a dose of reality, then.
http://www.eyeondna.com/2007/05/19/want-a-job-submit-your-dna/
http://www.eyeondna.com/2009/10/29/getting-a-job-at-the-university-of-akron-could-require-a-dna-sample/
As idiotic as they normally are ...
http://www.eyeondna.com/2007/04/26/victory-for-genetic-information-nondiscrimination-act-gina/
Unfortunately, it's not airtight and genetic discrimination...
--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)

March 4, 2016 at 4:20 pm

#1863296
RE: The Tally Table

Gary Varga (3/4/2016)
Steve Jones - SSC Editor (3/4/2016)
Gary Varga (3/4/2016)
I have still yet to come across a requirement that would benefit from the use of a tally table. I read...
--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)

March 4, 2016 at 1:28 pm

#1863271
RE: How to show Quarters Dynamically in SQL

mandymvn (3/4/2016)
Hi Jeff,
used this in WHERE clause as:
where Qtr >=DATEADD(qq,DATEDIFF(qq,0,GETDATE())-3,0) AND Qtr < DATEADD(dd,DATEDIFF(dd,0,GETDATE())+1,0)
i tried to convert but still getting the error
and getting conversion error :Conversion failed when...
--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)

March 4, 2016 at 1:20 pm

#1863270
RE: Mystery data type conversion

PHXHoward (3/4/2016)
The sys_updated_on column is datetime2(7)
I think that the suggestions to explicitly format the data that is going into the varchar(10) column will solve the problem. It is really...
--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)

March 4, 2016 at 11:54 am

#1863258
RE: Substring from RIGHT

John Mitchell-245523 (3/4/2016)
REVERSE the string, use SUBSTRING, and then REVERSE it again.
John
Got code?
--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)

March 4, 2016 at 11:50 am

#1863254
RE: programming within SELECT statement

etl2016 (3/4/2016)
thanks.
But, its a bit more programming, involving local-scoped variables, some Queries, some aggregation and a final result.
Can we say something like, SELECT col1, col2, (DECLARE local_variable INT; SET @local_variable...
--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)

March 4, 2016 at 11:49 am

#1863253
RE: How to create a Stored Procedure from this Code

Phil Parkin (3/4/2016)
If someone offered me the choice between
a) Modifying one long and complex piece of code, and
b) Modifying several small and well-organised pieces of code, where the function 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)

March 4, 2016 at 11:47 am

#1863252
RE: Many conditions - best practice

Luis Cazares (3/3/2016)
Here's an example on how to work with iTVFs, actually 2.
For more information about iTVFs and how they compare with normal scalar functions, check this article written by...
--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)

March 4, 2016 at 7:44 am

#1863118
RE: tempdb local drive ssd versus attached storage

tcronin 95651 (3/4/2016)
Loads to the a data warehouse from source databases. I also have a 3rd party db I support with awful design (no control over it) so tempdb...
--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)

March 4, 2016 at 7:40 am

#1863111
RE: generate unique id for each row within a range

bismsit.29 (3/4/2016)
sure john i will let you know all in detail. i would look forward for your suggestion in this.
this is a new table which will get offer feed from...
--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)

March 4, 2016 at 7:21 am

#1863100
RE: tempdb local drive ssd versus attached storage

tcronin 95651 (3/4/2016)
THis is a data warehouse with monster ETL's I have seen great things about the Fusion product. The fact is it is cheaper than adding the SSD...
--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)

March 4, 2016 at 6:55 am

#1863086
RE: How to show Quarters Dynamically in SQL

mandymvn (3/3/2016)
Hi Jeff,
"do you want the report headings to auto-magically change based on today's date (whatever it is)?"
is there a way to do it ? I am not sure If...
--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)

March 4, 2016 at 12:08 am

#1862996
RE: generate unique id for each row within a range

bismsit.29 (3/3/2016)
Hi All
I want to assign one unique id to each row in a table and the range is from 1 to 99999. there will be a flag for active...
--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)

March 3, 2016 at 6:22 pm

#1862971
RE: How to show Quarters Dynamically in SQL

mandymvn (3/3/2016)
Hi,
At present am showing quarters from 2015-Q1 to Q4 , it should be like that, because report must show data for last 4 quarters only.
Whenever i got...
--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)

March 3, 2016 at 6:15 pm

#1862970
RE: Trouble Deploying CLR functions

fxferguson (3/3/2016)
I have some CLR functions that were compiled and under .Net framework 2.0 for SQL Server 2008. I modified and recompiled them under framework 4.0 to run on SQL...
--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)

March 3, 2016 at 6:10 pm

#1862969

Viewing 15 posts - 18,226 through 18,240 (of 59,102 total)