Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,141 through 10,155 (of 59,093 total)

RE: Insert Faster way

RGP - Saturday, January 5, 2019 3:37 AM
Jeff Moden - Friday, January 4, 2019 11:55 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 5, 2019 at 9:05 am

#2018070
RE: Insert Faster way

p.p.s. BTW, what's the data type of that JOB_INFO column?
--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 11:55 pm

#2018064
RE: SQL Memory & Tempdb usage

sqlguy7777 - Friday, January 4, 2019 10:57 PM
Hey thanks everyone for your great responses so far.....
"What problems are you trying to solve?"
In...
--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 11:40 pm

#2018063
RE: Insert Faster way

p.s. We really need to fix that 50% FILL FACTOR thing. It's wasting a ton of memory. We can look at that once we've solved your original problem.
--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 11:25 pm

#2018062
RE: Insert Faster way

Ok... here we go...
First, I wanted to make sure that I had the same volume of data you have. I'd forgotten to ask you to post the DDL...
--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 11:13 pm

#2018061
RE: Insert Faster way

RGP - Friday, January 4, 2019 7:21 PM
Thanks Jeff, no issues at all, Iâ€™m so glad that you are so responsive to...
--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:12 pm

#2018056
RE: Query

Here's an example of how short the code can be thanks to sys.master_files.
SELECT DatabaseName           = DB_NAME(database_id)
        ,FileType               = type_desc
        ,dbFileLogicalName      = name
        ,dbFilePhysicalFilePath =...
--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:00 pm

#2018055
RE: Query

Nita Reddy - Friday, January 4, 2019 10:53 AM
--My Query to get Space left in a data file.
CREATE TABLE ##ALL_DB_Files (
dbname...
--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:06 pm

#2018054
RE: Query

Nita Reddy - Friday, January 4, 2019 10:53 AM
Question: from above query I am getting Spaceleft for XYZ database which has 4...
--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:00 pm

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

Viewing 15 posts - 10,141 through 10,155 (of 59,093 total)