Jeff Moden

Forum Replies Created

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

RE: Parmissions issue running agent and bulk insert from network location

Bulk Insert uses the privs on the remote system as whomever or whatever is running it. You need for the SQL Agent service login to be able to see 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 26, 2017 at 6:33 am

#1948146
RE: replacing hard coded value with column name fails the query

jcelko212 32090 - Sunday, June 25, 2017 2:59 PM
Identifiers, such as application_id, cannot be numerics because you do know math on them.
Please post...
--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 25, 2017 at 3:39 pm

#1948088
RE: Are the posted questions getting worse?

TomThomson - Friday, June 23, 2017 8:19 PM
Sean Lange - Wednesday, June 21, 2017 3:25 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 7:24 pm

#1948068
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Saturday, June 24, 2017 1:25 PM
I sent a note to the devs. There is supposed 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)

June 24, 2017 at 6:41 pm

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

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