Jeff Moden

Forum Replies Created

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

RE: SQL performance counter shows 0 as values

Does anyone know if any of the methods listed on this thread actually worked? We're suffering from precisely the same problem as what the OP originally posted. We can see...
--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 2:21 pm

#2007004
RE: SQL Server v.Next is Coming in 2019

Steve Jones - SSC Editor - Tuesday, September 25, 2018 11:44 AM
Summer90 - Tuesday, September 25, 2018...
--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 1:10 pm

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

Eric M Russell - Tuesday, September 25, 2018 8:51 AM
When we speak of T-SQL "heresies", it seems we're speaking of anti-patterns. Some...
--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 10:03 am

#2006943
RE: e-commerce company, planning to start a sale offer in december

coolchaitu - Tuesday, September 25, 2018 1:53 AM
Hi Experts,
We are a small e-commerce company, planning to start an offer in december....
--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:34 am

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

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