Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,446 through 11,460 (of 59,102 total)

RE: Huge number of tables

JackCarrington - Thursday, August 23, 2018 1:00 AM
Jeff Moden - Friday, August 17, 2018 6: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)

August 23, 2018 at 6:45 am

#2003035
RE: Insert new records from one database to another using SSIS

Why not "just" use replication or log shipping for this?
--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)

August 22, 2018 at 4:57 pm

#2002961
RE: Checking my knowledge

Grant Fritchey - Wednesday, August 22, 2018 11:57 AM
john_laspada - Wednesday, August 22, 2018 10: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)

August 22, 2018 at 12:21 pm

#2002903
RE: Data Has a Dollar Value

Steve Jones - SSC Editor - Tuesday, August 21, 2018 9:11 AM
Absolutely, which is where the advanced researchers are working 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)

August 22, 2018 at 11:26 am

#2002884
RE: Checking my knowledge

Why not just buy another drive so that you have some headroom to archive/delete a lot of the junk you know you don't need and maybe rebuild some indexes 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)

August 22, 2018 at 11:14 am

#2002881
RE: Rebuilding Indexes

yoyodynedata - Tuesday, August 21, 2018 11:38 AM
How do you determine how often you need to rebuild your indexes?
You'll end up getting...
--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)

August 22, 2018 at 8:27 am

#2002843
RE: How much RAM required to server

Vinayak15580 - Wednesday, August 22, 2018 4:48 AM
Dear All Thank you for your inputs. Its really helpful to me.
I have set 8...
--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)

August 22, 2018 at 7:29 am

#2002833
RE: Unicode Support and Conversion

Lynn Pettis - Tuesday, August 21, 2018 7:01 PM
Jeff Moden - Tuesday, August 21, 2018 5:31 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)

August 21, 2018 at 9:11 pm

#2002786
RE: Unicode Support and Conversion

p.s. And they did remember to plan for you to nearly double the size of all the databases and the backups, right? All that extra space is already available, right? ...
--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)

August 21, 2018 at 5:36 pm

#2002776
RE: Unicode Support and Conversion

tinausa - Monday, August 20, 2018 12:13 PM
I have SQL Server 2012 and all my inputs got changed to Unicode. 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)

August 21, 2018 at 5:31 pm

#2002774
RE: Non Clustered Index on Phone column

Eirikur Eiriksson - Tuesday, August 21, 2018 10:13 AM
Jeff Moden - Tuesday, August 21, 2018 9:51 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)

August 21, 2018 at 10:43 am

#2002715
RE: Prevent duplicates in a table

RonKyle - Tuesday, August 21, 2018 7:11 AM
Yes. The table design is bad and it will kill you in the...
--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)

August 21, 2018 at 9:58 am

#2002706
RE: Non Clustered Index on Phone column

Lynn Pettis - Tuesday, August 21, 2018 9:00 AM
David Burrows - Tuesday, August 21, 2018 1:49 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)

August 21, 2018 at 9:51 am

#2002705
RE: Prevent duplicates in a table

Senchi - Monday, August 20, 2018 3:18 PM
Though I appreciate your opinions can somebody actually tell me on how to accomplish this...
--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)

August 20, 2018 at 8:12 pm

#2002609
RE: Prevent duplicates in a table

drew.allen - Monday, August 20, 2018 2:32 PM
Jeff Moden - Monday, August 20, 2018 2:13 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)

August 20, 2018 at 8:11 pm

#2002608

Viewing 15 posts - 11,446 through 11,460 (of 59,102 total)