Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,191 through 5,205 (of 59,089 total)

Reply To: Tables are empty but catalog views show that they have rows

SQL Guy 1 wrote:
Ran it now. Did not help. Also tried DBCC checkdb. Did not help either. In an output message it displayed There are 0 rows in 0 pages for object...
--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)

June 6, 2021 at 12:49 pm

#3892596
Reply To: max recommended file sizes (MDF NDF)

My take is that I'd worry more about splitting tables in a logical fashion that would require no index or statistics maintenance on data that no longer changes.
You might also...
--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)

June 6, 2021 at 12:41 pm

#3892593
Reply To: The NoSQL Misdirections

Sergiy wrote:
In University, you pick up humanitarian subjects, if you're bad at Math.
Pretty much the same situation with NoSQL/SQL.
Right or wrong, I blew coffee out my nose on that one! ...
--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)

June 6, 2021 at 10:55 am

#3892574
Reply To: Load folder full of csv files

Ok... I created a file that had one row for every second of the year 2020 (31,622,400 rows plus the header row and weighs in at 956MB (almost a gigabyte)). ...
--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)

June 5, 2021 at 3:44 am

#3892243
Reply To: how to get the entire sql statement while sql statment is over 4000 characters

I had published an article for doing such a thing and a fellow by the name of Orlando Colamatteo gave me the idea of the following iTVF. ...
--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)

June 5, 2021 at 12:13 am

#3892207
Reply To: Load folder full of csv files

Not yet... It's 1:35 AM and I just got done with a work related crunch. I have to be awake, "lively and aware", for scrum at 9 and so 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)

June 4, 2021 at 5:39 am

#3891798
Reply To: Load folder full of csv files

p.s. Tell me what the various parts of the file name like f300-line1 mean. I have an idea to help with other things that you may not yet be planning...
--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)

June 2, 2021 at 7:44 pm

#3891171
Reply To: Load folder full of csv files

Ok... thanks. I'm at work and have an appointment at 5PM that's going to last for a couple of hours but I'll see what I can do. And, no... 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)

June 2, 2021 at 7:42 pm

#3891170
Reply To: Tables are empty but catalog views show that they have rows

Shot in the dark... have you tried doing a manual CHECKPOINT in the database?
--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)

June 2, 2021 at 5:03 pm

#3891112
Reply To: Load folder full of csv files

Bruin wrote:
I found the problem when data was extracted it was a point in time, and on one of the files the last record was partial written.
Is there any any...
--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)

June 2, 2021 at 4:32 pm

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

Jo Pattyn wrote:
Having a weird case today (still under investigation). Parallel clustered index scan slower dan serial index scan (forced by MAXDOP 1)
*edit* repartition streams spilled to tempdb 🙁 Repartition stream...
--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)

June 2, 2021 at 4:11 pm

#3891104
Reply To: Load folder full of csv files

Bruin wrote:
Sql version is 2012 and the files are named like
f300-line1
Powershell seemed like a easier solution to getting the filename into the table.
Thanks for the information. If you're happy with...
--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)

June 2, 2021 at 4:00 pm

#3891091
Reply To: Back to Basics, Reaching for the Clouds, and Leveling Up

Heh... I hope whoever does the picking has a good sense of humor. I had some serious fun with pronouns and disabilities when I submitted last night. The abstract 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)

June 2, 2021 at 3:24 am

#3890832
Reply To: Load folder full of csv files

Bruin wrote:
I have a folder with csv files that has 2 columns a datetime, and a integer value. I want to load them all to a SQL table, but 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)

June 2, 2021 at 2:26 am

#3890810
Reply To: New line based on fixed characters in a field

As a bit of a side bar, there's little chance that I'd leave such a delimited column in one piece. I'd have split it into separate attribute columns on the...
--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)

June 2, 2021 at 2:22 am

#3890809

Viewing 15 posts - 5,191 through 5,205 (of 59,089 total)