Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,491 through 8,505 (of 59,072 total)

Reply To: Laptop Recommendations for 2019

Y.B. wrote:
EDIT: I also wanted to mention that having a full size keyboard with a seperate number pad makes such a huge diffierence in comfort and convenience.
Totally agreed, there. That's...
--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)

October 24, 2019 at 1:44 pm

#3691623
Reply To: Laptop Recommendations for 2019

sqlman63 wrote:
Jeff,
I bought my Alienware 17 back in 2014, and lately (past 2 months) it's gotten a little unstable, I think it's time for a hardware refresh but up until...
--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)

October 24, 2019 at 1:40 pm

#3691621
Reply To: Laptop Recommendations for 2019

MVDBA (Mike Vessey) wrote:
just out of interest.... does anyone miss having a dvd drive in their laptop?
I'm travelling now, and I have a Netflix subscription, but no signal - I used 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)

October 24, 2019 at 1:34 pm

#3691620
Reply To: Dynamic Partitions for Flight Data

You'll actually get better overall performance if you define the clustered index on the empty table and then populate it with proper minimal logging techniques. You'll save a wad 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)

October 24, 2019 at 3:23 am

#3691509
Reply To: Briefcase Missing Old Functionality

Well... it's partially there. Lot's of posts I'd saved are missing from my briefcase so still not trusting it anymore.

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

October 23, 2019 at 9:43 pm

#3691469
Reply To: Briefcase Missing Old Functionality

Well, lookie there... I've not checked my briefcase since I first discovered that everything was missing. It would appear that they fixed it somewhere along the lines. I agree 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)

October 23, 2019 at 9:36 pm

#3691468
Reply To: Briefcase Missing Old Functionality

I know it doesn't help but the new site killed everything that I had in my old brief case. I've given up saving anything I want to keep.
--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)

October 23, 2019 at 9:34 pm

#3691467
Reply To: remove double quotes from file ssis- azure

Thanks for the great feedback and the very kind words, Phil. Good to know this stuff from someone using it. I've not had the opportunity to even dip my toe...
--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)

October 23, 2019 at 7:40 pm

#3691442
Reply To: Laptop Recommendations for 2019

I only buy new hardware every 8 years or so. When I do, I tend to go with something that's going to last quite a while. This time, it wasn'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)

October 23, 2019 at 7:23 pm

#3691435
Reply To: remove double quotes from file ssis- azure

Thanks, Phil. I really appreciate your feedback on these types of things.
As a bit of a side bar, how do you like that new Azure ETL tool? Does it have...
--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)

October 23, 2019 at 3:53 pm

#3691384
Reply To: Is SSIS really that bad?

DinoRS wrote:
Plus to all the "TSQL Only" experts here:
Care to know out of your head how to do something like this(see attachment)? Because I don't and it's a quick way...
--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)

October 23, 2019 at 3:47 pm

#3691383
Reply To: remove double quotes from file ssis- azure

@Phil...
As you know, I'm not a great study of SSIS or Azure and so I have to ask... for something like this (consistent use of delimiters and text qualifiers), it's...
--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)

October 23, 2019 at 1:51 am

#3691178
Reply To: remove double quotes from file ssis- azure

Phil Parkin wrote:
Azure Blob Source does not supports multiple-character delimiter.
Nit-picking a little, but the delimiter is only a single comma. The double quotes are text qualifiers.
Now I don't feel so bad...
--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)

October 23, 2019 at 1:47 am

#3691176
Reply To: Transaction log full but TL backups is is just 8KB

Have you checked to see if you actually do have an open transaction on the database? And, yeah... I agree with Steve T in his suggestion. I've not had 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)

October 23, 2019 at 1:31 am

#3691175
Reply To: Alternate to temporary table in azure sql

While you're at it, don't forget to store a date with the age so that you can estimate the actual age in the future. You might want to consider further...
--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)

October 23, 2019 at 1:21 am

#3691173

Viewing 15 posts - 8,491 through 8,505 (of 59,072 total)