Jeff Moden

Forum Replies Created

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

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

PearlJammer1 - Thursday, August 16, 2018 3:21 AM
Hi
Thanks to everyone for their help and suggestions. I have managed to fix the issue....
--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 16, 2018 at 6:25 am

#2002036
RE: Why QUOTENAME is important

Thom, thanks again for taking the time to write this article. It's not only a great "Back to Basics" article but it turned out to be an "I Learned Something...
--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 16, 2018 at 6:07 am

#2002033
RE: SQL Server 2016 - Catching Up Since SQL Server 2008R2

YSLGuru - Tuesday, August 14, 2018 11:08 AM
We are moving from SQL 2008R2 to 2016 and needless to say I'm not up...
--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 12:10 pm

#2001956
RE: Why QUOTENAME is important

RonKyle - Wednesday, August 15, 2018 7:52 AM
Thom A - Wednesday, August 15, 2018 7:42 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:27 am

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

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