Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,326 through 11,340 (of 59,099 total)

RE: Can't Get BULK INSERT TO ERROR!!!

You don't need SSIS for this. You need proper constraints on your table and that includes if you're using SSIS. The constraints will cause BULK INSERT to fail and sequester...
--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)

September 2, 2018 at 3:59 pm

#2004233
RE: Order of Clustered Index

Mike Scalise - Sunday, September 2, 2018 10:18 AM
Sorry for the delay. My wife went into labor a week early so I've...
--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)

September 2, 2018 at 3:49 pm

#2004232
RE: Hide a column from other user in MSSQL

Google is your friend... here's just one link on the subject.,
https://sqlstudies.com/2015/11/12/hiding-one-or-more-columns/
The real key may be to ask the question, why does the user have access 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)

September 2, 2018 at 3:42 pm

#2004231
RE: Balancing Writes

coolchaitu - Sunday, September 2, 2018 8:02 AM
Thanks Jeff. Happy long weekend
Thank you. It just needs to get started. The boss...
--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)

September 2, 2018 at 3:07 pm

#2004230
RE: Balancing Writes

coolchaitu - Sunday, September 2, 2018 6:46 AM
Jeff Moden - Sunday, September 2, 2018 6:39 AM
--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)

September 2, 2018 at 7:52 am

#2004223
RE: Balancing Writes

coolchaitu - Sunday, September 2, 2018 3:48 AM
andycadley - Sunday, September 2, 2018 2:33 AM
--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)

September 2, 2018 at 6:39 am

#2004216
RE: How to Generate a common unique column for multiple views

Naidu PK - Friday, August 31, 2018 2:36 PM
I created 3 different views and I need a common column to join these...
--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)

September 1, 2018 at 8:14 pm

#2004207
RE: Balancing Writes

coolchaitu - Saturday, September 1, 2018 3:51 PM
SGT_squeequal - Saturday, September 1, 2018 3:38 PM
--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)

September 1, 2018 at 7:57 pm

#2004206
RE: Code to list dates end of month dates between specific start and end date ranges

alexander.lummer - Friday, August 31, 2018 12:31 PM
Caps out at 100 rows where there should be more? this i would def hope...
--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)

August 31, 2018 at 8:42 pm

#2004197
RE: [RESOLVED] How to cast string (with comma or/and decimal) to integer/decimal?

Instead of using expensive REPLACEs, you could always convert it to the MONEY datatype and then to DECIMAL. The MONEY datatype takes commas in stride.
--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)

August 31, 2018 at 8:38 pm

#2004196
RE: The Game is Afoot

I'm glad that someone else still likes SQL Profiler. 😀
As for that 10-15% CPU thing? The only time I don't cringe at that is when a large batch...
--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)

August 31, 2018 at 8:34 pm

#2004195
RE: Interesting question about NCI's when converting HEAPs to CI's

Interesting... earlier today, I ran the following code and it said "Error near ONLINE" and would not execute.
ALTER TABLE dbo.Trans
ADD CONSTRAINT PK_Trans PRIMARY KEY CLUSTERED ([Iterator]) WITH (ONLINE =...
--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)

August 31, 2018 at 8:05 pm

#2004194
RE: Interesting question about NCI's when converting HEAPs to CI's

frederico_fonseca - Friday, August 31, 2018 12:22 PM
Jeff Moden - Friday, August 31, 2018 11:52 AM
--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)

August 31, 2018 at 7:38 pm

#2004193
RE: Interesting question about NCI's when converting HEAPs to CI's

Heh... Crud. It turns out this is a moot point. They don't want "just" a Not Null column with a Unique Clustered Index... they actually want a Primary Key CONSTRAINT...
--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)

August 31, 2018 at 11:52 am

#2004161
RE: 70-762 Developing SQL Databases

Lowell - Friday, August 31, 2018 9:16 AM
I've gone through the effort to get some certs,and i will not bore anyone 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)

August 31, 2018 at 10:48 am

#2004157

Viewing 15 posts - 11,326 through 11,340 (of 59,099 total)