Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,796 through 9,810 (of 59,091 total)

RE: The SQL Saturday Thread

Lynn Pettis - Friday, February 15, 2019 2:08 PM
Jeff Moden - Friday, February 15, 2019 9:10 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 17, 2019 at 6:33 pm

#2022236
RE: How to calculate Work Week based on the Next logic

amir.kachlon - Sunday, February 17, 2019 8:12 AM
Thanks for your insight ! that was fast 🙂
so would this script be the most...
--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 4:12 pm

#2022234
RE: How to calculate Work Week based on the Next logic

Removed this post because I didn't read the rules requested well enough.
--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 1:23 pm

#2022233
RE: Disable or rebuild all nonclustered indexes on a table

Just a word of caution here... the script is fine and the reason for disabling indexes prior to rebuilds or imports is great but be very aware that if you...
--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 12:46 pm

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

Viewing 15 posts - 9,796 through 9,810 (of 59,091 total)