Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,706 through 3,720 (of 59,098 total)

Reply To: How to use count over partition with cte instead of using having ?

Easy now... in this case, the OP has pretty much stated what they want to do. The problem with the HAVING is that it becomes difficult to select the rest...
--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 4, 2022 at 2:42 am

#4010235
Reply To: Minimal Configuration

This is supposed multi-selection question, isn't it? If so, radio buttons aren't going to work 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)

April 4, 2022 at 2:33 am

#4010232
Reply To: SQL query is taking 9 hours to complete

Ok... so the first and very important step is to "know thy enemy". With that, we have to know the "gazintas" for both tables. Run the following query one each...
--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 3, 2022 at 9:52 pm

#4010177
Reply To: SQL query is taking 9 hours to complete

I'm thinking that's still going to result in a massive accidental cross join I previously spoke of for the rows where all 3 of the join criteria are blank 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 3, 2022 at 5:40 pm

#4010128
Reply To: Virtual Events Are Here To Stay

Grant Fritchey wrote:
Total agreement with all of you. Thanks for the comments.
Thanks for the article and your comments, as well.
--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 3, 2022 at 5:37 pm

#4010127
Reply To: tsql query help
This does the trick for me.
```
   WITH cteByDB AS
(--==== Preaggregate that data including a grand total using ROLLUP and marking that total row with GROUPING_ID.
...
```
--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 3, 2022 at 4:21 am

#4009945
Reply To: SQL query is taking 9 hours to complete

All those NULLs and Blanks that you're joining on? Yeah... guess what they're doing? MASSIVE accidental CROSS JOIN which is more politely called "many-too-many" join just on those alone.
Second, are...
--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 3, 2022 at 1:45 am

#4009926
Reply To: Virtual Events Are Here To Stay

I love having a choice for all the reasons that both sides have stated both as a presenter and as an attendee. It's the best of both worlds.
--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 3, 2022 at 12:46 am

#4009908
Reply To: question about fulltext indexes

Thank you. It appears that Full Text Indexes have been available on Azure since 2015 so that's not the issue. The probable issue is that all software on Azure 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)

April 3, 2022 at 12:09 am

#4009907
Reply To: tsql query help

The use of the SUM(OVER) Windowing function should do it for you.
I also have to ask... why to you need a "running total" for this? Are you actually looking for...
--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, 2022 at 10:23 pm

#4009875
Reply To: Receiving an error if field is Null when using a Trim/Split Expression

I don't know much about the language used in SSRS but why wouldn't you just find the position of the colon, add 1 to that, and use that as 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)

April 2, 2022 at 10:19 pm

#4009874
Reply To: question about fulltext indexes

I don't know about your issue but I am interested in the "requirements". Which cloud are you moving to and are you having to remove full-text indexing because they don't...
--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, 2022 at 10:15 pm

#4009873
Reply To: Find string and stop there
Saran wrote:
pietlinden wrote:
Oh, okay, Gotcha. Something like this?
select backup_path
, LEFT(backup_path,CHARINDEX('\FULL\',backup_path,1) + LEN('FULL\'))
from #tbl_backup_path;
Thank you working perfect.
Do you understand how and why it works?
--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, 2022 at 5:16 pm

#4009821
Reply To:

I'm thinking that your best bet would be to ask the folks at AWS.
--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, 2022 at 5:15 pm

#4009820
Reply To: SQL Server 2014 Standard

kiba89 wrote:
Sorry for the dumb question in advance. So I just bought a SQL 2014 standard license from a vendor, but noticed that the product key can be looked 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)

April 2, 2022 at 5:07 pm

#4009816

Viewing 15 posts - 3,706 through 3,720 (of 59,098 total)