Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,541 through 3,555 (of 59,067 total)

Reply To: Voting for Sessions on GroupBy.Org closed and schedule published!

Heh... right after I posted above, I got an email from GROUPBY.Org that the schedule has been published. There are two tracks for the Americas on May 24th and two...
--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 4, 2022 at 5:33 pm

#4026801
Reply To: Voting for Sessions on GroupBy.Org closed and schedule published!

My "Black Arts" Index Maintenance 1.2 presentation was selected on GroupBy.Org for May 24th, 2022. I don't know if my "ask" above had anything to do with that but I...
--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 4, 2022 at 5:21 pm

#4026762
Reply To: Case When statement When I assign a string, it say Conversion Failed from varcha

First of all, you didn't actually post the error you're getting.
Second, what are the datatypes for all of the columns involved"? That's actually super important to know here.
--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 4, 2022 at 3:56 pm

#4026721
Reply To: case when with count ms sql
Here's another way to post "Readily Consumable Date" followed by a different solution that uses the SUM() Windowing Function.
Here's the test data construction...
```
--===== Create the test 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)
May 4, 2022 at 3:44 pm

#4026718
Reply To: case when with count ms sql

TheNewbie wrote:
Honestly, I don't end up with the #t, ct etc.
I tried to replace anything regarding my data but didnt work
Sorry
The #t that Phil is using is what you should...
--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 4, 2022 at 3:24 pm

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

Viewing 15 posts - 3,541 through 3,555 (of 59,067 total)