Jeff Moden

Forum Replies Created

Viewing 15 posts - 136 through 150 (of 59,099 total)

Reply To: Creating a Date Dimension (Calendar Table) in SQL Server

It would appear that most of the code has simply been stolen from the following article...
https://www.mssqltips.com/sqlservertip/4054/creating-a-date-dimension-or-calendar-table-in-sql-server/

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

April 14, 2025 at 9:34 pm

#4578965
Reply To: Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)

Lordy... I missed your post above, Ron. Great tip. Thanks for posting it and sorry for it taking me nearly two years to acknowledge it.
To add to your good information,...
--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)

April 13, 2025 at 2:31 pm

#4578415
Reply To: Elements of the SQL Server Update Statement

Gosh... SQL Server, MySQL, PostgreSQL, and (finally after decades of not) even Oracle has the ability to do JOINed updates. Consider resubmitting this article with that critical functionality so 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)

April 11, 2025 at 5:01 pm

#4577528
Reply To: Unreliable Narrators

kevin77 wrote:
Eric M Russell wrote:
What we really need is to just stop calling it AI.
Nah... "AI" is the perfect abbreviation but people need to be aware of what it really stands 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)

April 10, 2025 at 1:47 am

#4576381
Reply To: create a table with data capture for next 3 years

This sounds like a good place for monthly partitions. The monthly switch out takes nearly zero time or resources and then the switched out part can just be dropped as...
--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)

April 7, 2025 at 6:47 pm

#4574747
Reply To: Sever Migration

Seems to me that the online documentation should be a better help for 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)

April 7, 2025 at 5:13 pm

#4574704
Reply To: Using Feature Flags

David.Poole wrote:
I
Most of our infrastructure is IAC delivered by a pipeline.
Apologies for not knowing but what does "IAC" stand for in this context?
--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)

April 7, 2025 at 4:51 pm

#4574682
Reply To: Create Raw Zone Tables using Generative AI: The Fabric Modern Data Platform

In my quick look at your article this morning, I may have missed it... are you using the paid version for ChatGPT?

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

April 2, 2025 at 1:54 pm

#4571934
Reply To: Is GenAI Coming Faster Than You Think?

I love how people tip-toe around this subject. Oh... it's not going to eliminate DBA jobs... we'll just be able to get along with 3 people instead of 5 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)

March 31, 2025 at 3:27 am

#4570499
Reply To: Index Fragmentation

If you're going to start talking about Random GUIDs (uniqueIdentifier type not using NEWSEQUENTIALIUD()), then you absolutely MUST watch the following video, which proves that what most people think they...
--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)

March 31, 2025 at 1:31 am

#4570469
Reply To: Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions

I wonder what the "compute cost" of these new functions is?
--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)

March 28, 2025 at 11:14 pm

#4569564
Reply To: Improving the Performance of UPDATE Statements in SQL Server

Noman072 wrote:
Thanks for your comments. I understand your points and I would like to clarify a couple of things.
Regarding the execution time difference, batch updates are faster because they reduce...
--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)

March 27, 2025 at 1:01 am

#4568179
Reply To: The Table Backup

Carlo Romagnano wrote:
uhm, what about "Temporal tables"?
"Temporal tables" do not need to be backed up and restored, you can see values in the "past" and restore them with a query.
So drop...
--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)

March 24, 2025 at 5:25 pm

#4566539
Reply To: SQL Server Maintenance Plan Feedback

To be honest, I'd delete the REORGANIZE job and disable the REBUILD job. Microsoft finally took down the 5/30 supposed "Best Practices" on 20 April 2021 and a lot of...
--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)

March 24, 2025 at 5:20 pm

#4566537
Reply To: Server Role for User Database Access

ScottPletcher wrote:
Add that user to the "model" db -- with whatever permissions you want -- and they will automatically be added to every new db.
Ditto 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)

March 20, 2025 at 1:59 pm

#4563822

Viewing 15 posts - 136 through 150 (of 59,099 total)