Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,991 through 4,005 (of 59,098 total)

Reply To: Create Index

jihene wrote:
hello ,
i want creat indexs in my base on prod , can i do it when users are connected ans the base is used please ? thank you
"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)

February 4, 2022 at 6:13 pm

#3980772
Reply To: Bulk Insert Failed

water490 wrote:
frederico_fonseca wrote:
Jeff Moden wrote:
water490 wrote:
I used powershell to create a script that prepares the files for bulk insert. it ensures that the columns match with the destination table. works beautifully.
You...
--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 4, 2022 at 5:05 am

#3980589
Reply To: Duplicate Index

Johan Bijnens wrote:
Jeff Moden wrote:
Johan Bijnens wrote:
DBATools.io has a nice function called Find-DbaDbDuplicateIndex (however it has IMHO aflaw and does not report IsUnique for an index, reporting duplicate indexes composed of 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)

February 4, 2022 at 12:42 am

#3980575
Reply To: Bulk Insert Failed

water490 wrote:
I used powershell to create a script that prepares the files for bulk insert. it ensures that the columns match with the destination table. works beautifully.
You mean a poweshell...
--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 4, 2022 at 12:05 am

#3980571
Reply To: The Need for 256GB

To wit... 10GB is only a physical limit. With the likes of Partitioned Views, you can get around that although that might be a good time to try and sell...
--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 4, 2022 at 12:01 am

#3980567
Reply To: how to implement a Multirow insert trigger?
Reddy wrote:
Please Suggest
1. Start a new thread for your particular problem.
2. Post the 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)
February 3, 2022 at 11:57 pm

#3980566
Reply To: UNION ALL with CTE

@jeremyu ,
I'm curious... what is the underlying datatype of the RCLDTE column and what does a good or bad date look like in that column?
Also, are you using the [Saturday]...
--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 3, 2022 at 9:34 pm

#3980552
Reply To: UNION ALL with CTE

jcelko212 32090 wrote:
Yes, and the history table should be a single table with columns that indicate the start and end times of a state of being of the data element being modeled....
--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 3, 2022 at 8:46 pm

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

Sean Lange wrote:
ROFLMAO!!!!! This is exactly why they hired me. They don't even currently have backups, let alone test them. All of their databases are managed solely by their hosting company....
--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 3, 2022 at 8:34 pm

#3980522
Reply To: Bulk Insert Stored Procedure

It's not how you're using it or the fact that supposedly nothing can get to it. Not all attacks are from the outside world and there's no guarantee that someone...
--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 3, 2022 at 7:31 pm

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

Steve Jones - SSC Editor wrote:
Notifications should be working again. I caught this as I was heading out on holiday and filed the issue.
What I got back over the last few days (while gone),...
--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 3, 2022 at 4:15 pm

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

Just a test here... did anyone get an email notification of this post?
--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 3, 2022 at 2:54 pm

#3980458
Reply To: Bulk Insert Failed

frederico_fonseca wrote:
you also can't have extra columns on the destination table
With the understanding that I've not read all the posts in this thread, you actually can. Then you can do...
--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 3, 2022 at 5:55 am

#3980338
Reply To: UNION ALL with CTE

jcelko212 32090 wrote:
The first obvious question is why do you think a current receipt is a totally different kind of data element from a historical receipt?
I guess you've never heard 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 3, 2022 at 5:49 am

#3980336
Reply To: Requesting ideas for articles that might be of interest here

Arun Yadav wrote:
Thanks Jeff and Grant for responding. I now have two articles waiting for Steve's approval.
Don’t know if those will make the cut. Let’s see.
As the old saying goes, "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)

February 3, 2022 at 5:44 am

#3980335

Viewing 15 posts - 3,991 through 4,005 (of 59,098 total)