Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,286 through 6,300 (of 59,072 total)

Reply To: Find run of repeating value

ScottPletcher wrote:
Non-serious note to Jeff Moden: See, I actually am willing to use an identity as the clustering key.
😀
--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)

October 2, 2020 at 2:14 pm

#3792503
Reply To: about the option (fast n) and acutal execution plan

892717952 wrote:
hmm, I saw some books or article says the execution plan is inaccurate , if like this how we can compare which sql statement is better ?
I used actual...
--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)

October 2, 2020 at 1:34 pm

#3792492
Reply To: Trim trailing characters from a varchar?

This will actually pull the individual values by row so you can use them if you need to.
See Scott's code (below) if you just want to get rid of most...
--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)

October 2, 2020 at 1:38 am

#3792406
Reply To: DBA progress/career development/ path

dogramone wrote:
I have worked with a few data scientists and none of them can do DBA work.
BWAAAAA-HAAAAA-HAAAA!!! Heh... you struck a funny bone because I've found that to be true...
--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)

October 1, 2020 at 11:56 pm

#3792396
Reply To: 'sa' impersonation

SZ wrote:
so if I understand you correctly, if I give them the permission to execute the procedure I am not giving them any god given rights so they can execute...
--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)

October 1, 2020 at 6:29 pm

#3792337
Reply To: Add a Time column and a Date column together?

rkelly58 wrote:
Hi all,
Thank you everyone for your input, it works perfectly.
Your speed and responses have been fantastic.
I also have a question on Splitting values, but i will post that 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)

October 1, 2020 at 6:22 pm

#3792334
Reply To: Add a Time column and a Date column together?

david.edwards 76768 wrote:
Jeff Moden wrote:
8<
>8
Also, just to be sure, the OP stated that they weren't the ones that are responsible for the poor datatyping that you're correctly talking about. A 3rd party...
--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)

October 1, 2020 at 6:19 pm

#3792333
Reply To: I passed the Microsoft Exam 98-364: Database Fundamentals
Thank you for the very kind words, Michael. Glad to help.
- This reply was modified 5 years, 9 months ago by Jeff Moden.
--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)
October 1, 2020 at 4:12 am

#3792156
Reply To: I passed the Microsoft Exam 98-364: Database Fundamentals

Congratulations, Michael! Well deserved. You really did put your shoulder to the wheel from what I've seen of your posts on this forum.
--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)

September 30, 2020 at 8:19 pm

#3792092
Reply To: 'sa' impersonation

SZ wrote:
Would WITH EXECUTE AS OWNER make any difference ???
or
Can I just add this stored procedure to the list of securables their role can execute ?
Would not then this procedure...
--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)

September 30, 2020 at 7:55 pm

#3792080
Reply To: Add a Time column and a Date column together?

jcelko212 32090 wrote:
DATE and TIME are available data types that can be combined into the newer DATETIME2(n) data type. Just use the CAST() function and simple math. The use of an...
--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)

September 30, 2020 at 5:06 pm

#3792034
Reply To: Add a Time column and a Date column together?

rkelly58 wrote:
Hi Jeff,
Here is the result of your code:
Date ...
--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)

September 30, 2020 at 4:58 pm

#3792017
Reply To: How to use PIPES in T-SQL to bring two number based on user entry

Heh... "The OP has left the building". 😀
--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)

September 30, 2020 at 4:49 pm

#3792015
Reply To: trigger on a Large 5 billion row table

Siten0308 wrote:
Hello,
So we have noticed our trigger that does insert from one table to another if there is an update or insert, so we noticed the timestamp GETDATE() has been...
--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)

September 30, 2020 at 4:12 pm

#3792010
Reply To: 'sa' impersonation

SZ wrote:
To give a user the ability to execute a stored procedure (EXECUTE AS) I must first grant him the ability to impersonate the 'sa'.
(that procedure creates new login 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)

September 30, 2020 at 4:06 pm

#3792008

Viewing 15 posts - 6,286 through 6,300 (of 59,072 total)