Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,371 through 5,385 (of 59,072 total)

Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
I've had a few Kindle devices and I read almost exclusively with the Kindle app on my phone/iPad. I bought one of the first Kindle devices, and 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)

April 16, 2021 at 6:38 pm

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

Brandie Tarvin wrote:
Silly question for you. Why do you need a Kindle device when you could install the Kindle or Nook app on any tablet of your choice?
Nope... 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)

April 16, 2021 at 6:32 pm

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

If you own a Kindle (I don't yet) and read technical books on the subjects of SQL Server and T-SQL, I sure would like to hear from you because 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)

April 16, 2021 at 3:57 pm

#3872075
Reply To: Log Updates To Table

thelenj wrote:
Anyways, I'm open to suggestions. There may be SQL features of which I'm unaware.
My question would be... Does the reviewer need to know which columns actually changed? Do they...
--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)

April 16, 2021 at 3:38 pm

#3872071
Reply To: Transaction log and updates on large tables

ScottPletcher wrote:
(3) SQL does that itself, so that's only a very minor consideration.
I might be misinterpreting what you're saying above but, at face value, I have to ask...
How so? ...
--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)

April 16, 2021 at 2:08 pm

#3872042
Reply To: Columnstore or not to columnstore?

VoldemarG wrote:
Yes, am engaging right now into doing the test you mentioned.
thank you.
I was just attaching the Excel file to answer Jeff's questions.
The testing is a great idea but...
--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)

April 15, 2021 at 9:26 pm

#3871785
Reply To: Columnstore or not to columnstore?

ScottPletcher wrote:
My view is that the vast majority of the time row comp is beneficial, likely 90+%. So I think they're better off always doing it vs never doing...
--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)

April 15, 2021 at 4:36 pm

#3871671
Reply To: Columnstore or not to columnstore?

You're definitely preaching to the choir. What I'm worried about is the wording you used.
Row compression should automatically be used for most tables.
"Should automatically be used" is all that most...
--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)

April 15, 2021 at 4:01 pm

#3871644
Reply To: Columnstore or not to columnstore?

ScottPletcher wrote:
No, it won't use 9 bytes under row compression unless it truly needs all 9 bytes. Row compression should automatically be used for most tables.
While row compression can certainly...
--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)

April 15, 2021 at 2:16 pm

#3871603
Reply To: Columnstore or not to columnstore?

Grant Fritchey wrote:
Jeff Moden wrote:
I have to agree with Frederico. I've had both methods be better than the other. "It Depends".
Yep.
There are trends. More often than not, I see having...
--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)

April 15, 2021 at 1:50 pm

#3871584
Reply To: Splitting a group up into multiple groups using a score....

Heh... I normally avoid helping people with anything having to do with gambling. You seem to indicate that you're making money at it. What's my cut going to be if...
--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)

April 15, 2021 at 1:36 pm

#3871580
Reply To: Always Retry

People REALLY need to read the "A Word of Caution" section at the end of the linked article. I'll also add that if the retry is due to bad 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)

April 15, 2021 at 1:29 pm

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

Lynn Pettis wrote:
Steve Jones - SSC Editor wrote:
How to Get Current Date in SQL Server: https://www.mssqltips.com/sqlservertip/6817/sql-current-date/
Reminded me of some discussions here.
The answer to Jeff's interview question!
I thought the same thing when I read...
--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)

April 15, 2021 at 12:52 pm

#3871568
Reply To: Columnstore or not to columnstore?

I have to agree with Frederico. I've had both methods be better than the other. "It Depends".
--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)

April 14, 2021 at 10:59 pm

#3871278
Reply To: Last day of the previous month - Format MM/DD/YYYY

Lookup the key word CONVERT. You'll need to use the format number of 101.

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

April 14, 2021 at 6:47 pm

#3871206

Viewing 15 posts - 5,371 through 5,385 (of 59,072 total)