Jeff Moden

Forum Replies Created

Viewing 15 posts - 211 through 225 (of 59,101 total)

Reply To: trying to call powershell from TSQL statement

Jeffrey Williams wrote:
I am curious as to why you need to call out to PS directly from SQL Server. If I need to call a PS script from SQL Server -...
--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)

January 24, 2025 at 11:45 pm

#4522764
Reply To: trying to call powershell from TSQL statement

Siten0308 wrote:
ugh... so one thing, i realized... is always check the naming... of the file... really sorry, everything you mentioned is great troubleshooting... when i found the file.. it was...
--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)

January 24, 2025 at 10:20 pm

#4522721
Reply To: trying to call powershell from TSQL statement

Siten0308 wrote:
thanks Jeff, its the Nt service default login, should i grant that login to the path?
Is that E: Drive on the server where you're running this or on your...
--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)

January 24, 2025 at 4:39 pm

#4522539
Reply To: trying to call powershell from TSQL statement
Run the following code from SSMS on the server that you're trying to run you call from...
```
EXEC xp_cmdshell 'WHOAMI';
```
... then tell us who or what that login...
--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)
January 24, 2025 at 4:32 pm

#4522535
Reply To: File date from Extended Event .xel files

You bet and good talking with you this morning!
--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)

January 23, 2025 at 6:55 pm

#4521831
Reply To: File date from Extended Event .xel files
This should do it for you... as is typical, the documentation is a lot longer than the code.
```
 CREATE FUNCTION dbo.Convert_EE_FileName_TimeStamp_to_DATETIME2
/*********************************************************************************************
 Purpose:
 Convert the timestamp embedded into...
```
--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)
January 23, 2025 at 7:34 am

#4521450
Reply To: Generate number fields

It's actually got a name for that type of process... "Relational Multiplication". The code that Des Norton wrote above will absolutely do the trick. It's also known as a "Cartesian...
--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)

January 23, 2025 at 2:27 am

#4521291
Reply To: Problem with the dll (version 1.2) of an Extended Stored Procedure with SQL Serv

I don't have any help to offer because I don't build CLRs on our systems and so have zero experience there.
As a bit of a sidebar, though, what does your...
--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)

January 21, 2025 at 5:22 pm

#4520132
Reply To: Getting blockage on Update Statement

I don't have the links for them but I've recently read a few articles that say the turning off page locking for the table did the trick nicely for 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)

January 21, 2025 at 5:08 pm

#4520125
Reply To: Proc cache slowly decreasing in size until restart is required

Like I said on the other thread with the identical name (Note: there is zero need to double post on this forum)...
This sounds like either a "Connection Leak" or a...
--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)

January 20, 2025 at 5:37 am

#4518904
Reply To: Proc cache slowly decreasing in size until restart is required

This sounds like either a "Connection Leak" or a "Memory Leak". A "Connection Leak" is where no connection is ever closed and everyone gets a new connection (which take memory)...
--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)

January 20, 2025 at 5:34 am

#4518902
Reply To: SQL Query to use in MS SSRS server to give you your report structure.

I agree... great post but it should be an article.
I also add...
6. While even Microsoft hasn't followed suit, NOT using semi-colon terminators has been deprecated since 2005 came out.
7. Both...
--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)

January 20, 2025 at 4:16 am

#4518874
Reply To: search text files for multiple keywords

Jeff Moden wrote:
Bruin wrote:
Any suggestions or help..
Many thanks.
I don't know 5hit from Shinola in Powershell and so I tried something different... here's the link to the thread I worked through...
https://www.perplexity.ai/search/using-powershell-how-to-search-hGZTTLw2Rmi4v81v3IwqEA#2
I'm 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)

January 20, 2025 at 3:46 am

#4518871
Reply To: search text files for multiple keywords

Bruin wrote:
Any suggestions or help..
Many thanks.
I don't know 5hit from Shinola in Powershell and so I tried something different... here's the link to the thread I worked through...
https://www.perplexity.ai/search/using-powershell-how-to-search-hGZTTLw2Rmi4v81v3IwqEA#2
I'm not testing...
--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)

January 20, 2025 at 3:40 am

#4518870
Reply To: Article Review

frederico_fonseca wrote:
not me (and many of the prior replies are trolls I believe)
Thanks for the reply, Frederico.
I don't know about folks being "trolls" but I've never seen anywhere on 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)

January 20, 2025 at 2:35 am

#4518847

Viewing 15 posts - 211 through 225 (of 59,101 total)