Jeff Moden

Forum Replies Created

Viewing 15 posts - 661 through 675 (of 59,091 total)

Reply To: Create list of random, mutually exclusive selection(s) from the same table

Steve Collins wrote:
Excellent query Jeff. Thank you, thank you! Multiplying by 'combo' within the TOP clause is very nice
Thanks for the feedback, Steve. The hard part was to make "Combo" available...
--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 9, 2024 at 12:08 pm

#4409192
Reply To: Designing two tables considering following scenario.

You working code link leads to a "Run this fiddle" link. I cancelled from there.

--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 9, 2024 at 12:06 pm

#4409190
Reply To: Tunning or alternative to PIVOT

Since you posted a graphic of the execution plan instead of an actual execution plan and you post no meta-data for the table and you posted no code, we're going...
--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 9, 2024 at 11:55 am

#4409176
Reply To: Create list of random, mutually exclusive selection(s) from the same table
The correct term is "PFM". 🙂
```
   WITH cteCombo(Combo) AS (SELECT TOP 1 is_combinable FROM #project_types ORDER BY NEWID())
 SELECT  project_types_ = string_agg(ca.project_type, N', ')
...
```
--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 9, 2024 at 12:43 am

#4408963
Reply To: Query wont use any index - Cannot understand why

Martass wrote:
but most of the clients wants also using Manually written SQL statements using a functions we call "AdHoc Query" which basically sends the text as Query, and they can...
--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 2, 2024 at 5:51 pm

#4406545
Reply To: Database Mirroring is Back in Azure SQL Database

Remember the company that we're talking about...
It's the company that couldn't see the benefit of a series generator for more than 15 years and, when they finally did release it,...
--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 30, 2024 at 3:07 pm

#4405052
Reply To: Tracking Database Growth - Script Automation & Reporting

I've not used or done a deep review of the article at the following link but, at a 60,000 foot level, it seems like it may be one 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)

March 30, 2024 at 2:08 am

#4404809
Reply To: Running a New Query and it is Giving me an error that I cannot find in the data

Thanks for posting your discovery, Mark.
--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 30, 2024 at 12:37 am

#4404786
Reply To: Query performance analysis

Thanks for the feedback.
--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 28, 2024 at 9:10 pm

#4404055
Reply To: Query wont use any index - Cannot understand why

Martass wrote:
Well, I am always using the execution plan, so I can understand what's happening, which indexes are used, which are not and I see the suggestions, but I have...
--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 28, 2024 at 7:07 pm

#4403955
Reply To: Query wont use any index - Cannot understand why

"Bumping" this thread so the first 2nd page post above shows up.

--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 28, 2024 at 6:20 am

#4403604
Reply To: Botched "Data warehouse" design...

First of all, determine if all those "wonky views" are indexed views or not.
As for not having a DATE dimension, so what? You've been here on SSC to know exactly...
--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 28, 2024 at 3:17 am

#4403547
Reply To: Set up Availability Group without a cluster to create read-only database

Talk to your SAN folks. SAN snapshots are perfect for this.
--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 28, 2024 at 3:09 am

#4403544
Reply To: Reg: Dynamic SQL Query from row to column in SQL server

vs.satheesh wrote:
Hello,
Thank you for your kind response
In this scenario, the goal is to generate a report according to client requirements without using any reporting tools. The query output is directly...
--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 27, 2024 at 2:22 pm

#4403191
Reply To: Reg: Dynamic SQL Query from row to column in SQL server

Phil Parkin wrote:
Did you try Jonathan's code?
Jonathan's code works only for 3 falculty members. The op will "settle" for up to 20.
--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 27, 2024 at 2:17 pm

#4403190

Viewing 15 posts - 661 through 675 (of 59,091 total)