Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,386 through 5,400 (of 59,089 total)

Reply To: Archiving data to a read only file

If no one is allowed to read it, it might as well be compressed so it doesn't take as much room so I agree with Grant's suggestion of converting it...
--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 19, 2021 at 11:55 am

#3873006
Reply To: how checksum works?
892717952 wrote:
1. Could you please me how checksum work in the SQL statement ? below is an example.
SELECT * FROM Tablename1 WHERE CHECKSUM(*)
NOT IN (SELECT CHECKSUM(*) FROM TableName2)
2. and there is...
--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 18, 2021 at 5:15 pm

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

Jeff Moden wrote:
ScottPletcher wrote:
Jeff Moden wrote:
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...
--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 18, 2021 at 1:27 pm

#3872697
Reply To: Things We Are Missing

I believe that what's missing can be described by a single word...
SERENDIPITY : The occurrence and development of events by chance in a happy or beneficial 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)

April 17, 2021 at 2:30 pm

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

ScottPletcher wrote:
Jeff Moden wrote:
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...
--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 7:09 pm

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

Great info. Thanks, Brandie.
--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 7:02 pm

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

Michael L John wrote:
Jeff Moden wrote:
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...
--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:40 pm

#3872135
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

Viewing 15 posts - 5,386 through 5,400 (of 59,089 total)