Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,231 through 1,245 (of 59,065 total)

Reply To: Combine DATE and TIME to DATETIME2 in SQL Server

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Jonathan AC Roberts wrote:
Eirikur Eiriksson wrote:
Given that the data type is DATETIME2(7), we can assert the following: The DATE data type is 3 Bytes big-endian, the TIME(7) is 6 Bytes...
--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)

August 8, 2023 at 12:54 am

#4255386
Reply To: Combine DATE and TIME to DATETIME2 in SQL Server

Jonathan AC Roberts wrote:
Eirikur Eiriksson wrote:
Given that the data type is DATETIME2(7), we can assert the following: The DATE data type is 3 Bytes big-endian, the TIME(7) is 6 Bytes big-endian 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)

August 7, 2023 at 11:04 pm

#4255346
Reply To: How to read data from database db2 on sql server 2017 ?
We use the following providers for linked servers and use OPENQUERY, which proved much faster than OPENROWSET (with the disclaimer that check was made years ago). This allows the query...
- This reply was modified 2 years, 9 months ago by Jeff Moden. Reason: just realized you specified "No Linked Server" in your post
--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)
August 7, 2023 at 9:10 pm

#4255264
Reply To: Combine DATE and TIME to DATETIME2 in SQL Server

@Eirikur,
The "Human Factor" is why I value QA Testers so much (and, MAN! They taught me how to anticipate user actions, also known politely as "Human Factors"). In this case,...
--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)

August 7, 2023 at 6:04 pm

#4255131
Reply To: Combine DATE and TIME to DATETIME2 in SQL Server

Eirikur Eiriksson wrote:
Thanks, Jeff for this very good writeup (as always)! 😎
Just a quick point, DATETIME2 is defaulted to DATETIME2(7), not considered the same data type as DATETIME2(<>7), same goes with...
--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)

August 7, 2023 at 3:08 pm

#4255007
Reply To: Combine DATE and TIME to DATETIME2 in SQL Server
w1tchf1nd3r wrote:
Thanks for the interesting post!
Could you explain the why varbinary is used for the time but binary is used for the date? I tried using binary for both (albeit...
- This reply was modified 2 years, 10 months ago by Jeff Moden. Reason: Add conclusion for addition testing done
- This reply was modified 2 years, 10 months ago by Jeff Moden. Reason: Added note about why DATE wasn't converted using a VARBINARY()
--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)
August 7, 2023 at 3:04 pm

#4255006
Reply To: Run Stored Procedure on the first Monday if each month of Tues if Mon Holiday

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
My other feeling was that having it run multiple times (2, 3, 4?) at the start of the month could be deceptive / confusing to people looking...
--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)

August 7, 2023 at 6:27 am

#4254622
Reply To: Run Stored Procedure on the first Monday if each month of Tues if Mon Holiday

ScottPletcher wrote:
My other feeling was that having it run multiple times (2, 3, 4?) at the start of the month could be deceptive / confusing to people looking at 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)

August 6, 2023 at 5:55 pm

#4254255
Reply To: Small Changes, Big Results

I agree.. small changes in knowledge are easier to learn and remember than trying to learn everything at once. I've also learned that, instead of learning how to solve 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)

August 6, 2023 at 5:30 pm

#4254245
Reply To: Best way to track what user/logins are accessing a linked server

I Googled the following...
What is the best way to track down what users\logins are accessing my linked servers in sql server?
It came up with a lot of answers. Just 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)

August 6, 2023 at 5:14 pm

#4254242
Reply To: Why would user account authentication issues arise in Azure?

I think all of this cloud stuff is a bit odd. It's actually very old thinking. Remember when people thought you were stupid if you didn't "decentralize" so that 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)

August 3, 2023 at 6:14 pm

#4252139
Reply To: Best way to handle incremental duplicate data in SQL Server?

SCDs (specifically, type 6 Slowly Changing Dimensions) would work the best. One of the better SCD methods is System Versioned Temp Tables.
https://en.wikipedia.org/wiki/Slowly_changing_dimension
I would avoid the use of a simple "IsCurrent"...
--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)

August 2, 2023 at 11:37 pm

#4251426
Reply To: Ola Index Maintenance won't work on msdb

Just posting so Michael's post above will show up. This site won't show a single post on page 2. I really wish they'd fix 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)

August 2, 2023 at 8:55 pm

#4251330
Reply To: Constitutional AI

After reading this, I had this vision of the very old "graphic" of a snake eating its own tail.

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

August 2, 2023 at 6:43 pm

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

Steve Jones - SSC Editor wrote:
I hate rebrands/renames. I think it creates confusion and often doesn't make anything better. Either you execute well or you do not and people know that, regardless of name.
However,...
--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)

August 1, 2023 at 6:54 pm

#4250338

Viewing 15 posts - 1,231 through 1,245 (of 59,065 total)