Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,881 through 5,895 (of 59,089 total)

Reply To: MSSQL 2019 - SQL Server Agent - Jobs account

They do make it difficult to find. 😀
Please see the following link...
https://docs.microsoft.com/en-us/sql/ssms/agent/manage-job-steps?view=sql-server-ver15#transact-sql-job-steps
In that section of the article, you'll find the following (emphasis is mine)...
Transact-SQL job steps do not use...
--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)

December 16, 2020 at 11:46 pm

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

Michael L John wrote:
Luis Cazares wrote:
In case someone missed it. There seems to be a big problem with Solarwinds Orion products, which some of you might use.
https://cyber.dhs.gov/ed/21-01/
A related story
https://www.washingtonpost.com/technology/2020/12/15/solarwinds-russia-breach-stock-trades/
While it seems...
--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)

December 16, 2020 at 11:04 pm

#3821400
Reply To: Deleting folder on a drive

richardmgreen1 wrote:
I've seen a way of deleting the folders using cmdshell but I'm wary of enabling it because of the potential security issues.
Heh... it's not the security risk that people...
--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)

December 16, 2020 at 10:54 pm

#3821389
Reply To: Creating indexes on a very large table takes over 5 hours

@pamkagel ,
Based on a phone call I got earlier today, do you work in Michigan, U.S.A.? I ask because it basically the same question I was asked if I could...
--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)

December 16, 2020 at 10:36 pm

#3821388
Reply To: SQL removing characters

JasonGerding wrote:
I am using the below case statement
, CASE WHEN Attributes LIKE ',Size = %,' Then right(Attributes, len(Attributes) - charindex('Size ', Attributes)) ELSE '' END as Size
To get the below...
--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)

December 16, 2020 at 10:18 pm

#3821382
Reply To: Help getting last 2 entries from split string with variable number of splits

tom 69406 wrote:
Thanks everyone.
As I'm developing under a deadline, I went with the first answer. And I'm developing with limited data, and we are expecting no more than a few thousand...
--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)

December 16, 2020 at 5:33 am

#3820998
Reply To: Change reference

Grant Fritchey wrote:
The restore operation using WITH MOVE will allow you to rename the database and create new data files. However, the only thing that will change the code is changing...
--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)

December 16, 2020 at 5:25 am

#3820996
Reply To: Different Duration of the same queries

One thing that few consider is that it might be "recompiles". We had a query that was taking "only" (way too long in my eyes) 100ms to execute. The 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)

December 16, 2020 at 5:22 am

#3820995
Reply To: Combine Date & Time parts for Two Dates, then subtract

BGEast wrote:
Thanks!! That appears to work... Now I just have to figure out how to get 'MyTimeSpent' to display as day plus hours or as full day with decimal.. Such...
--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)

December 16, 2020 at 4:23 am

#3820977
Reply To: Never let a good crisis go to waste

Sergiy wrote:
"Don't fix if it ain't broken" - this is used far too often.
the bridge has to collapse for them to decide its time to replace those rusted bolts.
BWAAAAA-HAAAAA-HAAAAA!!!! It...
--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)

December 16, 2020 at 3:22 am

#3820966
Reply To: Create Unique combination as Key out of N columns

ktflash wrote:
Jeff Moden wrote:
You have some values that have leading zeros. Must the leading zeros be preserved? If so, then not all of the columns are actually INTs as you said. ...
--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)

December 16, 2020 at 3:04 am

#3820965
Reply To: Create Unique combination as Key out of N columns

ScottPletcher wrote:
In SQL 2016, it's rarely a waste of disk space. Specifying ROW compression is standard procedure for all tables unless there's a specific reason not to.
"Standard Procedure for ALL...
--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)

December 16, 2020 at 2:58 am

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

jasona.work wrote:
We've been using Teams for a lot of communication, but sometimes it's nice to get up and walk over to someones' desk, or turn the chair to chat with...
--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)

December 15, 2020 at 11:39 pm

#3820929
Reply To: Help Transforming TSQL to MSSQL

jbeclapez wrote:
Hi Guys!
I start the WITH statement without the semi column ; then I will test also starting with the semi column. I had to rewrite all of it and...
--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)

December 15, 2020 at 12:52 am

#3820508
Reply To: How can I exclude records from this table?

jcelko212 32090 wrote:
You also use the term "adjacent" which is a spatial concept that doesn't apply to the table. A table is an abstract unordered set of rows.
Except for HEAPs, that's...
--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)

December 15, 2020 at 12:48 am

#3820507

Viewing 15 posts - 5,881 through 5,895 (of 59,089 total)