Jeff Moden

Forum Replies Created

Viewing 15 posts - 166 through 180 (of 59,069 total)

Reply To: How to Obtain Call History of a Stored Procedure/UDF

Yes... that can be done and the methods have been available for quite a while. The problem is that it's arduous for the server to record information every time 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)

February 8, 2025 at 11:42 pm

#4533185
Reply To: Getting below error

sangameshms wrote:
Hi Johan,
This issue has been resolved by enabling TraceFlag 3057 on secondary logshipping server and reconfiguring the logshipping for each databases, now I can see all databases are in...
--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)

February 5, 2025 at 5:19 am

#4530110
Reply To: Throwing Iron at the Cloud and AI

Good article. Thanks for taking the time to write it.
I wonder when people will really reconsider what they've done. I was both shocked and tickled when I saw the articles...
--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)

February 1, 2025 at 2:07 am

#4527202
Reply To: Change all occurances of one field in DB

frederico_fonseca wrote:
the best, and probably correct, way is to use your visual studio (or vs code) solution (you do have one don't you!!!) and its schema compare.
while there are 2...
--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 30, 2025 at 11:57 pm

#4526450
Reply To: T-SQL Script for Monitoring Database Size in SQL Server

chuckh1958 wrote:
This does not show database sizes but rather individual database file sizes. To do what I think you want it to do - show total space used per database, change...
--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 30, 2025 at 11:54 pm

#4526449
Reply To: Change all occurances of one field in DB

You will need to do the rename the column inside of every coded object, as well. The textual content is located in sys.sql_modules by object ID. Obviously, you're going to...
--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 30, 2025 at 10:00 pm

#4526401
Reply To: Why is "SELECT *" about 10 times faster than "SELECT (ALL Columns)"

Phil Parkin wrote:
That's interesting. I assume you've done this multiple times, with the same (approximate) result?
That's one of the ways we made a Partitioned View a whole lot faster. Instead of...
--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 29, 2025 at 10:10 pm

#4525712
Reply To: The Era of Cloned Humans

See the 'tube in the following article...
https://www.scientificamerican.com/article/robots-made-from-human-cells-can-move-on-their-own-and-heal-wounds/
Then, imagine this doing like what Covid did and getting "out of the lab". We're talking about something that can, in their words, "create...
--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 27, 2025 at 8:49 pm

#4524260
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

Viewing 15 posts - 166 through 180 (of 59,069 total)