Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,506 through 11,520 (of 59,095 total)

RE: Partitioning An Existing Table With A Columnstore Index ?

Grant Fritchey - Wednesday, August 15, 2018 9:13 AM
Jeff Moden - Wednesday, August 15, 2018 8:44 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 15, 2018 at 11:20 am

#2001941
RE: Partitioning An Existing Table With A Columnstore Index ?

Grant Fritchey - Wednesday, August 15, 2018 5:12 AM
Are you partitioning in order to take advantage of the data management aspects 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)

August 15, 2018 at 8:44 am

#2001899
RE: Sync tables from different server with million of records

Sorry... didn't see the rest of the writeup. According to what you wrote, "Server A" will be the master and "Server B" will be the slave. That answers question 1...
--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 15, 2018 at 8:24 am

#2001887
RE: Sync tables from different server with million of records

EasyBoy - Wednesday, August 15, 2018 7:40 AM
Hello,
I need to sync 2 tables from different server. Both table contains about 1055088770 rows.About 70%...
--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 15, 2018 at 8:22 am

#2001885
RE: Get Temp Table definition

Igor Micev - Wednesday, August 15, 2018 7:59 AM
You can
exec tempdb.dbo.sp_help '#temp'
and you have all details about #temp
Agreed. And it'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)

August 15, 2018 at 8:16 am

#2001884
RE: Why QUOTENAME is important

RonKyle - Wednesday, August 15, 2018 7:27 AM
Perry Whittle - Wednesday, August 15, 2018 12:11 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 15, 2018 at 7:35 am

#2001864
RE: How much RAM required to server

I'd say that you first need to tell us how much RAM and how many CPUs you have first. If you currently have, for example, 128GB of RAM and 16...
--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 15, 2018 at 7:26 am

#2001858
RE: Find space used by image columns

Jeff Moden - Wednesday, August 15, 2018 7:10 AM
Tom John-342103 - Wednesday, August 15, 2018 5:47 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 15, 2018 at 7:11 am

#2001849
RE: Find space used by image columns

Tom John-342103 - Wednesday, August 15, 2018 5:47 AM
Jeff Moden - Tuesday, August 14, 2018 8:18 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 15, 2018 at 7:10 am

#2001848
RE: 2 identical plans - different performance when query run on different servers

PearlJammer1 - Wednesday, August 15, 2018 2:30 AM
Jeff Moden - Tuesday, August 14, 2018 7:45 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 15, 2018 at 7:03 am

#2001845
RE: Find space used by image columns

Tom John-342103 - Tuesday, August 14, 2018 11:27 AM
Jonathan AC Roberts - Tuesday, August 14, 2018 11:03...
--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 14, 2018 at 8:18 pm

#2001771
RE: 2 identical plans - different performance when query run on different servers

PearlJammer1 - Tuesday, August 14, 2018 5:31 PM
Hi - This is a very odd behaviour and the opposite of what you may...
--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 14, 2018 at 7:45 pm

#2001769
RE: Deleted

chocthree - Tuesday, August 14, 2018 6:56 AM
Hi,
I hope this is the right forum to ask this question. Not sure where else...
--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 14, 2018 at 12:08 pm

#2001735
RE: Huge number of tables

JackCarrington - Tuesday, August 14, 2018 8:32 AM
ThomasRushton - Tuesday, August 14, 2018 6:38 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 14, 2018 at 9:25 am

#2001680
RE: The SQL Saturday Thread

robert.sterbal 56890 - Tuesday, August 14, 2018 8:15 AM
Where would be the most logical place to develop a guide?
On the PASS/SQLSaturday...
--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 14, 2018 at 8:23 am

#2001653

Viewing 15 posts - 11,506 through 11,520 (of 59,095 total)