Jeff Moden

Forum Replies Created

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

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

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