Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,931 through 3,945 (of 59,087 total)

Reply To: Do You Still Use CHAR?

David.Poole wrote:
BigQuery has a data type called STRING with no size specification.
In Snowflake all text columns are VARCHAR under the hood, including CHAR.
For pure column stores the method of encoding...
--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)

February 11, 2022 at 2:01 pm

#3981909
Reply To: Do You Still Use CHAR?

Sure. I use CHAR. It's all a part of right-sizing data. Such right sizing does some incredible things, not the least of which is preventing the massive page splits and...
--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)

February 11, 2022 at 6:13 am

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

Steve Jones - SSC Editor wrote:
Maybe. I'd like to think that we prevent a posting here, so no one is notified, which should prevent there being two.
I have asked for data analysis of threads...
--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)

February 11, 2022 at 3:54 am

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

frederico_fonseca wrote:
Grant Fritchey wrote:
Thom A wrote:
I feel like that list is proof that Grant and Jeff are the same person, as they have exactly the same amount of subscriptions.
No.
You've got that 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)

February 11, 2022 at 3:45 am

#3981797
Reply To: Requirements doc and interviewing development groups

Jason Wilks wrote:
Unfortunately some of the leaders are saying the dev and design groups are too busy to work much on providing documentation or to concern themselves with the structure 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)

February 11, 2022 at 3:34 am

#3981794
Reply To: group records by week

If you use a compressed backup of a single table database, you wouldn't have to worry about zipping anything and you wouldn't have to worry about doing it in "off...
--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)

February 11, 2022 at 3:26 am

#3981792
Reply To: Stop job after specified run time

kuopaz wrote:
Thanks Grant. I presume there are sys tables for jobs and job activity. Not sure if I then do sp_stop_job or KILL process.
If you stop a job and the actual...
--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)

February 11, 2022 at 3:18 am

#3981788
Reply To: group records by week

Another way of doing it is to create a small special purpose, single table database that you write the "export' data to as a real table. Then do a compressed...
--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)

February 11, 2022 at 3:11 am

#3981786
Reply To: group records by week

p.s. And, the files will be smaller because INTs will actually only take 4 bytes and dates will only take a maximum of 8 and could be as little as...
--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)

February 11, 2022 at 3:08 am

#3981785
Reply To: group records by week

With that thought in mind, I have to ask, why are you messing around with the likes of "CSV" files and PowerShell, etc? It's a simple thing to BCP 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)

February 11, 2022 at 3:03 am

#3981783
Reply To: Breaking Change - Feb 9, 2022

Steve Jones - SSC Editor wrote:
You might be just under the 2k limit. For the most part, this shouldn't be anything you notice, although if someone posted to the 2002nd oldest thread, you just...
--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)

February 11, 2022 at 3:00 am

#3981782
Reply To: group records by week

Bruin wrote:
Did the number of rows per day dictate a certain method for export?
It does, indeed and the import, as well. And, just to be sure, this is a pure...
--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)

February 11, 2022 at 2:55 am

#3981780
Reply To: Duplicate Index

Johan Bijnens wrote:
et voila .... they already fixed it 🙂
Awesome. I'm impressed.
--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)

February 9, 2022 at 5:25 pm

#3981568
Reply To: group records by week

Bruin wrote:
10,000 of thousands I expect for each of the 3 files...
I'm not sure what that means. I just want to know the total number of rows that the entire...
--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)

February 9, 2022 at 5:22 pm

#3981566
Reply To: Fill table cells on ROW info

See the article at the first link in my signature line below. If you were to provide a little readily consumable data as laid out in that article (which 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)

February 9, 2022 at 5:21 pm

#3981564

Viewing 15 posts - 3,931 through 3,945 (of 59,087 total)