Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,131 through 11,145 (of 59,095 total)

RE: Database email functionality

Scott Coleman - Tuesday, September 25, 2018 7:27 AM
If you want to capture the email failures, just enter your own email address...
--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)

September 25, 2018 at 9:29 am

#2006932
RE: Renaming a Schema in SQL Server

doug.bishop - Tuesday, September 25, 2018 7:26 AM
Good, clear article. I like the way you broke it down into steps, explaining...
--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)

September 25, 2018 at 9:21 am

#2006927
RE: BCP command executing in Putty

sgmunson - Tuesday, September 25, 2018 8:23 AM
satyainfosys - Tuesday, September 25, 2018 5:21 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)

September 25, 2018 at 8:59 am

#2006918
RE: How to use HASHBYTES function in sql server for multiple columns

And stop using SHA1. It has been deprecated for sometime now and your code will fail sometime in the not so distant future.
--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)

September 25, 2018 at 8:48 am

#2006914
RE: Are the posted questions getting worse?

The trouble with that is, it'll get lost.
Send that template out to people that own the jobs, have them fill it in, and then copy that information into...
--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)

September 25, 2018 at 6:41 am

#2006877
RE: Are there such things as SQL heresies?

Phil Factor - Monday, September 24, 2018 9:38 AM
The problem with documenting heresies, questionable design decisions and SQL Code smells is 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)

September 24, 2018 at 6:58 pm

#2006847
RE: Are the posted questions getting worse?

Thom A - Monday, September 24, 2018 10:13 AM
Eirikur Eiriksson - Monday, September 24, 2018 10:07 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)

September 24, 2018 at 1:53 pm

#2006818
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Monday, September 24, 2018 10:33 AM
Here is a safer version for varchar(8000),
😎
--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)

September 24, 2018 at 1:51 pm

#2006816
RE: Are the posted questions getting worse?

And no BULK EXPORT either. :crying:
--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)

September 24, 2018 at 9:35 am

#2006762
RE: Are the posted questions getting worse?

And after more than a decade of being an open item, still no built in Tally or sequence creation function. <headdesk>
The last few times we've requested...
--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)

September 24, 2018 at 9:28 am

#2006761
RE: Are the posted questions getting worse?

patrickmcginnis59 10839 - Monday, September 24, 2018 8:25 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)

September 24, 2018 at 9:02 am

#2006755
RE: Are there such things as SQL heresies?

RonKyle - Monday, September 24, 2018 8:02 AM
I would still caution that too many "it depends" becomes "I'll do it like I...
--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)

September 24, 2018 at 8:45 am

#2006752
RE: I have an idea how to reduce the number of meetings.

Heh.... It would be far easier to teach pigs to fly than it would be to train managers and other how to properly conduct and effective meeting. It's really difficult...
--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)

September 24, 2018 at 8:40 am

#2006751
RE: Are the posted questions getting worse?

The real fact of the matter is that whether or not T-SQL is actually declarative or not, doesn't actually matter. It is what it is. The key is to get...
--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)

September 24, 2018 at 6:43 am

#2006720
RE: SQL Server stored procedures fast in SQL but slow when called by ASP.NET

jkramprakash - Sunday, September 23, 2018 11:21 PM
Jeff Moden - Sunday, September 23, 2018 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)

September 24, 2018 at 6:31 am

#2006718

Viewing 15 posts - 11,131 through 11,145 (of 59,095 total)