Jeff Moden

Forum Replies Created

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

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
RE: Connect QuickBooks to SQL Server through SSIS

jason.quackenbush - Wednesday, June 6, 2012 2:46 PM
I never said attempting to be misleading, I said flat out misleading. The fact 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)

October 5, 2018 at 8:19 am

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

This should be a function but the either the OP or the OP's DBA Team thinks they should be avoided because of some "Best Practice" someone found somewhere stating 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 5, 2018 at 8:10 am

#2008317
RE: How to flip tables in sql server 2014

vikasjagadale8 - Friday, October 5, 2018 4:03 AM
Hello,
I have a requirement wherein there are 2 tables (Staging & Target) in the 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 5, 2018 at 7:57 am

#2008314
RE: Max size file in BCP process

SATYA R - Friday, October 5, 2018 4:50 AM
HI All,
in file have around 100000 records but command was successful with 0 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)

October 5, 2018 at 7:48 am

#2008308

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