Jeff Moden

Forum Replies Created

Viewing 15 posts - 571 through 585 (of 59,069 total)

Reply To: Are the posted questions getting worse?

Robert Sterbal-482516 wrote:
I sent this post on X:
https://twitter.com/rsterbal/status/1790436470181818647
Robert Sterbal 412-977-3526 call/text
@rsterbal
@redgate Who should I reach out to for issues with the https://sqlservercentral.com forums? Is there a place to post and follow...
--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)

May 14, 2024 at 11:33 pm

#4421327
Reply To: Crazy Interviews

Steve Jones - SSC Editor wrote:
jasona.work wrote:
Jeff Moden wrote:
Heh... GETDATE(). 😀
SELECT SYSDATETIMEOFFSET();
🙂
exec xp_cmdshell('date /t')
😛 It IS a great litmus strip test.

--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)

May 14, 2024 at 8:49 pm

#4421306
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
sales@ or marketing@ might get better traction. We have someone monitoring the webmaster email, but not 100% sure they'd do much more than send the emails to me.
What a...
--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)

May 14, 2024 at 12:18 am

#4421028
Reply To: Script to Merger duplicate indexes

Dennis Jensen wrote:
Really Jeff Moden that would be interesting to read (or see) -- your proof in a presentation -- as I find that a rather interesting stance and would greatly...
--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)

May 13, 2024 at 10:33 pm

#4421019
Reply To: Script to Merger duplicate indexes

Dennis Jensen wrote:
Jeff Moden based on what ScottPletcher stated I do not see how one would end up with 2 Indexes as he did state you Drop one of the Indexes...
--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)

May 13, 2024 at 9:43 pm

#4421007
Reply To: Script to Merger duplicate indexes

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
You don't actually have to drop both indexes. You would, for example, often drop one index and modify the other one.
I've started on code to do this...
--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)

May 13, 2024 at 9:29 pm

#4420999
Reply To: Are the posted questions getting worse?

Bump post to get my message to show up because it's the first post on a new page. 🙁
--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)

May 13, 2024 at 4:41 pm

#4420913
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
@steve-2 :
I guess my question would be, what are the marketing stats for the site? Perhaps a bit of understanding there would help us shape our requests...
--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)

May 13, 2024 at 4:38 pm

#4420912
Reply To: Script to Merger duplicate indexes

As for scripts to "find duplicates", they have this new fangled thing called a "search engine". 😀
Try the following search and see what you come up with. I haven't looked...
--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)

May 13, 2024 at 4:35 pm

#4420911
Reply To: Script to Merger duplicate indexes

ScottPletcher wrote:
You don't actually have to drop both indexes. You would, for example, often drop one index and modify the other one.
I've started on code to do this process but...
--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)

May 13, 2024 at 4:28 pm

#4420908
Reply To: Script to Merger duplicate indexes

EM2 wrote:
Hello,
I am trying to firgure out how to merge duplicate indexes using a script; any help will be greatly appreciated.
You don't. You have to drop both indexes and create...
--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)

May 13, 2024 at 2:26 pm

#4420865
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Back, barely functional after a few airplanes, but I see your complaints and have forwarded them on.
I don't know what I can say or do and I'm fairly frustrated...
--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)

May 13, 2024 at 2:04 pm

#4420861
Reply To: Crazy Interviews

Heh... GETDATE(). 😀
--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)

May 13, 2024 at 1:41 pm

#4420853
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Back, barely functional after a few airplanes, but I see your complaints and have forwarded them on.
I don't know what I can say or do and I'm fairly frustrated...
--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)

May 12, 2024 at 5:45 pm

#4420695
Reply To: Add\Modify Index on Large Table.

MMartin1 wrote:
Jeff Moden wrote:
And, just to assure you this type of thing does work exactly as I've stated (and I'm sure that Eric would agree), I have a 2005 database 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)

May 12, 2024 at 3:04 am

#4420612

Viewing 15 posts - 571 through 585 (of 59,069 total)