Jeff Moden

Forum Replies Created

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

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
RE: sqlcmd error when executed from bat file

I'm pretty sure that you also need to specify the parameter that provides for a "trusted connection".
--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 7:48 pm

#1931393
RE: SQL Server 2016 DBA Training

Much cheaper and probably faster to download the Dev Edition of 2016 (it's free now) and buy the books on the two exams.
--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 7:42 pm

#1931392
RE: top 1000 added to linked server select taking forever to run

Snargables - Thursday, March 2, 2017 8:28 AM
there is no order by and the actual select that is called is below. 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)

March 2, 2017 at 7:12 pm

#1931389
RE: Strange self blocking

Considering that the "b" query appears to be a doubled triangular join (just one diagonal from being a full up square join {Cartesian Product/Cross Join}), I'm not surprised that your...
--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 7:09 pm

#1931387

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