Jeff Moden

Forum Replies Created

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

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

jkramprakash - Wednesday, September 26, 2018 4:50 AM
i made some changes in the query.actually i created clustered index for three columns 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)

September 26, 2018 at 5:56 am

#2007059
RE: Database email functionality

nimmagaddakrupanandh - Wednesday, September 26, 2018 1:40 AM
But if i gave my mail ID in reply email also ,that failled items table...
--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 26, 2018 at 5:28 am

#2007053
RE: Fitting Into RAM

christopher.ivens - Tuesday, September 25, 2018 12:57 PM
We've been discussing REDUCING our RAM on a test box and leveraging the flash drives...
--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:54 pm

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

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