Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,126 through 4,140 (of 59,098 total)

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, 8 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, 8 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
Reply To: clustered index usage

Snargables wrote:
So just to clarify. if i have a clustered index on say contactid and invoiceid however none of the updates are on those columns then there wouldn't be 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)

January 6, 2022 at 1:13 am

#3970362
Reply To: Complicated Insert SQL with Calculations
THE PREVIOUS CODE I HAD POSTED PRODUCED THE WRONG VALUES FOR THE 1st ROW OF FEDERALTAX OF THE "XX" ROWS. I HAD COPIED YOUR FORMULA WITHOUT REALIZING THERE WAS A...
- This reply was modified 4 years, 8 months ago by Jeff Moden. Reason: Repair a formula in 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 6, 2022 at 12:09 am

#3970353
Reply To: issue max value for records inserted all take number 4 i need it 4,5,6,7 ?

Building your own sequential numbers is a sure fire way to generate duplicates by accident. Even Des Norton notes that for his code.
Please explain why you're trying to avoid 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)

January 5, 2022 at 10:27 pm

#3970326
Reply To: Trying to return strings starting with 'dbo.'

JaybeeSQL wrote:
Neither set of code is coming up with a meaningful result set, not sure where the disconnect here is, but I'll try again:
If a row contains: koagvakjnonsenseajg4648.dbo.RandomTableForSSChahfhaijfhfhf5664646
I want 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)

January 5, 2022 at 10:16 pm

#3970325

Viewing 15 posts - 4,126 through 4,140 (of 59,098 total)