Jeff Moden

Forum Replies Created

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

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
RE: The Single Pane of Glass

It certainly doesn't apply to everyone but I've found a lot of people that have such proverbial "Single Pane of Glass" tools either don't know how to use them 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)

October 5, 2018 at 8:50 am

#2008326
RE: Are the posted questions getting worse?

TomThomson - Thursday, October 4, 2018 3:27 PM
I find it very depressing - people should not be stuck into jobs like...
--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 8:45 am

#2008323
RE: Are the posted questions getting worse?

TomThomson - Friday, October 5, 2018 8:13 AM
Eirikur Eiriksson - Wednesday, September 26, 2018 7:48 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)

October 5, 2018 at 8:40 am

#2008321

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