Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,976 through 3,990 (of 59,087 total)

Reply To: The Great Developer Resignation

skeleton567 wrote:
To Doc, and all of you folks-
Remember this: One day you are going to walk out that door, or some other door, for the last time. The stuff 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 5, 2022 at 7:33 pm

#3980900
Reply To: The Great Developer Resignation

sailtovictory wrote:
I signed up just to comment here.
First, welcome aboard and glad to "meet" ya!
On the rest of it, man, those are always tough realizations. You first have to decide...
--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 7:12 pm

#3980782
Reply To: What am I doing to get this message?

I only get that error occasionally. It may have to do with whether or not someone posted while you were typing or waiting.
There are been times where no matter how...
--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:30 pm

#3980778
Reply To: SSIS Permission - Write File to Shared Folder on Another Server

will299 wrote:
Good one keep it up
Really? What was good about this thread? I could be wrong but I'm thinking that you're just doing a SPAM test. If I am 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)

February 4, 2022 at 6:23 pm

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

Viewing 15 posts - 3,976 through 3,990 (of 59,087 total)