Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,111 through 4,125 (of 59,087 total)

Reply To: Where the World Takes You

Back in the 80's, I was teaching people how to use these new fangled things called "PC's". We had Lotus 123 and WordPerfect. I had quickly become one of 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)

January 9, 2022 at 3:36 am

#3971268
Reply To: Issue with Leading 0

Ok... first of all, I STRONGLY recommend NOT using the (ugh!) severely performance challenged FORMAT function! 😀
After that, the following will do the trick and "forgive" original formatting mistakes like...
--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 9, 2022 at 3:15 am

#3971263
Reply To: Issue with Leading 0

mcfarlandparkway wrote:
How to add zero after 4 numbers in sql? Example - 2019011
Currently i am getting data like 201911. But i want zero after first 4 numbers.
Is it really a number...
--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 9, 2022 at 12:41 am

#3971241
Reply To: How to allow multi user work on same table without any issue of interact data ?

With that, I'll ask, are you really saying that you want to restrict the two users from seeing each other's products at any time and not just for the code...
--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 9, 2022 at 12:38 am

#3971240
Reply To: What Were Your 2021 Wins

I quit smoking on the 29th of April, 2021 at 5:ooPM and haven't had a puff since. Having done such a thing a couple of times in my life for...
--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 8, 2022 at 9:35 pm

#3971222
Reply To: What Were Your 2021 Wins

Connie wrote:
Work-wise, 2021 was a big win for me. I changed jobs from being an everything DBA & developer at a medium sized company to being a production DBA 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)

January 8, 2022 at 8:57 pm

#3971215
Reply To: days between and start date

As a bit of a sidebar, the 40 day thing isn't correct for things like the Moderna booster, which requires you to wait for 6 months before getting it. 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)

January 8, 2022 at 7:42 pm

#3971208
Reply To: How to allow multi user work on same table without any issue of interact data ?

ahmed_elbarbary.2010 wrote:
data for user b will display for user a
If that's happening, then you've left something out of your post because, according to the code you've posted, it cannot happen.
--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 8, 2022 at 7:39 pm

#3971207
Reply To: column store index 0% page fullness after rebuild.

If you want some help on this, I'm thinking that you simply haven't posted enough information about what you've done for anyone to help.
--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 8, 2022 at 7:34 pm

#3971206
Reply To: How to write query get long process job or query or stored procedure running on

Google is your friend here. Pick your poison.
https://www.google.com/search?q=get+list+of+long+running+queries+SQL+Server
https://duckduckgo.com/?q=use+sp_whoisactive+to+find+longest+running+query&t=newext&atb=v278-1&ia=web
https://www.brentozar.com/archive/2010/09/sql-server-dba-scripts-how-to-find-slow-sql-server-queries/

--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 8, 2022 at 4:11 pm

#3971188
Reply To: My New Resolution

leonardo.ssantos79 wrote:
But the question was ONLY the year, and the year function (getdate()) doesn't do that?
The question was about how to find rows in a table based on the current...
--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 8, 2022 at 3:04 pm

#3971180
Reply To: Select and Distinct

I just noticed timers on the jpg's with just a couple of hours left. If it were me, I'd go with interpreting the word "respective" as meaning the professor 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)

January 6, 2022 at 2:32 am

#3970380
Reply To: Start Sql server agent job after a trigger

Johan Bijnens wrote:
Keep in mind it may take SQLAgent up to 20 seconds to respond.
I'm the same way until I have two 12 ouncers of coffee under my belt. 😀
--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 6, 2022 at 2:07 am

#3970376
Reply To: Select and Distinct
Sorry... I made a mistake and had to rewrite this post.
Please see the post above. The word "respective" needs to be clarified because there are two possible solutions depending on...
- This reply was modified 4 years, 7 months ago by Jeff Moden. Reason: Rewrote the post because of an ambiguity in the word "respective"
--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 6, 2022 at 1:44 am

#3970371
Reply To: Select and Distinct
I did a misread on the requirements because there are actually two possible answers according to the posted requirements and so had to rewrite this post.
Still, there is no need...
- This reply was modified 4 years, 7 months ago by Jeff Moden. Reason: Rewrote the post because of an ambiguity in the word "respective"
--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 6, 2022 at 1:31 am

#3970364

Viewing 15 posts - 4,111 through 4,125 (of 59,087 total)