Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,371 through 8,385 (of 59,091 total)

Reply To: Get month days

I know this post is serveral years old now but wanted to say nice post on the following... definitely the right idea.
kaj wrote:
Igor,
I really think you're overcomplicating it. From my...
--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)

November 17, 2019 at 8:58 pm

#3698364
Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop

SGT_squeequal wrote:
Fantastic article, do you have any links to using the % to return value. never seen the use of % like this (T.N-1)%3 +1
Thank you for the feedback... much...
--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)

November 16, 2019 at 10:19 pm

#3698303
Reply To: Identity column as Primary Key - good or bad?

jcelko212 32090 wrote:
I always follow ANSI/ISO standards, the metadata committee standards, and basic data modeling principles.
BWAAAA-HAAAA-HAAAAA!!!! THIS coming from the person that says he likes the MySQL "standard" of using YYYY-00-00...
--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)

November 16, 2019 at 3:03 pm

#3698272
Reply To: Diskallignment questions ?

It is an alleged non-problem any more. I say "alleged" because I trust no one on such things (too many times burnt in the past). There is a simple test...
--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)

November 16, 2019 at 2:43 pm

#3698271
Reply To: One table or two?

below86 wrote:
I'll be using this data to add entries to our data warehouse tables. After using this data to fill in our data warehouse tables most of the time it...
--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)

November 15, 2019 at 3:12 pm

#3698069
Reply To: Using Java script to import word and pdf into SQL server

pcq0125 wrote:
Thanks for your response. The purpose of the word document import into SQL server is to parse the data into a table and export into excel. The current framework...
--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)

November 15, 2019 at 2:54 pm

#3698062
Reply To: Agile Job Descriptions

I got hired and then I wrote the job description. 😉
--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)

November 15, 2019 at 5:18 am

#3697936
Reply To: Any SQL developer volunteers needed?

To add to both what I and Jonathan suggested that will help a whole lot, both for the reader and the self-edification of the author, always remember this simple rule...
--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)

November 14, 2019 at 4:18 pm

#3697717
Reply To: Need of database

I do have to disagree with a database "being a poor choice" to support documents and images. At best, I'll agree to say "It Depends" but even that bothers 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)

November 14, 2019 at 4:11 pm

#3697714
Reply To: Dynamic SQL Query

From my quick look, there is absolutely NOTHING in the code in the original post that requires Dynamic 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)

November 12, 2019 at 9:45 pm

#3697186
Reply To: does WITH (NOLOCK) hint in Select statement really make a difference?

VoldemarG wrote:
In our environment, such hint is placed after every single table in every join in every stored proc.
SELECT 1
FROM #GR X WITH(NOLOCK)
JOIN GT ...
--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)

November 12, 2019 at 9:42 pm

#3697184
Reply To: How to drop an SP using Tsql

First of all, I never drop a supposedly unused stored procedure immediately. I rename the stored procedures by appending the with "_ToBeDeleted" Such a rename constitutes a modification 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)

November 12, 2019 at 9:37 pm

#3697182
Reply To: SQL View - Pivot

bbranco wrote:
I have the following data in a table, its pricing for items, so if a customer buys 275 of .250BP, they pay .043
I need to get this data 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)

November 12, 2019 at 9:32 pm

#3697180
Reply To: Need Split delimiter string into columns Solution

Jonathan AC Roberts wrote:
Sean Lange wrote:
That's pretty interesting. Looks somewhat similar to Eirikur's but a few differences. The one thing I am not a fan of is that it has the same major...
--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)

November 12, 2019 at 6:11 pm

#3697136
Reply To: CPU frequently Maxing out 100%

It did the same thing for us... went for 7 years with no incident and then it apparently hit a tipping point... and the tipping point wasn't gentle... it 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)

November 12, 2019 at 3:53 pm

#3697093

Viewing 15 posts - 8,371 through 8,385 (of 59,091 total)