Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,031 through 18,045 (of 59,069 total)

RE: The New Men of IT

ZZartin (3/21/2016)
Well a liar is a liar but just having a bunch of knowledge memorized is also not very valuable if it can't be applied. Looking at all 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)

March 21, 2016 at 1:10 pm

#1866594
RE: The New Men of IT

GeorgeCopeland (3/21/2016)
Could not agree more. I am much more interested in how you think and how you work than whether you know all of the parms on a raiserror statement.
Cool....
--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 21, 2016 at 11:04 am

#1866554
RE: Trim string based on characters

vigneshlagoons 51204 (3/21/2016)
got it!
reverse(right(reverse(app), len(app) - charindex('-',reverse(app),1)))
That uses 3 reverses and that's expensive. I'll try to get back to this tonight.
Personally, I wouldn't use any reverses for 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)

March 21, 2016 at 10:33 am

#1866541
RE: Query Performance Issue with multiple unions and a view

The execution plan shows at least two Cartesian products probably because of insufficient criteria. You can see these areas in the execution plan quite easily... they're the ones with...
--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 21, 2016 at 10:26 am

#1866537
RE: The New Men of IT

ZZartin (3/21/2016)
Hmm.... with the way technology is moving and I find this true in general not just IT the ability to acquire knowledge is far more valuable than the ability...
--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 21, 2016 at 10:01 am

#1866520
RE: The New Men of IT

GeorgeCopeland (3/21/2016)
Everyone in IT has skills that they learned on the job, which is a great way to learn, but you end up with holes in your knowledge. When interviewing,...
--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 21, 2016 at 9:52 am

#1866515
RE: A Good Use for Hadoop

Whether it does or not, the drop still happened. Apparently BI didn't help them.
--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 21, 2016 at 1:37 am

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

aaron.reese (3/9/2016)
I don't think anyone has actually managed to get the relevant information out of the OP or provide a solution. [difficult to do one without the other]
It seems reasonable...
--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 21, 2016 at 1:25 am

#1866376
RE: Are the posted questions getting worse?

Solomon Rutzky (3/16/2016)
Jeff Moden (3/16/2016)
Solomon Rutzky (3/16/2016)
Given the nature of the operation, it is most likely to be serial / sequential...
True enough but get Microsoft to post the guarantee 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 20, 2016 at 9:40 am

#1866342
RE: Are the posted questions getting worse?

spaghettidba (3/17/2016)
I had the same issue in the past, both with VMs and my laptop, where I partitioned the disk a bit too aggressively...
What I ended up doing is moving...
--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 20, 2016 at 9:37 am

#1866341
RE: The New Men of IT

TheRedneckDBA (3/19/2016)
I've only been in a position to interview candidates for the past few years or so, but in that short time I've been amazed at how many people I've...
--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 20, 2016 at 8:06 am

#1866328
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

mburbea (3/19/2016)
As for the xmlsplitter being only 12% worse than delimited split, again I don't think its that far fetched. This version of the func uses lag() analytic funcs 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)

March 19, 2016 at 8:32 pm

#1866298
RE: Find a String in a String

quagmired (3/19/2016)
Jeff Moden (3/19/2016)
I'm a big fan of using the right tool to the job (even when others don't think it's the right tool). With that in mind, what...
--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 19, 2016 at 8:11 pm

#1866297
RE: Identify possible duplicates in a table (finding approximate matches)

tarr94 (3/18/2016)
Hugo,
Thanks for the response! I marked it as the correct solution because I know I've seen SSIS used for this purpose, but I actually ended up dumping 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)

March 19, 2016 at 1:11 pm

#1866290
RE: Parse the Data and pump it onto SQL Sever

Mac1986 (3/18/2016)
I got it working. we can archive this thread. Thanks a lot
foreach ($line in $ReturnString)
{
$array = @()
if ($line -notmatch "ID,...
--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 19, 2016 at 12:55 pm

#1866287

Viewing 15 posts - 18,031 through 18,045 (of 59,069 total)