Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,951 through 7,965 (of 59,072 total)

Reply To: BCP
IMary wrote:
Hi,
I have below requirement. Please advise how to achieve that with BCP or any other tool
1. Have Table A with 5 million records
--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)
January 7, 2020 at 2:49 am

#3713025
Reply To: Learn to Change

Steve Jones - SSC Editor wrote:
Change is change. Whether its better or not is something we have to evaluate, test, experiment with, and decide. I worry about people getting caught up in thinking we...
--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)

January 7, 2020 at 2:30 am

#3713024
Reply To: Fifi Calculation

jcelko212 32090 wrote:
And I also recommend normalizing databases ..Wow! Seriously, I do not like using a data model that is hundreds of years old and based on Roman numerals. O probably...
--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)

January 7, 2020 at 1:27 am

#3713018
Reply To: func_GetInvoiceNumberByDocumentNumber

Consider the following article while you're at it. 😉
https://www.sqlservercentral.com/editorials/the-art-of-commenting
--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)

January 6, 2020 at 3:57 pm

#3712702
Reply To: Dmvs to show missing indexes

To Grant's point, I wouldn't even call them "suggestions". They're a "clue" that some code somewhere might (strong emphasis in "might") benefit from an index. I don't know about lately...
--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)

January 6, 2020 at 3:41 pm

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

Unexpected gifts from nowhere... I now have a second "Ice Breaker/Litmus Test" question for interviews. No need to pile on folks. I'm just a little gob-smacked that someone has been...
--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)

January 6, 2020 at 3:24 pm

#3712674
Reply To: difference between numeric and decimal

samirca007 wrote:
Hello, beginner in Tsql
I need help: here in one of the tables that I use, one of the fields is declared in decimal (10.5).
I understand that the field 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)

January 6, 2020 at 3:16 pm

#3712673
Reply To: SQL server License

I'm thinking that you're going to need to do a reinstall but I'm not sure. Your best bet would be to contact MS on this problem.
--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)

January 6, 2020 at 3:07 pm

#3712670
Reply To: CHOOSing a value

Saurabh.D wrote:
Very useful function for "Status" column.
thanks Nakul Vachhrajani for return type testing.
I would think that an actual join with a lookup table would be better so that you don't...
--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)

January 6, 2020 at 3:02 pm

#3712668
Reply To: Fifi Calculation
jsshivalik wrote:
Hi
I have below Data and i want Balance Invoices on accoun of Fifo .
In case of C00220 it should return 54575 entry
In case of C00575 it should return 1593...
- This reply was modified 6 years, 6 months ago by Jeff Moden. Reason: Comment about possible misread of the OP
--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)
January 6, 2020 at 2:44 pm

#3712659
Reply To: Quick Security Mistakes

I love the "Conclusion" in the PDF I came across on the subject. Basically, they pat themselves on the back for doing a good job of recovery (which took several...
--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)

January 6, 2020 at 1:24 am

#3712512
Reply To: Setting flexible security for reporting

RichardFRay wrote:
Yo, Jeff --
So, here's a detail...
When I compile my sp's, in 'my database', with EXECUTE AS OWNER it's fine, but now there are problems in the production db. 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)

January 5, 2020 at 7:07 pm

#3712450
Reply To: The Art of Commenting
skeleton567 wrote:
One of the greatest values of commenting is to answer the proverbial 'What was I thinking ?' question.
Heh... spot on. I use comments for the following...
1. To reiterate what...
--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)
January 5, 2020 at 5:46 pm

#3712447
Reply To: MAXDOP vs CPU time and elapsed time

cmartel 20772 wrote:
I recently experimented with MAXDOP using a pretty huge statement. Here is a summary of the results:
MAXDOP = 0. CPU = 36790 ms, elapsed = 12838 ms.
MAXDOP = 1....
--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)

January 4, 2020 at 1:05 am

#3712288
Reply To: Creating a data and log drive per CPU

Edward Shaw wrote:
They claim to have been able to get queries down from hours to seconds by doing this.
I've seen a lot of strange claims and they normally turn out 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)

January 4, 2020 at 12:51 am

#3712284

Viewing 15 posts - 7,951 through 7,965 (of 59,072 total)