Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,381 through 13,395 (of 59,101 total)

RE: bcp changing high ascii values

Hmmm... what you may want to try is adding the following "switch" to the BCP command...
-C RAW
--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)

December 18, 2017 at 1:21 pm

#1972582
RE: Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?

Luis Cazares - Monday, December 18, 2017 11:01 AM
I thank you for the test, Jeff. However, I still don't believe that someone...
--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)

December 18, 2017 at 12:55 pm

#1972579
RE: SQL 2012 - Interview Questions (Sample)

subramaniam.chandrasekar - Monday, December 18, 2017 8:20 AM
adish - Monday, December 18, 2017 7:15 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)

December 18, 2017 at 8:36 am

#1972521
RE: SQL 2012 - Interview Questions (Sample)

subramaniam.chandrasekar - Monday, December 18, 2017 6:12 AM
Jeff Moden - Monday, December 18, 2017 6:04 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)

December 18, 2017 at 6:27 am

#1972477
RE: Replace TABLE with STAGING_TABLE. Approach?

JJR333 - Monday, December 18, 2017 4:47 AM
Thanks for your patience Jeff.
I am fairly new to SQL. Having trouble getting my head...
--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)

December 18, 2017 at 6:08 am

#1972469
RE: SQL 2012 - Interview Questions (Sample)

adish - Monday, December 18, 2017 5:44 AM
Dear Mr Chandrasekar Subramaniam,
Please be polite. You are the one asking for help. A good...
--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)

December 18, 2017 at 6:04 am

#1972467
RE: SQL 2012 - Interview Questions (Sample)

subramaniam.chandrasekar - Monday, December 18, 2017 5:36 AM
Jeff Moden - Monday, December 18, 2017 5:27 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)

December 18, 2017 at 5:46 am

#1972460
RE: SQL 2012 - Interview Questions (Sample)

subramaniam.chandrasekar - Monday, December 18, 2017 12:25 AM
Jeff Moden - Saturday, December 16, 2017 12: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)

December 18, 2017 at 5:27 am

#1972454
RE: SQL server 2014 slower on more powerful desktop than a laptop

My recommendation would be to call Apple and ask them.
--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)

December 17, 2017 at 8:56 pm

#1972418
RE: STRING_SPLIT with no delimiter

Heh... I have a much easier solution. Use the DelimitedSplit8K function for this and not worry about stuff breaking. 😉
--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)

December 17, 2017 at 8:48 pm

#1972417
RE: Replace TABLE with STAGING_TABLE. Approach?

JJR333 - Sunday, December 17, 2017 12:57 PM
Thank you Jeff and Jason,
I will try Jeff's suggestion first.
Does the approach below mean 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)

December 17, 2017 at 8:46 pm

#1972416
RE: How to store Excel files In SQL Table

Just to be sure there is no mistake, I'm not the one calling this "Complete Lunacy". I was citing what someone else said.
--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)

December 17, 2017 at 8:28 pm

#1972415
RE: Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?

Stupid new forum software doesn't allow expansion of the graphic I posted... at least not for me. Here's something a little larger that I copied from Excel to Word and...
--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)

December 17, 2017 at 6:58 pm

#1972414
RE: Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?

To answer the original question... no... there is no OBVIOUS difference. You have to look for it and then you'll find that there's a huge difference. 😉
First, here's...
--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)

December 17, 2017 at 6:52 pm

#1972413
RE: SQL Restore takes long time - how do I clear committed transactions from log ?

Jeffrey Williams 3188 - Thursday, December 14, 2017 11:43 AM
Jeff Moden - Wednesday, December 13, 2017 11:04...
--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)

December 17, 2017 at 11:51 am

#1972405

Viewing 15 posts - 13,381 through 13,395 (of 59,101 total)