Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,626 through 5,640 (of 59,072 total)

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
Reply To: sql ocde picking last date of month value

imranazam wrote:
Hi guys
hope you are all well
I am struggling to write a sql code which will pick up the sales value of the last date of each month.
I have this...
--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 7:41 pm

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

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 England SQL...
--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 6:03 pm

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

I agree that "if you build it, they will come". It does take a bit of advertising and one popular way to do that is to schedule regular meetings/events on...
--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 14, 2021 at 3:36 pm

#3844915
Reply To: Looking for an experienced DB Administraor and Engineer

I'm not looking for a job and I live across "the pond" but I wanted to thank you for posting a job here in these trying times.
--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 14, 2021 at 3:23 pm

#3844902
Reply To: Cursor and Subtraction Assignment Logic Issue

Put yourself in my place and pretend you know absolutely nothing about the problem that you just described and then read what you just posted and compare that to 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)

February 14, 2021 at 4:39 am

#3844788
Reply To: Server is fast, then slow, then fast with no pattern "Solved?"

Jocar26 wrote:
Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19042: )
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)

February 13, 2021 at 5:30 pm

#3844635
Reply To: Convert International Character-String Date Formats

Totally agreed... even when a time isn't included. 😀 There's this funny little line called the "International Date Line" that people seem to forget about.
--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 13, 2021 at 5:25 pm

#3844634

Viewing 15 posts - 5,626 through 5,640 (of 59,072 total)