Jeff Moden

Forum Replies Created

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

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

dave.convery@red-gate.com - Tuesday, December 19, 2017 10:35 AM
Re: the forum changes, we had hoped to work on the upgrade in November, but...
--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 19, 2017 at 1:18 pm

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

subramaniam.chandrasekar - Monday, December 18, 2017 9:30 PM
Lynn Pettis - Monday, December 18, 2017 10:17 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 19, 2017 at 8:31 am

#1972704
RE: bcp changing high ascii values

Stephen Grimshaw - Tuesday, December 19, 2017 2:39 AM
Thank you very much. That seems to do the trick.
Now that I have...
--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 19, 2017 at 6:31 am

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

dave.convery@red-gate.com - Tuesday, December 19, 2017 2:52 AM
Job alerts are controlled by a third-party company, so there's no button I can press...
--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 19, 2017 at 6:29 am

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

Perry Whittle - Tuesday, December 19, 2017 4:05 AM
Jeff Moden - Monday, December 18, 2017 6:57 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 19, 2017 at 6:25 am

#1972670
RE: How many workers can I use and how many are active?

kevaburg - Monday, December 18, 2017 8:00 AM
We are trying to troubleshoot a problem that seems to be the result of too...
--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 19, 2017 at 6:13 am

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

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