Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,081 through 1,095 (of 59,064 total)

Reply To: table with varcahar(max)

IMHO, take the time to force the MAX to be out of row and default the error to an empty string to prevent the pointer from being "expansive". Have max...
--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)

September 22, 2023 at 10:45 pm

#4292155
Reply To: Weekly sales report

pietlinden wrote:
If you're going to do lots of date-related analysis, I'd just create a Calendar table with all the columns you want to group by, and then join to 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)

September 22, 2023 at 4:23 pm

#4291976
Reply To: calculate and decimal

tanehome wrote:
yes, it works.
appreciate your reply.
The question now is, do you understand why the fix worked and why you were getting the original issue?
The other question is, do you know...
--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)

September 21, 2023 at 9:54 pm

#4291331
Reply To: Best CI/CD or release process

Bumping this for you because I'd like to see what other people have to say about this for Database Code.
--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)

September 21, 2023 at 9:52 pm

#4291330
Reply To: Transaction log full due to LOG_BACKUP

On the subject of the backup failure...
IMHO (and experience but YMMV), it's a complete waste of time to backup a 2TB log file (happened to me the 2nd day 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)

September 21, 2023 at 9:43 pm

#4291329
Reply To: Weekly sales report

Next year, the 1st of January occurs on a Monday. What do you want to do with the previous Sunday, which is from the previous year?
--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)

September 21, 2023 at 9:34 pm

#4291328
Reply To: Transaction log full due to LOG_BACKUP

Sorry... posted to the wrong question and removed this post. See the next post down for my answer on this posted problem.
--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)

September 21, 2023 at 9:33 pm

#4291327
Reply To: Interview Questions for Advanced DB Engineer Candidates

David Moutray wrote:
"The damned recruiter gave the candidates both the questions and the answers. I know this because I added a "hairball" question with a totally made up answer and when...
--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)

September 21, 2023 at 7:21 pm

#4291285
Reply To: How Effective Is Your Data Load Monitoring in SQL and Python?

First, nice article. It appears well written, is in a good "order of revelation", and includes the code in an easy to read format. Kudos for all that and thank...
--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)

September 20, 2023 at 10:17 pm

#4290640
Reply To: Blocking Chains and Timing

Duration only identifies how long something has been running. It is possible that a SPID was running something with many queries for a long period and, when it finally got...
--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)

September 20, 2023 at 8:53 pm

#4290604
Reply To: Rebuild index for system database

Somebody wrote:
I would not touch tables in master at all personally. MSDB can get quite large for job history and backup history.
I wouldn't rebuild indexes that don't need it. I'm...
--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)

September 20, 2023 at 8:42 pm

#4290603
Reply To: Provide access to View Vs Tables

Post withdrawn.
--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)

September 20, 2023 at 8:32 pm

#4290601
Reply To: Interview Questions for Advanced DB Engineer Candidates

I've been through that with a recruiter before. The recruiter wanted the questions and the answers so that they could do the filtering.
The damned recruiter gave the candidates both 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)

September 20, 2023 at 7:52 pm

#4290568
Reply To: Interview Questions for Advanced DB Engineer Candidates

With the understanding that this is nothing against you, if we posted such questions and the answers here, that would eventually render them useless in interviews because people will do...
--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)

September 20, 2023 at 4:18 am

#4290023
Reply To: GENERATE_SERIES() Breaks Minimal Logging
Eric M Russell wrote:
Maybe the most efficient way to mockup 100 million rows of randomized test data would be to leverage PowerShell or Python to create text files and then BCP them...
- This reply was modified 2 years, 8 months ago by Jeff Moden.
--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)
September 19, 2023 at 8:11 pm

#4289832

Viewing 15 posts - 1,081 through 1,095 (of 59,064 total)