Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,451 through 9,465 (of 59,102 total)

Reply To: Viewing database diagrams

Eric M Russell wrote:
Sue_H wrote:
I've been playing around with some free alternatives, not interesting in any of the online only type of tools. Apex has a free data modeling tool you may...
--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)

April 21, 2019 at 7:16 pm

#3501842
Reply To: Generate Duplicate Value Range Based

Mr. Kapsicum wrote:
My intent is to replace BETWEEN clause with simple JOIN ON KEY column thus to achieve i am trying to prepare this row_id,last_row set into a row set through...
--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)

April 21, 2019 at 6:08 pm

#3500103
Reply To: Interview question

Lynn Pettis wrote:
If asked that in an interview I would ask why it was being designed that way. It is inefficient and a waste of resources. Breaking it up in 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)

April 21, 2019 at 5:23 pm

#3499434
Reply To: Today's Random Word!

Ed Wagner wrote:
Eirikur Eiriksson wrote:
Ed Wagner wrote:
TomThomson wrote:
ZZartin wrote:
Jeff Moden wrote:
Ed Wagner wrote:
Bar
Setting
Middle
Typical
Poor
Standard
Joke
If-only
--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)

April 21, 2019 at 4:44 pm

#3498585
Reply To: Installing a database with .db extension into SSMS

michael.leach2015 wrote:
Is it possible to install a sample database with a .db extension into SQL server management studio? I know how to install a database with a .bak extension but...
--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)

April 21, 2019 at 4:40 pm

#3498348
Reply To: Can using a scalar UDF actually improve performance?

Also tell how how you're measuring what "faster" means. If you're using % of Batch in an execution plan, it has the very high possibility of being incorrect compared 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)

April 21, 2019 at 4:38 pm

#3498232
Reply To: Regarding project description

Changing my previous answer here because the post immediately above my previous one wasn't available (it was 2 hour earlier so not sure why it didn't show up) when 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)

April 21, 2019 at 3:45 pm

#3496117
Reply To: Regarding project description
sneha.kranthi wrote:
Hi, I am applying for the position of SQL DBA with 3years of experience. I need few details regarding project description:
1. How many people in dba team work?
2. Common...
--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)
April 20, 2019 at 5:35 pm

#3479156
Reply To: Single quotes when not pasting inside the code sample Box

I'd suggest that each forum have a "sticky" topic on it for how to post various types of code along with mention of how to post question either for coded...
--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)

April 20, 2019 at 4:25 pm

#3478750
Reply To: Group Islands of Contiguous Dates (SQL Spackle)

Gert.Broekhaar wrote:
Wow! Very nice solution Jeff! I'm working on an Agenda-function and one of the requirements is to find a particular number of free timeslots for certain Appointment Types (e.g....
--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)

April 19, 2019 at 12:42 am

#3459513
Reply To: Are the posted questions getting worse?

below86 wrote:
Jeff Moden wrote:
below86 wrote:
Jeff Moden wrote:
Well, crud... I resurrected an old "Passport" disk and found my old animated "Death Star" explosion of rebar but the new forum apparently doesn't support animated...
--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)

April 18, 2019 at 10:10 pm

#3457852

Reply To: How to sum a number of rows with minute data where column format is datetime

caspersql wrote:

Thank you all very much indeed!

Just in case you want to separate the days from the HH:MI:SS stuff and as rVadim suggests, the change is quite simple.

--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)

April 18, 2019 at 9:51 pm

#3457721