Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,481 through 15,495 (of 59,063 total)

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
RE: Number of integers where digits are not repeating.

ben.brugman - Thursday, March 2, 2017 7:42 AM
--------- This is for fun only ...
--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 6:54 pm

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

mw112009 - Thursday, March 2, 2017 3:39 PM
Please
DECLARE @String AS VARCHAR(100)
DECLARE @Search_String AS VARCHAR(100)
SET @String ='The SQL SERVER is one of 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 2, 2017 at 6:47 pm

#1931384
RE: Code Test from IE

Damn. Just my luck that I'm in that group "small group". Guess it's time for me to finally try FireFox. Thanks, Steve.
--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 4:24 pm

#1931376
RE: Please explain difference between these terms

As a bit of a sidebar, it's a real shame that MS decided to offer "Books Online" as a separate product to be installed instead of making it a part...
--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:45 am

#1931221

Viewing 15 posts - 15,481 through 15,495 (of 59,063 total)