Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,766 through 3,780 (of 59,087 total)

Reply To: How to Decipher @@Options

@jonfrisbee ,
I can't fault someone that took the time to write an article to help others. Hat's off to you for that. But have a look at the way Des...
--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)

March 22, 2022 at 2:34 am

#4003824
Reply To: How to Decipher @@Options
DesNorton wrote:
All of those UNIONs are creating an insane query plan.
The following code will produce almost the same result, with a MUCH better query plan.
```
DECLARE @options int...
```
--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)
March 22, 2022 at 2:26 am

#4003822
Reply To: How to Decipher @@Options

jdvenice wrote:
Also... Over the years, I've used spt_values to get at lots of cool information. Of course, Microsoft threatens to drop this table... (for the last 20 years... 🙂 )
See...
--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)

March 22, 2022 at 2:19 am

#4003821
Reply To: SQL Select date

With apologies to Calendar Table Lovers, I've grown to hate Calendar tables unless they're absolutely necessary (which is not the case here) because of their tendency to kill performance. I'd...
--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)

March 22, 2022 at 2:03 am

#4003819
Reply To: Split string from SQL procedure results

Even I don't try to "split" address. My recommendation would be for you to buy some C.A.S.S. Certification software. You spend less money than you will trying to develop something...
--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)

March 22, 2022 at 1:15 am

#4003807
Reply To: Is CosmosDB the One?

larry.blake wrote:
About Fusion restaurants: it's pretty rare for them to do everything (or even most things) at a master chef level.
I've never worked with CosmosDB, so I don't speak from...
--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)

March 22, 2022 at 1:00 am

#4003805
Reply To: Looking to help DBA's and learn some SQL Server skills

wrote:
Knowledge of SQL is not enough to secure most DBA jobs. Established companies prefer to hire someone with a degree in a computer science field, experience and knowledge 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)

March 21, 2022 at 5:25 pm

#4003595
Reply To: Is CosmosDB the One?

From the Article:
"I'd love to be able to insert data into a table, have it not available as a live value until committed on other nodes, and avoid locking...
--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)

March 21, 2022 at 2:49 am

#4002918
Reply To: Create multiple zip files

Eirikur Eiriksson wrote:
Bruin wrote:
I have found many examples how to zip ziles, but is there native to P/S how to create multiple zip files based upon a parm to split them...
--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)

March 21, 2022 at 2:14 am

#4002915
Reply To: Create multiple zip files

Bruin wrote:
I have found many examples how to zip ziles, but is there native to P/S how to create multiple zip files based upon a parm to split them based...
--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)

March 19, 2022 at 6:07 pm

#4002521
Reply To: Looking to help DBA's and learn some SQL Server skills

With the understanding that there are many dialects of "SQL" and that (especially) functions and the UPDATE statement vary widely in MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres,...
--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)

March 19, 2022 at 5:40 pm

#4002489
Reply To: Importing Data from CSV of a different server

I agree with Phil. You can kick your own butt if you want (heh... I've got a sore butt from doing the same) but you learned something different and then...
--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)

March 18, 2022 at 10:38 pm

#4002130
Reply To: Like Post Change

I'm thinking that they broke something in the process. I get the load failure in the light pink strip even on this very post and every post. So far as...
--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)

March 18, 2022 at 10:31 pm

#4002112
Reply To: Change the numeric format into 'AM/PM' format in CONCAT / MAX (sql)

Just in case there are any doubters, here's the code to build a 10 million row test table... don';t let that scare you. It takes a little over 5 seconds...
--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)

March 18, 2022 at 6:58 am

#4001774
Reply To: Change the numeric format into 'AM/PM' format in CONCAT / MAX (sql)

JeremyU wrote:
I need to change the numeric format into 'AM/PM' format in CONCAT function (I use SSMS v 18.5.1)
Here is my formula. RCLDTE - is a date and RCLTIM is...
--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)

March 17, 2022 at 9:00 pm

#4001565

Viewing 15 posts - 3,766 through 3,780 (of 59,087 total)