Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,721 through 3,735 (of 59,098 total)

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
Reply To: The Level of Security These Days

david.edwards 76768 wrote:
I like that chart Jeff, I might add it to my favourite argument I trot out every time I am faced with a short password requirement that forces numbers,...
--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 29, 2022 at 4:10 pm

#4007718
Reply To: Scalability in SQL and NoSQL?

Grant is spot on but I'll add an "old dude's" take on it...
Which ever turns out to be the best "architecture" for your data, none of it will matter 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)

March 29, 2022 at 4:01 pm

#4007717
Reply To: Magic Tables in the SQL Server

It's amazing to me how much incorrect information there is posted in posts containing a list of interview questions.
My recommendation to people using such lists is to only look at...
--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 29, 2022 at 3:51 pm

#4007715
Reply To: Slow SQL Server Performance PAGEIOLATCH_SH, CXPACKET help!

csteeeetr wrote:
Hi All,
(see attached waits) I have a very slow sql server, it seemed to happen over night and queries are still slow. index rebuild/reorg and statistics have been updated....
--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 29, 2022 at 3:34 pm

#4007711

Viewing 15 posts - 3,721 through 3,735 (of 59,098 total)