Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,061 through 9,075 (of 59,091 total)

Reply To: The SQL Saturday Thread

I've been accepted to speak at Providence, RI this year. I'm presenting "Black Arts" Index Maintenance parts 1 & 2.
https://www.sqlsaturday.com/892/Sessions/Schedule.aspx
As a bit of a side bar, it'll be interesting...
--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)

July 12, 2019 at 3:22 pm

#3662420
Reply To: Is SSIS a dinosaur in Modern ETL?

KJKKPSI wrote:
Thank you all for the responses. I am a big supporter of staying within the MS stack and taking the natural migration to Azure, but there is a major...
--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)

July 12, 2019 at 2:30 pm

#3662405
Reply To: Is SSIS a dinosaur in Modern ETL?

David Burrows wrote:
Jeff Moden wrote:
The only exception is for daily transfer of 40GB in 140 KISAM files from a third party system and found SSIS the fastest method.
I don't know 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)

July 12, 2019 at 2:14 pm

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

TomThomson wrote:
below86 wrote:
I've been working with a young developer for over a year on trying to get her to format any SQL she writes, SSIS or SSRS packages. Since I...
--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)

July 11, 2019 at 7:12 pm

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

TomThomson wrote:
Jeff Moden wrote:
TomThomson wrote:
Grant Fritchey wrote:
Chris Harshman wrote:
I don't trust anyone... not even myself! 🙂
My name is Grant Fritchey and I endorse this message. Except I'd change it slightly: I don't...
--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)

July 11, 2019 at 7:08 pm

#3662149
Reply To: Is SSIS a dinosaur in Modern ETL?

KJKKPSI wrote:
whereas a move to Talend would allow non-developer staff to handle integration task more easily due to it's drag and drop interface.
THAT RIGHT THERE is a very strong reason...
--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)

July 11, 2019 at 3:28 pm

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

p.s. Venting is good... being old, I can tell you, it keeps you from farting so much. 😀
--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)

July 11, 2019 at 3:17 pm

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

below86 wrote:
I've been working with a young developer for over a year on trying to get her to format any SQL she writes, SSIS or SSRS packages. Since I 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)

July 11, 2019 at 3:16 pm

#3662008
Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop

david.holley wrote:
Don’t make me post some examples. The issue isn’t so much the implicit join but rather understanding the criteria in the WHERE statement when it contains the join 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)

July 11, 2019 at 2:03 am

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

TomThomson wrote:
Grant Fritchey wrote:
Chris Harshman wrote:
I don't trust anyone... not even myself! 🙂
My name is Grant Fritchey and I endorse this message. Except I'd change it slightly: I don't trust anyone......
--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)

July 11, 2019 at 1:56 am

#3661821
Reply To: Filegroups, data files best practices?

Lordy. I, unfortunately, found what I was looking for at item #12 at the following URL...
https://www.mssqltips.com/sqlservertip/1875/best-practices-when-using-filestream-feature-of-sql-server/
... which states...
Disable antivirus software from scanning FILESTREAM volumes if it's not mandatory within...
--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)

July 11, 2019 at 1:18 am

#3661817
Reply To: Filegroups, data files best practices?

Never mind... I looked it up. It would appear that if you allow it, the files become a part of the backups... basically, using SQL Server to backup part 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)

July 10, 2019 at 11:58 pm

#3661798
Reply To: Filegroups, data files best practices?

Grant Fritchey wrote:
My experience with, and knowledge, filestream is somewhat limited, so I'm hesitant to pronounce too strongly on this approach. I do know that files within databases leads to all...
--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)

July 10, 2019 at 11:41 pm

#3661791
Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop

david.holley wrote:
Young man (or woman), Implicit joins are evil. Always. Even in examples or practice exercises. Repent of your wicked ways.
BWAAA-HAAAA!!!!! Someone needs to tell MS that. Properly written correlated...
--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)

July 10, 2019 at 11:28 pm

#3661786
Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop
tom 69406 wrote:
A minor point I came across today - your "favourite way" to produce the Tally table does not work in an Azure database:
```
SELECT TOP 11000 --equates...
```
--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)
July 10, 2019 at 11:11 pm

#3661783

Viewing 15 posts - 9,061 through 9,075 (of 59,091 total)