Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,971 through 8,985 (of 59,091 total)

Reply To: Bulk Insert not working for dataset

logan.keister wrote:
Trust me, I would love to. I believe calibration by 2x4 would be the only way they would listen, though. They are unhelpful, and their unhelpful tendencies and some...
--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)

July 24, 2019 at 9:43 pm

#3665899
Reply To: What is wrong with my code?

below86 wrote:
but I still prefer the 'AS' method instead of '='. 😀
The reason I prefer the "=" method is simply because of my habit to do vertical alignment for...
--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)

July 24, 2019 at 9:37 pm

#3665896
Reply To: Bulk Insert not working for dataset

It's time to calibrate the people that are sending you the data.
--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)

July 24, 2019 at 9:27 pm

#3665881
Reply To: Bulk Insert not working for dataset
logan.keister wrote:
Thanks for posting, sir. I did happen to try that on a development sql box that is version 14.0.2002.14 (2017) and it doesn't seem to work though. At first,...
- This reply was modified 7 years, 1 months ago by Jeff Moden. Reason: EDIT: Scratch my last about the errors... I now see where you said no errors were produced
--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)
July 24, 2019 at 9:14 pm

#3665878
Reply To: Deadlock on two delete statements

NOLOCK isn't to prevent locks... it's to prevent from waiting for locks to be released when you're doing reads. You've kind of overridden that because the SELECT is in 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)

July 24, 2019 at 9:09 pm

#3665876
Reply To: What is wrong with my code?

below86 wrote:
If your presentation layer is SSRS, then using underscores in your column names makes life easier, IMHO. Now I'm using 2008 SSRS, but when I drop a column name...
--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)

July 24, 2019 at 8:52 pm

#3665869
Reply To: Long name in TSQL is creating errors

John Mitchell-245523 wrote:
I really would recommend that you back up to a different folder, rather than giving access to the Administrator area. Something on a different server would be best -...
--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)

July 24, 2019 at 8:14 pm

#3665864
Reply To: Track column changes

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

July 24, 2019 at 7:39 pm

#3665843
Reply To: What is wrong with my code?

michael.leach2015 wrote:
Jeff Moden wrote:
On that same note, I'd also change the datatype for "IsBillable" and "IsActive" to TINYINT and use a 1 for "Yes" and a 0 for "No" along with...
--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)

July 24, 2019 at 3:45 pm

#3665789
Reply To: What is wrong with my code?

michael.leach2015 wrote:
Jeff Moden wrote:
Last but certainly not least, there is no way that I'd ever include spaces or other special characters in the columns so as to make them require brackets....
--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)

July 24, 2019 at 3:43 pm

#3665788
Reply To: Is DBA responsible for ETL operations and cube creation in DW design project?

Neil Burton wrote:
Jeff Moden wrote:
Matt Miller (4) wrote:
While it does depend, in general I'd think that while the DBA might be not responsible for those design items, they likely will be held accountable for...
--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)

July 24, 2019 at 3:32 pm

#3665785
Reply To: Migration from MS Sql Server 2016 => PostgreSQL 9.6.12

delizat4g wrote:
We have databases that need to, eventually, fully migrate to PostgreSQL for the future environment they will be hosted on.
Got it. Thanks for the feedback.
--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)

July 23, 2019 at 9:36 pm

#3665525
Reply To: Receiving timeout errors on SQL2014

I know it sounds crazy but I just went through something similar just 15 minutes ago. The problem was that the SQL Service wasn't started. When I manually started 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)

July 23, 2019 at 9:06 pm

#3665519
Reply To: Migration from MS Sql Server 2016 => PostgreSQL 9.6.12

I guess my question would be... if you have to keep Postgre in sync with the SQL Server data, why are you using Postgre???
--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)

July 23, 2019 at 8:14 pm

#3665504
Reply To: Receiving timeout errors on SQL2014

You are more than a year behind on SQL Server cumulative updates. I can only imagine but would suspect that you're probably behind on Windows Updates, as well. If for...
--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)

July 23, 2019 at 7:04 pm

#3665479

Viewing 15 posts - 8,971 through 8,985 (of 59,091 total)