Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,946 through 3,960 (of 59,067 total)

Reply To: CPU

I'd help on the hardware side of things but I'm not a hardware kind of guy anymore. I did see that your choices may be even more complex because there's...
--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 6, 2022 at 2:38 pm

#3980961
Reply To: CPU

water490 wrote:
Hi everyone
I am in the market for a new computer. I have been comparing various Xeon processors and I am a bit confused by a few things. Intel lists...
--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:55 pm

#3980906
Reply To: Saving changes is not permitted

Also, you should save yourself some time. USE the search engines for nearly instant answers especially when it comes to such error messages. This one only required the few words...
--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:53 pm

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

skeleton567 wrote:
Jeff Moden wrote:
I only get that error occasionally. It may have to do with whether or not someone posted while you were typing or waiting. Ok... just remembered who 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)

February 5, 2022 at 7:50 pm

#3980904
Reply To: Saving changes is not permitted

To add to what Frederico posted, here's how you change the setting...
In SSMS, click on {Tools}{Oprionts} in the menu. Scroll down to {Designers} and expand it. Then click on {Table...
--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:40 pm

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

Viewing 15 posts - 3,946 through 3,960 (of 59,067 total)