Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,966 through 7,980 (of 59,098 total)

Reply To: difference between numeric and decimal

MVDBA (Mike Vessey) wrote:
Jeff -it needed to be said, but we are f1 AND web search rolled into one......
Heh... I guess that's true in a lot of cases. You would think that...
--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 11:57 pm

#3713441
Reply To: Rebuild vs Reorganize

Thank you for the extremely kind and generous words but we have a difference in languages and understanding here. I've "talked" with Brahmanand through other methods and he is a...
--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 11:44 pm

#3713436
Reply To: Fifi Calculation

jcelko212 32090 wrote:
>> I don't think I was particularly snarky.
THAT, good Sir, is the crux of the 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 7, 2020 at 7:05 pm

#3713354
Reply To: Great Writers Get Hired

Grant Fritchey wrote:
Robert Sterbal wrote:
I just asked someone else in this thread:
What would be a good way to get presenters to record their presentation the day before they gave it?
Not sure that's...
--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 7:02 pm

#3713352
Reply To: Great Writers Get Hired

Grant Fritchey wrote:
Don't put your face in them. I stopped recording videos about 9 months ago. I'm going to get back on it, but change the format a bit. No more...
--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 6:59 pm

#3713350
Reply To: Setting flexible security for reporting

RichardFRay wrote:
Production DB is (RTPOneReporting) DB Owner is 'sa'
Cross database ownership chaining is NOT enabled.
My repository DB is (JHMRReporting) DB Owner is 'dbo'
Cross database ownership chaining is NOT enabled.
My sp,...
--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 6:57 pm

#3713347
Reply To: BCP
JigarShah wrote:
Hi,
Assuming you have to add 3 columns with data to the existing 5million row table.
Following is the approach which you can use -
1. Extract the 5...
--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 3:17 pm

#3713218
Reply To: Need help with generating random pass for 100s of certificates

Why not just generate GUIDs? With the dashes, they're 36 bytes in length when converted to CHAR. Without the dashes, they're 32.
--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 3:11 pm

#3713215
Reply To: Validating meta data of xls file

Charmer wrote:
Finally, issue is fixed which was a silly and it's done. 🙂
OK, so what was the "silly" fix you employed?
I'll also state that it's a shame that you're resorting...
--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:55 pm

#3713203
Reply To: Not an 8 to 5 employee

Sharpen up your resume, find a trustworthy "jobber" type of recruiter (they'll want to interview you to ensure you're worth your salt in SQL and/or DataAnalysis), and then let them...
--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 4:30 am

#3713040
Reply To: Validating meta data of xls file

Charmer wrote:
Hi Team,
We get xls file every day with so many sheets in it. I need to validate only the sheet named with current year. In this case, it 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 7, 2020 at 3:39 am

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

Viewing 15 posts - 7,966 through 7,980 (of 59,098 total)