Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,681 through 1,695 (of 59,082 total)

Reply To: SSDT import into a table from .csv corruption

atzvei wrote:
I am not sure what the numbers table is.
In SQL Server 2022, it would be the "GENERATE_SERIES()" function.
atzvei wrote:
Hw can I remove the extra lf or cr during or...
--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)

March 29, 2023 at 6:20 pm

#4166781
Reply To: Importing 7.4gb csv ssis

Kev Wisbey-443237 wrote:
Thanks everyone. I passed on suggestions up the food chain but they decided to let it run, 7 hours later...........
I agree with the others... they're doing something seriously wrong. ...
--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)

March 29, 2023 at 5:50 pm

#4166766
Reply To: Usage of #TempTables and an Index in Stored Procedure

ScottPletcher wrote:
The DBA's right about the concurrency issue.
Please be specific as to what kind of blocking occurs and how long it actually lasts.
Then, let's see some proof or an article...
--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)

March 29, 2023 at 3:51 pm

#4166705
Reply To: Importing 7.4gb csv ssis

daytonbrown2 wrote:
If you are familiar with SSIS, then use that. According to MS and others, SSIS is actually faster than BCP. Although, I've never fully tested myself. That being said,...
--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)

March 28, 2023 at 10:48 pm

#4166189
Reply To: script to find the frequent used login information in the sql

pols wrote:
Hi,
Kindly some one share the script or query to get the login information used for the sql database in the instance.
InstanceName,DatabaseName,HostName,LoginName,Program,date used etc
Thanks,
Jo
Why? What actual problem are you trying...
--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)

March 28, 2023 at 5:49 pm

#4166109
Reply To: Importing 7.4gb csv ssis

Kev Wisbey-443237 wrote:
I am tasked with writing a package to import a series of files. One of the files is 7.4gb and has 229 columns (look I didn't design this). From...
--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)

March 28, 2023 at 5:09 pm

#4166098
Reply To: how to write a query by using some filter patterns in SQL Server?

Everybody wants to search for things like Google does. Go buy a product that will do this for you in SQL server... it'll be cheaper that you trying to build...
--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)

March 28, 2023 at 1:57 am

#4165755
Reply To: Grouping the first letter in a string

sathishkm wrote:
This was the error message
Msg 8144, Level 16, State 3, Line 12 Procedure or function string_split has too many arguments specified.
Completion time: 2023-03-24T13:47:00.0877172+05:30
That probably means that you're not actually...
--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)

March 24, 2023 at 5:13 pm

#4164683
Reply To: How do you Sprint?

Johan Bijnens wrote:
What I "love" about these scrum sprint agile and the newer cicd developments is that most managers think it will speed up their sloppy work.
They still don't have 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)

March 24, 2023 at 12:55 am

#4164367
Reply To: index analysis help

Go to the following URL. Read the post and watch the movie.
https://www.brentozar.com/blitzindex/

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

March 23, 2023 at 10:48 pm

#4164345
Reply To: Query based on sorting based on month
Phil Parkin wrote:
Also, why not just use
ORDER BY BusinessEntityID, OrderDate
?
It might perform better.
+1000
--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)
March 22, 2023 at 4:16 pm

#4163783
Reply To: How do you Sprint?

I'm the same way. I've been at the same place coming up on 12 years. Great people, interesting work, good pay and bennies, a commute that I could make on...
--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)

March 21, 2023 at 9:00 pm

#4163444
Reply To: How do you Sprint?

I feel your pain. This is micromanagement at its worst. Personally, I won't row to the sound of a beating drum, the cadence of which has been created by people...
--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)

March 21, 2023 at 4:30 pm

#4163356
Reply To: Indexing Tables

water490 wrote:
I have a script that was running fine but today it is taking way too long. I looked at the script and I see these errors:
"cannot specify included columns...
--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)

March 21, 2023 at 3:42 pm

#4163342
Reply To: Data Problem
ratbak wrote:
```
where Date From >=  '2020-04-01'  and  Date To <= '2020-04-28'
```
There is no data in your sample that meets that requirement.
In
```
2  ----- 2020-04-01 -----...
```
--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)
March 21, 2023 at 3:29 pm

#4163336

Viewing 15 posts - 1,681 through 1,695 (of 59,082 total)