Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,641 through 5,655 (of 59,089 total)

Reply To: Is there room for independent SQL or Data Integration based User Groups?

Tom Uellner wrote:
Jeff Moden wrote:
Tom Uellner wrote:
samalex wrote:
I've also looked at some other SQL Users Groups to see how they work, and thus far I haven't seen any that still meet.
The New...
--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 16, 2021 at 5:51 pm

#3845753
Reply To: Question related to architecture

I can't speak for anyone else but I've found that different applications and their different requirements frequently come and go on our systems. Some even have different Recovery Models 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)

February 16, 2021 at 5:50 pm

#3845752
Reply To: Finding the last month's values

Thomas Franz wrote:
we are saying, that #1 and #3 are correct, not #3 and #4.
LEAD with descending order is the same as LAG with ascending order (except that the returned rows...
--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 16, 2021 at 5:28 pm

#3845739
Reply To: Finding the last month's values

Ok... so to those that are saying that answer #4 is also correct, that's incorrect. Here's the output from answer #3 and answer #4. #4 is incorrect if you pay...
--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 16, 2021 at 2:03 pm

#3845667
Reply To: Finding the last month's values

BAWAAA-HAAAA-HAAAA!!! I'll get the popcorn! 😀
--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 16, 2021 at 1:31 pm

#3845627
Reply To: Who modified my Database?

Yes... they're in the "Default Trace" but, on a busy system, they not there for very long. You'd have to build a regularly scheduled sampler for that or some custom...
--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 16, 2021 at 6:37 am

#3845508
Reply To: We need to move beyond SQL Server...

residentx wrote:
...but I want more access to skills building & problem activities.
So start studying and answering forum questions. You won't find more real world problems anywhere else.
--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 16, 2021 at 6:33 am

#3845506
Reply To: SQL Server Interview Questions And Answers

All of the links I clicked on in your T-SQL site leader to "blogger.com/about".
Did you ever fix the delete vs truncate answers? They were really wrong at the beginning of...
--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 16, 2021 at 6:28 am

#3845491
Reply To: I'd like to see SQL Saturdays happen, whether in person or virtually

I'll also add that 60 minute sessions just aren't long enough to do the job right for a lot of sessions. If the 60 minutes on/15 minutes between thing is...
--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 15, 2021 at 11:51 pm

#3845417
Reply To: Is there room for independent SQL or Data Integration based User Groups?

Awesome, Tom. Thanks.
--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 15, 2021 at 9:06 pm

#3845374
Reply To: sql ocde picking last date of month value

You're still hitting the table twice, though. 😉
And, yeah... I don't normally do the "right alignment" junk. I was just demonstrating that it could be done if SQL Server was...
--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 15, 2021 at 8:32 pm

#3845371
Reply To: I'd like to see SQL Saturdays happen, whether in person or virtually

annabel.bradford wrote:
Many virtual events are being shared, here are some links that should help you:
List of virtual data saturday's here: https://datasaturdays.com/ There's also a list of data community events here:...
--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 15, 2021 at 8:28 pm

#3845370
Reply To: Preventing duplicate execution plans

You might also want to look into the correct use of sp_execute for such things.
--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 15, 2021 at 8:26 pm

#3845369
Reply To: Dynamic Data Masking and Adhoc queries.

I wouldn't use DDM as a "security feature" to save my soul because of the very problem that you state. If you need to make it so someone can't actually...
--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 15, 2021 at 8:21 pm

#3845367
Reply To: SQL Server Standard Edition

jpjacobs207 wrote:
Is there another solution i am missing?
Possibly... what is the size of your largest database?
--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 15, 2021 at 8:19 pm

#3845366

Viewing 15 posts - 5,641 through 5,655 (of 59,089 total)