Jeff Moden

Forum Replies Created

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

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
Reply To: How to get WTD,MTD and QTD in sql server

It would be helpful if you'd post the CREATE TABLE statement and a few rows of data in an INSERT/VALUES fashion. We also need to know what day 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)

April 2, 2022 at 4:28 pm

#4009800
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
I'll remind you that 1) it's not my site and 2) it's not my site. 😉
It is, however, your contention this is easy...
'Nuff said and understood. My apologies.
--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 4:20 pm

#4009798
Reply To: Are the posted questions getting worse?

Eirikur Eiriksson wrote:
Jeff Moden wrote:
Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
Steve Jones - SSC Editor wrote:
SPAM is a problem now, and it's not a simple one. I've filed a ticket to work with the third party on what is not...
--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 1, 2022 at 4:34 pm

#4009437
Reply To: Calculated Member slow response time (median)

Jonathan AC Roberts wrote:
Jeff Moden wrote:
With the understanding that I don't use Analysis Services, can you use T-SQL in SSAS? There are some very fast methods for calculating MEDIAN in T-SQL.
You can query...
--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 1, 2022 at 4:30 pm

#4009422
Reply To: Excel LET Formula for creating small values tables from a table or range

allinadazework wrote:
One thing I couldn't do easily was to deal with dates (that are date values in excel). These would show as "44649.94918" in the values table. When you would...
--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 1, 2022 at 4:13 pm

#4009417
Reply To: Calculated Member slow response time (median)

With the understanding that I don't use Analysis Services, can you use T-SQL in SSAS? There are some very fast methods for calculating MEDIAN in T-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)

April 1, 2022 at 3:44 pm

#4009395
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
Steve Jones - SSC Editor wrote:
SPAM is a problem now, and it's not a simple one. I've filed a ticket to work with the third party on what is not catching more...
--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 1, 2022 at 3:39 pm

#4009394
Reply To: Connect to a SQL Server through a proxy

evald wrote:
i used th ewindows built-in proxy and it works great!

Thanks for posting the solution that you found for your own question. It's going to help others, for sure.
--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 1, 2022 at 3:31 pm

#4009391
Reply To: Temp Tables question
rjjh78 wrote:
Is it possible to create a temp table when setting a query?
For example:
```
DECLARE 
@Category    varchar(100), 
@SubCategory varchar(100),
@Query      ...
```
--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 1, 2022 at 3:19 pm

#4009386
Reply To: Best way to add last 4 of SSN to data feed in SSIS from encrypted SSN column

TangoVictor wrote:
Nevermind - It's too bad there's not a delete option for posts.
What did you end up doing to solve your problem?
--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 1, 2022 at 3:11 pm

#4009382
Reply To: Query tuning advice

Doing only a quick glance at the execution plans, this looks like it could be a parameter sniffing issue. You could go all surgical on this but I'm thinking that...
--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, 2022 at 3:27 pm

#4008289

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