Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,156 through 10,170 (of 59,099 total)

RE: Insert Faster way

"It Depends". What is the purpose of copying the data to the target table and what will the target table be used for?
Also, does the target table start...
--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)

January 4, 2019 at 6:52 pm

#2018051
RE: Insert Faster way

RGP - Friday, January 4, 2019 10:16 AM
Jeff Moden - Thursday, January 3, 2019 6:24 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)

January 4, 2019 at 10:56 am

#2018024
RE: Shrink database only x gig a week.

TRACEY-320982 - Friday, January 4, 2019 9:14 AM
Great details, I got back 1 TB of space by changing to CCI indexes. Eventually...
--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)

January 4, 2019 at 9:32 am

#2018005
RE: How to Bulk Insert data from csv which contains double quotes to sql server 2014

vikasjagadale8 - Friday, January 4, 2019 9:00 AM
Jeff Moden - Friday, January 4, 2019 8: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)

January 4, 2019 at 9:25 am

#2018002
RE: SQL Memory & Tempdb usage

Michael L John - Friday, January 4, 2019 8:39 AM
What problems are you trying to solve?
That's the question of the year,...
--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)

January 4, 2019 at 9:23 am

#2018001
RE: SQL Memory & Tempdb usage

Jonathan AC Roberts - Friday, January 4, 2019 8:55 AM
Worth reading this as you are using SQL Server 2016: https://docs.microsoft.com/en-us/sql/relational-databases/databases/tempdb-database?view=sql-server-2017
--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)

January 4, 2019 at 9:09 am

#2017997
RE: Porting SQLServerCentral

Eric M Russell - Friday, January 4, 2019 6:23 AM
Jeff Moden - Thursday, January 3, 2019 9:28...
--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)

January 4, 2019 at 8:56 am

#2017995
RE: How to Bulk Insert data from csv which contains double quotes to sql server 2014

vikasjagadale8 - Thursday, January 3, 2019 11:14 PM
Thanks, Jeff I tried your suggested format file
Bulk insert generated the error: Bulk load...
--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)

January 4, 2019 at 8:48 am

#2017991
RE: SQL Memory & Tempdb usage

I'll have to defer to someone like Gail Shaw or another MCM for the correct answers there, especially when it comes to the priority of operations...
--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)

January 4, 2019 at 8:31 am

#2017986
RE: Query Performance

chandan_jha18 - Friday, January 4, 2019 6:38 AM
Jeff Moden - Thursday, January 3, 2019 3: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)

January 4, 2019 at 7:37 am

#2017977
RE: The Giving Back Workload

Funny... I just read the WIKI article on the subject of RTFM and they don't know what the origin is. I don't either but the first time I heard it...
--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)

January 3, 2019 at 10:37 pm

#2017949
RE: Select convert to 2 decimal places, comma, right aligned

chad 62627 - Thursday, January 3, 2019 3:34 PM
Okay look...I know this is 5 years later...but I googled this issue, and 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)

January 3, 2019 at 10:07 pm

#2017948
RE: Porting SQLServerCentral

I just remembered that on every WordPress.com article that I posted a comment to, I had to subscribe to that article. I hope we don't have to do that for...
--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)

January 3, 2019 at 9:28 pm

#2017947
RE: SQL query to only return a row based on fluid conditions

You'd likely get help more quickly if you posted your data in a readily consumable format. Lot's of people like to test their solutions before posting an answer. See 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)

January 3, 2019 at 8:25 pm

#2017944
RE: how to do this join?

APPLY works out to be the same as a correlated subquery that can return more than 1 row for each correlation.
--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)

January 3, 2019 at 8:22 pm

#2017943

Viewing 15 posts - 10,156 through 10,170 (of 59,099 total)