Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,511 through 15,525 (of 59,101 total)

RE: Please explain difference between these terms

Heh... the reason why Google "doesn't" help here is because you've not Googled enough. 😉 Security in Windows and SQL Server is a huge subject that entire books have been...
--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 5, 2017 at 10:52 am

#1931698
RE: Please explain difference between these terms

Correct and agreed on all points. LMGTFY is hilarious... until you're on the receiving end and you really need some help.
--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, 2017 at 3:31 pm

#1931679
RE: SQL question ? How can we find all the occurrences of a text in a string

Jeff Atherton - Friday, March 3, 2017 12:26 PM
Luis Cazares - Friday, March 3, 2017 12:17 PM
--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, 2017 at 3:23 pm

#1931678
RE: SQL question ? How can we find all the occurrences of a text in a string

Jeff Atherton - Friday, March 3, 2017 12:00 PM
J Livingston SQL - Friday, March 3, 2017...
--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, 2017 at 1:14 pm

#1931676
RE: Please explain difference between these terms

You got that, as well. 😉 Glad everything ultimately worked out. Despite the occasional excursion to LMGTFY and occasional frustration on both sides of a given thread, I've found 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 4, 2017 at 8:07 am

#1931668
RE: Please explain difference between these terms

larsp777se - Friday, March 3, 2017 11:21 PM
Jeff Moden - Friday, March 3, 2017 4:48 PM
--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, 2017 at 6:18 am

#1931666
RE: SQL question ? How can we find all the occurrences of a text in a string

mw112009 - Friday, March 3, 2017 6:49 AM
Would like the position of each occurrence in a comma separated string.
Apologies for the questions...
--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, 2017 at 6:39 pm

#1931650
RE: sqlcmd error when executed from bat file

Agreed. The absence isn't causing a problem.
--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, 2017 at 6:08 pm

#1931649
RE: Usage of CTE - Trick with Dates

SoCal_DBD - Friday, March 3, 2017 3:21 PM
Dan Kelley - Friday, March 3, 2017 2:16 PM
--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, 2017 at 6:07 pm

#1931648
RE: Are the posted questions getting worse?

Sean Lange - Friday, March 3, 2017 10:39 AM
SQLRNNR - Friday, March 3, 2017 10:30 AM
--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, 2017 at 5:20 pm

#1931647
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Friday, March 3, 2017 8:54 AM
On a related note with the AWS outage, this made me...
--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, 2017 at 5:17 pm

#1931646
RE: Please explain difference between these terms

larsp777se - Thursday, March 2, 2017 8:57 PM
Jeff Moden - Thursday, March 2, 2017 8:40 AM
--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, 2017 at 4:48 pm

#1931645
RE: Code Test from IE

NP and understood. Just seriously disappointed because it used to work really well after you folks fixed things after the last major forum code upgrade more than a decade ago. I thought you...
--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, 2017 at 4:39 pm

#1931644
RE: sqlcmd error when executed from bat file

Sue_H - Thursday, March 2, 2017 7:59 PM
Jeff Moden - Thursday, March 2, 2017 7:48 PM
--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 2, 2017 at 8:13 pm

#1931397
RE: Some more about cloud technology: Azure and AWS monitoring

Heh... first of all, big companies have NOT "always used cloud for security reasons" because the cloud hasn't "always" been around.
Second, this is just spam and has been...
--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 2, 2017 at 8:01 pm

#1931396

Viewing 15 posts - 15,511 through 15,525 (of 59,101 total)