Jeff Moden

Forum Replies Created

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

RE: TOP Clause performance is slow

jkramprakash - Sunday, February 17, 2019 4:02 AM
I have 2 tables combined with union all operator in procedure.First table contains 20 million...
--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 17, 2019 at 7:34 am

#2022223
RE: The SQL Saturday Thread

My two "Black Arts" sessions have been accepted by Cincinnati and Colorado Springs. If you're in either area, stop by and say "Hi".
Ed Wagner is also going 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 15, 2019 at 9:10 am

#2022166
RE: The SQL Joke Thread

sgmunson - Friday, February 15, 2019 8:49 AM
Sue_H - Wednesday, February 13, 2019 2:03 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 15, 2019 at 9:07 am

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

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