Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,521 through 2,535 (of 59,086 total)

Reply To: Losing Skills Because of Automation

I've found that automation isn't the reason for decreased skills. Rather, I've found that automation is necessary because people simply don't have the skills and, apparently, have little interest in...
--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)

November 11, 2022 at 4:01 pm

#4111692
Reply To: SSAS Tabular migration to GCP

squareoff wrote:
We are considering to replace SSAS Server/Tabular Cubes with a denormalized dataset (e.g. materialized view) in BigQuery.
Why? What "magic" do you folks expect to suddenly occur? Stop an think...
--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)

November 11, 2022 at 6:03 am

#4111264
Reply To: Losing Skills Because of Automation

I don't believe that automation is the cause of a lack of skills. I rather think it's the other way around... Automation has become necessary due to a lack 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)

November 11, 2022 at 5:54 am

#4111256
Reply To: Display values from ntext defined field
1. Read the NTEXT into an NVARCHAR(MAX).
2. Use a Tally table function to read each character. If it's not the letters A-Z or a-z or 0-9 or common symbols, then...
--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)
November 11, 2022 at 5:30 am

#4111255
Reply To: How to summarise values in hierarchies

Please see the following article to easily do exactly what you ask.
https://www.sqlservercentral.com/articles/hierarchies-on-steroids-2-a-replacement-for-nested-sets-calculations-1

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

November 11, 2022 at 5:25 am

#4111254
Reply To: Non Clustered Index

IMHO, the best thing said on this thread is...
Grant Fritchey wrote:
Measuring performance before and after the addition of the index and an examination of your execution plans (which are not 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)

November 11, 2022 at 4:20 am

#4111234
Reply To: SSMS csv export file is missing leading zeroes for Numeric data types

squareoff wrote:
Hi Jeff,
Without the leading zeroes (e.g. instead of 0.123 it would show in the .csv file .123), I could not load the file into BigQuery. Import function was giving...
--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)

November 9, 2022 at 9:52 pm

#4110725
Reply To: Remove certain unknown amounts of character from a string

Eirikur Eiriksson wrote:
Have a look at this thread
😎
That's a long thread. You might want to provide the post number for where we ended up on that thread.
--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)

November 9, 2022 at 6:41 pm

#4110668
Reply To: Remove certain unknown amounts of character from a string
If it will always be that you have a non-numeric first character and the rest are numeric, this will work very quickly...
```
 SELECT CONVERT(INT,SUBSTRING(yourstring,2,8000))
```
--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)
November 9, 2022 at 6:40 pm

#4110667
Reply To: SSMS csv export file is missing leading zeroes for Numeric data types

I have to ask... why is it important to have leading zeros on this particular bit of numeric data in the CSV? Or is it not a CSV file after...
--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)

November 9, 2022 at 6:33 pm

#4110666
Reply To: Auto assign Column Data Types for Flat file Source Import

I agree that this is a great solution and some fine "out of the box" thinking for SSIS.
My problem with it all though is, you already know what the definition...
--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)

November 9, 2022 at 3:55 am

#4110319
Reply To: Analyzing a huge ( more than 10600 lines )stoc proc using cte

Peel one potato at a time. Like Ratbak suggests above, it will require a "Diligent Data Engineer". One of the best things to make as you go along, is 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)

November 9, 2022 at 3:43 am

#4110317
Reply To: DevOps is Culture

Eric M Russell wrote:
DevOps is a collection of tools and processes for deploying code.
IMHO... that's what the word has come to mean but not for me. You can have all the tools...
--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)

November 8, 2022 at 6:59 pm

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

I'm thinking that they've stretched Steve a bit too far... I can't even get an acknowledgment to the two emails that I've sent the WebMaster about the email notifications.
--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)

November 7, 2022 at 7:22 pm

#4109744
Reply To: DevOps is Culture

I guess DevOps has degraded to the point where you can't even get an acknowledgement to a site problem sent to the WebMaster because there's too much DevOps going on,...
--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)

November 7, 2022 at 7:15 pm

#4109743

Viewing 15 posts - 2,521 through 2,535 (of 59,086 total)