Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,061 through 18,075 (of 59,102 total)

RE: 2014 SSMS - SA Account password changing on it's owm - how to get rid off this issue.

pradeep 69787 (3/21/2016)
Message
Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT:]
Message
Error: 18456, Severity: 14, State: 8.
It sounds to me that the application 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)

March 22, 2016 at 7:44 am

#1866778
RE: Find a String in a String

quagmired (3/20/2016)
This is exactly what I'm talking about when I mention "cumbersome TSQL solution". For arbitrary 0s, I'd say a tally table would have to have over 2 billion records
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)

March 21, 2016 at 11:57 pm

#1866667
RE: The New Men of IT

Gary Varga (3/21/2016)
Jeff, do you have "BWAAA-HAAA!!!" assigned to a shortcut key?
No. Ran out of shortcut keys for "BS", "WTF", "NFW", "Seriously", and a couple of more. 🙂
--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 2:16 pm

#1866609
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

Viewing 15 posts - 18,061 through 18,075 (of 59,102 total)