Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,081 through 4,095 (of 59,067 total)

Reply To: The same value across 5 or more columns in a table , How can I write a query
ZZartin wrote:
What's wrong with just?
COL_ONE = COL_TWO AND COL_ONE=COL_THREE etc....
Any other "clever" solution is almost certainly going to be more code.
And, usually slower. I haven't tested...
--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 11, 2022 at 6:18 am

#3971876
Reply To: Complicated Insert SQL with Calculations

So, enquiring minds want to know... did that latest code 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 11, 2022 at 6:13 am

#3971874
Reply To: Issue with Leading 0

My guess would be that it cannot be YYYYDDD because the first D is always a 0. Perhaps YYYYoWW but why the bloody zero?
Now, if we could just get mcfarlandparkway...
--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 10, 2022 at 3:48 am

#3971416
Reply To: Issue with Leading 0

The only reason I didn't use STUFF is because if you DO use the code on data that has already been modified by the use of STUFF, then it's going...
--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:23 pm

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

Another good link can be found here.
https://www.sqlshack.com/introduction-to-row-level-security-in-sql-server/

--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:12 pm

#3971342
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

Viewing 15 posts - 4,081 through 4,095 (of 59,067 total)