Jeff Moden

Forum Replies Created

Viewing 15 posts - 526 through 540 (of 59,097 total)

Reply To: Xp_cmdshell Use Cases

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
... I also gave a presentation on how to secure it properly way back in (IIRC) 2013 at the now defunct Kalamazoo, MI SQL Saturday. It's where I...
--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)

July 4, 2024 at 3:46 am

#4433310
Reply To: Xp_cmdshell Use Cases

Lordy... the wondrous things I've used it for... there's no way for me to list everything I've used it for.
Exporting files is one of the big ones but also 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)

July 3, 2024 at 2:54 am

#4433081
Reply To: A Different View of Technical Debt

Steve Jones - SSC Editor wrote:
I have a number of friends moving to SQL 2022 and haven't had Jeff's issues. If you look at Brent's version spread (For his customers), lots are/have moving/moved 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)

July 2, 2024 at 7:10 pm

#4433015
Reply To: SQL code needed for the WHERE clause..

I wouldn't use DELETE on a year old table. That'll be a lot to delete and it'll cause a "log file explosion".
I probably also wouldn't do a whole year 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)

July 2, 2024 at 6:52 pm

#4433011
Reply To: The Cost of Rework

jonathan.ellison wrote:
I totally concur. Back in the late 90's and early 2000s Hoshin Principles; Greenbelt and Blackbelt training; Design-for-Six-Sigma, all stressed the importance of the "voice of the customer" 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)

July 1, 2024 at 11:41 am

#4432651
Reply To: This is very concerning in a number of ways

A lot of links for that incident show up with the following search.
https://duckduckgo.com/?q=robot+suicide

--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)

July 1, 2024 at 3:06 am

#4432579
Reply To: Do You Have the Gifts to Be a DBA?

"Bump" to make the 2nd page of the discussion show 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)

June 29, 2024 at 4:42 am

#4432298
Reply To: A Different View of Technical Debt

The greatest technical debt I have ever experienced is when we migrated from SQL Server 2016 to 2022. That means that I'm still experiencing that "joy". Overall, "It just runs...
--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)

June 29, 2024 at 4:36 am

#4432297
Reply To: How To Work-A-Round Not being able too use CASE within ORDER BY

YSLGuru wrote:
Jeff - I'm going with Scotts recommendation which sticks with CAST and not FORMAT. That said, just out of curiosity do you know how much data/rows need to be...
--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)

June 29, 2024 at 4:13 am

#4432296
Reply To: How to get calculated values from a derived(?) table?

mjdemaris wrote:
Thanks Jeff, I will be sure to have some ready to use code in the future.
Heh.. "next time". You're saying that because someone already did it but... they did...
--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)

June 28, 2024 at 9:50 pm

#4432259
Reply To: How to get calculated values from a derived(?) table?

jcelko212 32090 wrote:
You're not going to use this data as points in time, but as intervals, so model it that way
Create table events (event_number integer not null primary key, event_start_timestamp dateime2(0)...
--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)

June 28, 2024 at 7:25 pm

#4432237
Reply To: Filtering Extended Events by Start Time

Grant Fritchey wrote:
Never mind. AI lied to me.
{sarcasm on}
WHAT??? AI LIED??? Surely, you jest! It's going to take over all our jobs, right? RIGHT? 😉
{sarcasm off (for the moment)}
--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)

June 27, 2024 at 7:37 pm

#4431967
Reply To: How To Work-A-Round Not being able too use CASE within ORDER BY

If you use FORMAT anyplace where there are a lot of rows, I can only wish you luck for performance because you're going to need 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)

June 27, 2024 at 7:33 pm

#4431966
Reply To: Looking for recommendations for reporting technologies replacements

Phil Parkin wrote:
Rod at work wrote:
Thank you, Jeff. That would only require installing Office, or at least Excel, on the server, correct? I could document which version of Excel is used.
No, this is...
--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)

June 27, 2024 at 7:31 pm

#4431965
Reply To: Looking for recommendations for reporting technologies replacements

Rod at work wrote:
Thank you, Jeff. That would only require installing Office, or at least Excel, on the server, correct? I could document which version of Excel is used.
No. Absolutely not. 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)

June 27, 2024 at 7:22 pm

#4431964

Viewing 15 posts - 526 through 540 (of 59,097 total)