Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,041 through 2,055 (of 59,082 total)

Reply To: Can you help me understand what this stored procedure call returns?
SQL_Surfer wrote:
Definition of stored procedure
```
create procedure [dbo].[smGetMinDate] @O_dMinDate datetime = NULL
output as declare @dDefaultMinDate datetime
select @dDefaultMinDate = GETDATE()
select @dDefaultMinDate = DATEADD(mm,-(DATEPART(mm,@dDefaultMinDate))+1,@dDefaultMinDate)
select @dDefaultMinDate = DATEADD(dd,-(DATEPART(dd,@dDefaultMinDate))+1,@dDefaultMinDate)
select @dDefaultMinDate = DATEADD(yy,-(DATEPART(yy,@dDefaultMinDate))+1900,@dDefaultMinDate)
select...
```
--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, 2023 at 12:11 am

#4145612
Reply To: Do entry-level cloud positions exist?

@nadolguna
If it were me, I'd contact some good recruiters on this. The good one's will know a path or two on how to do such a thing and, with 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 5, 2023 at 12:02 am

#4145611
Reply To: Do entry-level cloud positions exist?

frederico_fonseca wrote:
if not spam go read the answers to your original question in reddit - https://www.reddit.com/r/googlecloud/comments/10kloy5/do_entrylevel_cloud_positions_exist/
If it were me, I'd be disappointed in the answers on that link. Might 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)

February 4, 2023 at 11:56 pm

#4145606
Reply To: Replacement for char and ascii functions in natively compiled stored procedures

MullerN wrote:
Is there a way around or even a better way to do what I'm trying to?
What is it that you're ultimately trying to do?
Yeah... I can see you're looping...
--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 4, 2023 at 11:38 pm

#4145605
Reply To: Can you help me understand what this stored procedure call returns?

jcelko212 32090 wrote:
What are you trying to do? Why do you like screwed up presentation formats for your data? The whole idea of client/server architecture from the 1970s is that data...
--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 4, 2023 at 6:25 am

#4145385
Reply To: query multiple sql tables and alert last record written datetime

ZZartin wrote:
Jeff Moden wrote:
A few of the other folks share the same sentiment as I... why are you doing this in PoSh? To be sure, that's a rhetorical question. 😀
Well one...
--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 3, 2023 at 6:18 pm

#4145208
Reply To: Storing a text file in a VARCHAR(MAX) column

jcelko212 32090 wrote:
We never intended for SQL to be used for text management. You ought to be using the proper tool to store this data. As part Lane put it 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 2, 2023 at 3:38 am

#4144508
Reply To: query multiple sql tables and alert last record written datetime

A few of the other folks share the same sentiment as I... why are you doing this in PoSh? To be sure, that's a rhetorical question. 😀
--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 2, 2023 at 3:31 am

#4144505
Reply To: query multiple sql tables and alert last record written datetime

Bruin wrote:
I would manually update the file from a folder, and this list of tables won't change. The alert will run daily maybe every x hours..
We had an issue where...
--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, 2023 at 10:42 pm

#4144438
Reply To: Storing a text file in a VARCHAR(MAX) column

Mick Opalak wrote:
I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX) column. However, it is stripping the carriage returns and line feeds out, so when 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)

February 1, 2023 at 10:37 pm

#4144437
Reply To: Conventions when writing queries/stored procedures

Heh... all of this reminds me of the great "Toilet Paper" debate... Unroll from the top or the bottom? Of course, there are people like me that prefer a vertical...
--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, 2023 at 5:49 pm

#4144316
Reply To: wrong index name

I STRONGLY second the notion that index maintenance on rowstore indexes is pretty useless if based on logical fragmentation. I'll also tell you that it can cause major blocking on...
--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, 2023 at 4:18 pm

#4144289
Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Steve Jones - SSC Editor wrote:
https://twitter.com/ItzikBenGan/status/1620580822138118151
Thanks, Steve. I've been doing that same thing for years to create "character usage histograms" using either a Tally Table or fnTally. So has Itzik with his "GetNums"...
--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, 2023 at 4:06 pm

#4144285
Reply To: DB Size

water490 wrote:
thanks everyone. i will review and get back to you if I have any questions
If you do a shrink, make sure that you do a check on fragmentation 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 31, 2023 at 6:49 am

#4143557
Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

@hmbacon
I apologize... that last post slipped right past me. I know it's been a couple of months but thank you for the feedback on the ISO algorithm. Also, I thought...
--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 31, 2023 at 5:00 am

#4143516

Viewing 15 posts - 2,041 through 2,055 (of 59,082 total)