Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,436 through 9,450 (of 59,091 total)

Reply To: LTRIM function giving same results as TRIM

To add to what Sue has stated, LEN doesn't include trailing spaces in its count. Here's the note from Books Online. The emphasis is mine.

Returns the number of characters 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)

April 22, 2019 at 3:09 am

#3508297
Reply To: Viewing database diagrams

That and something that would work like "Query Designer on Steroids" where you would simply select a stored procedure and it would generate an ERD for each section of 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)

April 22, 2019 at 3:02 am

#3508241
Reply To: Interview question

Couldn't you also put a path "director" in the overall flow to select a path based on the time of day and execute the package 3 times? Again, forgive me...
--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 22, 2019 at 3:00 am

#3508231
Reply To: Viewing database diagrams

Ok... cancel my last. I went to the link posted and they didn't ask for a whole lot (just Name and email address) and so I took a shot at...
--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 8:55 pm

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

Viewing 15 posts - 9,436 through 9,450 (of 59,091 total)