Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,366 through 13,380 (of 59,095 total)

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 ?

koustav_1982 - Monday, December 18, 2017 10:52 AM
Hi All
Thanks for your replies and thanks Jeff Moden for the extensive research.
Yes the question...
--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 11:16 pm

#1972628
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 ?

xsevensinzx - Monday, December 18, 2017 10:30 PM
Chris Harshman - Monday, December 18, 2017 12:36 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 11:09 pm

#1972627
RE: Please get rid of this constant, useless job alert!!!!!!!

Rod,
Send an email to webmaster@sqlservercentral.com if no one get's back to you on this post and the responses don't quit.
--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 7:30 pm

#1972610
RE: Restore full backup at first and restore diff backup later, can I?

I could be wrong and I certainly could be missing something but I'm thinking that instead of copying the backup to the other machine, why not have the other machine...
--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:57 pm

#1972609
RE: Newbie point-in-time restore question

How long does the FULL backup take and how long does the restore from the FULL backup take?
--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:41 pm

#1972608
RE: Replace TABLE with STAGING_TABLE. Approach?

ZZartin - Monday, December 18, 2017 6:30 AM
Is there any reason not to just use sp_rename to do this? Keep both copies...
--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:21 pm

#1972607
RE: Help with aggregate function

ger_serrano - Monday, December 18, 2017 1:26 PM
unfortunately taht query did not encompass all scenarios such as:
col1 col2 col3
('A','B',100),
('B','A',-50),
('A','C',200),
('A','D',100),
('A','B',150),
('B','F',200),
('d','K',400),
('K','D',-20),
('C','D',-50),
('D','C',-60);
I need to display...
--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:02 pm

#1972605
RE: How to calculate finacial year in mssql 2000

raghuldrag - Sunday, December 17, 2017 10:47 PM
Hi Friends,
i have a table like below i want to display financial year count
--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 2:30 pm

#1972593
RE: Difference between dates displayed in days, hours, minutes and seconds

Luis Cazares - Monday, December 18, 2017 1:44 PM
I would take some benefit of using the integers behind and performance improvement 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)

December 18, 2017 at 2:24 pm

#1972592
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

Viewing 15 posts - 13,366 through 13,380 (of 59,095 total)