Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,571 through 3,585 (of 59,087 total)

Reply To: most efficient way to compare columns across separate tables

What is the primary key on these tables? And, are you really using 2019? If not, what version?
--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)

May 2, 2022 at 11:48 pm

#4025714
Reply To: Downgrade SQL Server 2016 from Enterprise to Standard

Did you look?
https://www.google.com/search?q=downgrade+sql+server+enterprise+edition+to+standard+edition

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

May 2, 2022 at 11:40 pm

#4025713
Reply To: RAM increase on server and sql instance

What size is your largest index, what Recovery Model are your databases in, and what, if any, index maintenance do you 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)

May 2, 2022 at 10:21 pm

#4025689
Reply To: How to add background color of row based to existing SP/query

SQLisAwe5oMe wrote:
Thank you Jeff, this is helpful.
You bet... thank you for the feedback. It also has one of the (IMHO) better SQL Tutorials (Not to mention the HTML and other...
--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)

May 2, 2022 at 7:15 pm

#4025633
Reply To: How to add background color of row based to existing SP/query

Phil Parkin wrote:
Jeff, that's a rather useful link, thanks for posting.
Thanks for the feedback on that, Phil. I LOVE that site. T It also has one of the better beginner SQL...
--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)

May 2, 2022 at 7:12 pm

#4025632
Reply To: Parse txt file

Bruin wrote:
Can't seem to get original file to process gets errors listed above.. sample file will process.
Any thoughts or suggestions?
Thanks again

Instead of making us go back an unknown number 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)

May 2, 2022 at 6:02 pm

#4025595
Reply To: How to add background color of row based to existing SP/query

I try to avoid the RGB notation because it makes troubleshooting a whole lot more difficult. If you go to the following link...
https://www.w3schools.com/tags/ref_colornames.asp
... and do a search for the #90EE90...
--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)

May 2, 2022 at 6:00 pm

#4025593
Reply To: Parse txt file

Ok... no actual data. Moving on. Good luck. 😉
--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)

April 30, 2022 at 4:48 am

#4024590
Reply To: Getting rid of integers from the EmailAddress

How about it @Smash125? Why do you need this top be done?
--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)

April 29, 2022 at 11:17 pm

#4024474
Reply To: Getting rid of integers from the EmailAddress

Again, I'd like to know why we're perverting email addresses in such a fashion. There has to be a reason.
--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)

April 29, 2022 at 7:49 pm

#4024407
Reply To: Output of Pivot table in temp table
jsshivalik wrote:
Hi Thom
First i get data saved in Temp table like below
```
CodeNameQuantityDscription
32Rohan1        Item 1
32Rohan2      ...
```
--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)
April 29, 2022 at 7:44 pm

#4024406
Reply To: Parse txt file

Some real or better-simulated data for the file is absolutely necessary for us to help you here or the answer will be either to create a BCP format file 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)

April 29, 2022 at 5:55 pm

#4024371
Reply To: Date strange Behaviour

To go along with what Scott stated, when is the last time you rebuilt statistics on the date column? How many rows have been changed according to the modification_counter column...
--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)

April 29, 2022 at 5:50 pm

#4024370
Reply To: Getting rid of integers from the EmailAddress

Smash125 wrote:
How to remove integers from the Email Id
aaron0@adventure-works.com
Please guide
WHY???? It seems to me that you're removing a necessary part of a correct email address. 🙁
--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)

April 29, 2022 at 5:02 pm

#4024337
Reply To: Script SQLCMD to create DB with a variable: How to set it up?

I have the same concerns about a PoSh script as I do with an SQLCMD script.
--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)

April 29, 2022 at 4:56 pm

#4024335

Viewing 15 posts - 3,571 through 3,585 (of 59,087 total)