Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,811 through 9,825 (of 59,099 total)

RE: Performance Issue Problem in Stored Procedure

saravanan.a 88885 - Friday, February 15, 2019 2:08 AM
Hi All ,
I have one Stored procedure it has performance issue .Every 5...
--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)

February 15, 2019 at 8:36 am

#2022156
RE: Are the posted questions getting worse?

Lynn Pettis - Friday, February 15, 2019 4:16 AM
I guess it is my turn.
I received a call this morning (2019-02-15) at approximately...
--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)

February 15, 2019 at 8:21 am

#2022154
RE: How to code to change text to high case for all tables?

I'd still be really interested in why this evolution is actually necessary and, if necessary, how you're going to force all future inserts and updates to be limited to upper...
--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)

February 14, 2019 at 10:46 am

#2022091
RE: ALTER TABLE ALTER COLUMN WITH (ONLINE=ON) blocking

PHXHoward - Tuesday, February 12, 2019 11:19 AM
Surprisingly there was some blocking taking place when testing the ALTER COLUMN command online....
--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)

February 14, 2019 at 8:10 am

#2022076
RE: SQL : Concatenate unique values in rows based on a condition.

gideon.e - Thursday, February 14, 2019 5:55 AM
Hi Saravan. Thank you. Icannot figure out how to do that in Visual Studio Community...
--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)

February 14, 2019 at 7:51 am

#2022067
RE: Find and replace third occurrence of the string

Michael L John - Monday, February 11, 2019 12:53 PM
saravanatn - Thursday, October 18, 2018 8:42 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)

February 14, 2019 at 7:31 am

#2022063
RE: Question on Grouping -Working number of days

sgmunson - Wednesday, February 13, 2019 8:32 AM
Jeff Moden - Wednesday, February 13, 2019 7:36 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)

February 13, 2019 at 9:36 am

#2021940
RE: Question on Grouping -Working number of days

okfine08 - Monday, February 4, 2019 11:56 PM
hi jeff
My reasons ..
1) For small amounts of data
2) something different
3) easy 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)

February 13, 2019 at 7:43 am

#2021918
RE: Question on Grouping -Working number of days

sgmunson - Wednesday, February 13, 2019 7:14 AM
Okay folks. Recursion is not necessarily a problem, although it certainly can be. For smaller...
--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)

February 13, 2019 at 7:36 am

#2021917
RE: A real doozie!

zuma-1122451 - Tuesday, February 12, 2019 5:07 PM
Success! Yet, the mystery continues as I do not feel satisfied with WHY this happens...
--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)

February 12, 2019 at 6:10 pm

#2021883
RE: Increment dates for a set of records

barry.nielson - Tuesday, February 12, 2019 2:31 PM
it's a little complex but this is a set of records that maintain customer balances...
--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)

February 12, 2019 at 2:45 pm

#2021859
RE: Increment dates for a set of records

This seems like it could get out of hand storage-wise very quickly. Why do you need a fresh set of ALL rows every day? If we knew this, we might...
--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)

February 12, 2019 at 6:27 am

#2021762
RE: How to code to change text to high case for all tables?

adonetok - Tuesday, February 12, 2019 6:11 AM
Yes, I mean upper case. For example, I want to change data "Good" to GOOD".
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)

February 12, 2019 at 6:22 am

#2021759
RE: How should I reserve a set of "next numbers"?

Ah... found it in a 12 year old post of mine. Please see the following post. You can also replace the vendor's code and eliminate the possibility of getting 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)

February 11, 2019 at 8:20 am

#2021661
RE: How should I reserve a set of "next numbers"?

Chris Wooding - Monday, February 11, 2019 1:34 AM
Here's the next key table.
create table SEQ_SYSTEMKEY (LASTKEY int null) on [PRIMARY];
and...
--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)

February 11, 2019 at 8:05 am

#2021655

Viewing 15 posts - 9,811 through 9,825 (of 59,099 total)