Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,866 through 14,880 (of 59,097 total)

RE: SUBSTRING and CHARINDEX query.... please help.

Eirikur Eiriksson - Saturday, June 24, 2017 7:36 AM
Jeff Moden - Friday, June 23, 2017 11:39 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)

June 24, 2017 at 9:51 am

#1948048
RE: xp_cmdshell proxy account gets "lost"

Michael L John - Saturday, June 24, 2017 5:45 AM
Jeff Moden - Friday, June 23, 2017 8:21 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)

June 24, 2017 at 9:01 am

#1948047
RE: SUBSTRING and CHARINDEX query.... please help.

Ed Wagner - Friday, June 23, 2017 5:57 PM
Jeff Moden - Friday, June 23, 2017 2:52...
--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)

June 23, 2017 at 11:39 pm

#1948038
RE: Unable to understand the Query Logic

sgmunson - Friday, June 23, 2017 10:07 AM
Okay, now that I've had some time to mess with it, here's a working solution:
USE...
--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)

June 23, 2017 at 9:51 pm

#1948036
RE: Which one is the best Data warehouse online training? Hurry!@!!!!!

Have you downloaded and installed the SQL Server Developer Edition? Without that, no course will help you the way it should.
--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)

June 23, 2017 at 8:24 pm

#1948034
RE: xp_cmdshell proxy account gets "lost"

Michael L John - Thursday, June 22, 2017 9:27 AM
I created a domain account, and added it to the proper groups on...
--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)

June 23, 2017 at 8:21 pm

#1948033
RE: Are the posted questions getting worse?

Ed Wagner - Friday, June 23, 2017 1:20 PM
JustMarie - Friday, June 23, 2017 1: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)

June 23, 2017 at 2:57 pm

#1948021
RE: SUBSTRING and CHARINDEX query.... please help.

Eirikur Eiriksson - Friday, June 23, 2017 12:36 PM
I have done some fairly extensive tests on the string splitting options and 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)

June 23, 2017 at 2:52 pm

#1948020
RE: SUBSTRING and CHARINDEX query.... please help.

Eirikur Eiriksson - Friday, June 23, 2017 7:43 AM
If you are on SQL Server 2016 then use the new native
--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)

June 23, 2017 at 9:53 am

#1947984

RE: Slow performance of SP

Thom A - Friday, June 23, 2017 4:29 AM
Do you have the query plans. Those are the really important part here, if...
--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)

June 23, 2017 at 9:47 am

#1947983

RE: Are the posted questions getting worse?

Thom A - Friday, June 23, 2017 9:06 AM
Jeff Moden - Friday, June 23, 2017 8:58 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)

June 23, 2017 at 9:27 am

#1947977

RE: Microsoft SQL Server Utilities and Tools

Awesome. Thanks for taking the time to post 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)

June 23, 2017 at 9:04 am

#1947972

RE: Are the posted questions getting worse?

Grant Fritchey - Friday, June 23, 2017 7:42 AM
Thom A - Friday, June 23, 2017 6:52 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)

June 23, 2017 at 8:58 am

#1947970

RE: How to get the monday of every week

Ed Wagner - Thursday, June 22, 2017 3:42 PM
Jeff Moden - Thursday, June 22, 2017 1:57 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)

June 22, 2017 at 8:44 pm

#1947876

RE: How to get the monday of every week

komal145 - Thursday, June 22, 2017 1:55 PM
Thanks everyone was able to get the monday's from Getdate()
SELECT DATEADD(wk, -5, DATEADD(DAY, -5-DATEPART(WEEKDAY, GETDATE()),...
--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)

June 22, 2017 at 3:09 pm

#1947851

Viewing 15 posts - 14,866 through 14,880 (of 59,097 total)
Prev
1
2
3
…
991
992
993
…
3,938
3,939
3,940
Next