Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,041 through 11,055 (of 59,102 total)

RE: BCP column limit

All of this is precisely why it was a grievous error to start a second post on this, Satya. Please see my response on your other post. It will fix...
--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)

October 7, 2018 at 9:00 am

#2008457
RE: Max size file in BCP process

SATYA R - Saturday, October 6, 2018 10:19 PM
Ok jeff,
I am trying to load same file in my local setup in windows...
--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)

October 7, 2018 at 8:47 am

#2008456
RE: Testing strings for multiple substrings

david_h_edmonds - Friday, October 5, 2018 5:53 AM
Hello all,
I am stuck with how to approach this task.
I have an error table 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)

October 6, 2018 at 8:46 pm

#2008439
RE: Testing strings for multiple substrings

Joe Torre - Friday, October 5, 2018 3:05 PM
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-fulltext-index-transact-sql?view=sql-server-2017
Ok, Joe. Let's say you took the time to setup FTS. What would...
--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)

October 6, 2018 at 8:45 pm

#2008438
RE: BCP issues with export data files generated with queryout won't import in tables.

shamshad.ali - Friday, October 5, 2018 8:47 PM
As mentioned earlier, I have to provide a solution in c# application which can accept...
--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)

October 6, 2018 at 8:30 pm

#2008437
RE: Understanding the numeric and decimal data types

You might want to have a look at the following.
Precision, scale, and Length (Transact-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)

October 6, 2018 at 8:18 pm

#2008436
RE: Remember the Simple Things

I wish people would remember the simple things when they're writing code. To me, the "KISS" method is "Keep It Super Simple".
--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)

October 6, 2018 at 8:12 pm

#2008435
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Friday, October 5, 2018 12:33 PM
ZZartin - Friday, October 5, 2018...
--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)

October 6, 2018 at 3:15 pm

#2008430
RE: Algorithm to combine 2 integer into one value and then disintegrate back into two

Jonathan AC Roberts - Saturday, October 6, 2018 12:16 PM
Jeff Moden - Saturday, October 6, 2018 9: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)

October 6, 2018 at 3:11 pm

#2008429
RE: Max size file in BCP process

SATYA R - Saturday, October 6, 2018 2:26 AM
HI Jeff
I did the change as per your input but no lick still same...
--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)

October 6, 2018 at 10:00 am

#2008424
RE: BCP column limit

SATYA R - Saturday, October 6, 2018 9:32 AM
No error, it was really strange ? Is there any chance exceeded row...
--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)

October 6, 2018 at 9:38 am

#2008422
RE: Algorithm to combine 2 integer into one value and then disintegrate back into two

Jonathan AC Roberts - Saturday, October 6, 2018 4:12 AM
_rohit_ - Wednesday, October 3, 2018 8:27 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)

October 6, 2018 at 9:32 am

#2008420
RE: Are Indexes Actually Changes to the System?

xsevensinzx - Saturday, October 6, 2018 7:29 AM
Well someone correct me here if I'm wrong, from my understanding it's mostly because...
--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)

October 6, 2018 at 9:24 am

#2008419
RE: Are Indexes Actually Changes to the System?

Does any one have a repeatable test to demonstrate that a non-random INT PK is better than a random GUID PK? Say, for a join search of 100K out of...
--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)

October 5, 2018 at 7:11 pm

#2008402
RE: Init-cap the characters in SQL server

kiran.rajenimbalkar - Friday, October 5, 2018 2:32 AM
Hi Sir,
How to Init-cap the characters in SQL server in SQL query without creating any...
--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)

October 5, 2018 at 6:57 pm

#2008401

Viewing 15 posts - 11,041 through 11,055 (of 59,102 total)