Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,111 through 16,125 (of 59,067 total)

RE: DBAs Need to Learn to Develop

ZZartin (12/13/2016)
I don't know where the impression comes from that development is solely limited to customer facing work. If a car mechanic told you he didn't think knowing how...
--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)

December 13, 2016 at 8:14 pm

#1917760
RE: DBAs Need to Learn to Develop

Ralph Hightower (12/13/2016)
Writing the data access code is not difficult.
If that's true, why do so many people get it wrong? 😀
--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)

December 13, 2016 at 7:53 pm

#1917759
RE: DBAs Need to Learn to Develop

Sean Redmond (12/13/2016)
A senior developer who recently left our company expressed the opinion to me that the DBAs should be in charge of the Data Access Layer.
He was very definite...
--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)

December 13, 2016 at 7:53 am

#1917612
RE: ReportServerTempdb log file is full

Robin35 (12/12/2016)
My question is why would log file fill up when a large report is running ?
Probably because of an all-in-one query with many joins and a DISTINCT or...
--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)

December 12, 2016 at 9:13 pm

#1917502
RE: sp_send_dbmail

Welsh Corgi (12/12/2016)
I need to output the Query results to a file and send as an attachment.
You still haven't answered the most important question, yet. What format should 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)

December 12, 2016 at 8:42 pm

#1917500
RE: I'm scared to delete log file

MMartin1 (12/12/2016)
spectra (12/11/2016)
I have run that query ...and I checked those files are not present in the returned physical path result.
seems ...I can safely delete those files.
You may want 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)

December 12, 2016 at 8:09 pm

#1917499
RE: Loading CSV files into SQL Server Database tables

As RTaylor2208 suggested and unless they're poorly formed, just use BULK INSERT to import CSV files. It's one of the fastest loaders there is for SQL Server. With...
--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)

December 12, 2016 at 8:05 pm

#1917498
RE: Copy BAckup Files to Non Prod servers

pietlinden (12/11/2016)
If you were going to automate this, wouldn't it require at least a one-way trust between the two domains? SneakerNet isn't really automation...
Especially offline SneakerNet.
--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)

December 11, 2016 at 10:55 pm

#1917306
RE: Converting time - from "seconds after midnight"

sgmunson (12/11/2016)
Sergiy (12/11/2016)
sgmunson (12/9/2016)
Sergiy (12/8/2016)
sgmunson (12/8/2016)
Sergiy (12/8/2016)
sgmunson (12/8/2016)
Sergiy (12/7/2016)
sgmunson (12/6/2016)
As painful as that is, a book in any body cavity is going to be more painful and for a lot...
--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)

December 11, 2016 at 9:46 pm

#1917302
RE: Find all dates between date ranges in a table; Prefer tally table solution

Because of the overlapping date ranges, this is one of those nasty problems where, unless you're really careful, accidental Cartesian Products work their way into the code. I agree...
--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)

December 10, 2016 at 10:52 pm

#1917271
RE: Complexity factors - database infrastructure

Benki Chendu (12/8/2016)
Can someone help me out on this pls
Until you draw out a full ERD and understand the logic required to solve both batch problems and front-end lookups, 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)

December 10, 2016 at 11:48 am

#1917252
RE: Database Size After Deleting 200-million rows

alex.sqldba (12/8/2016)
I did expect the free space within the files to be visible. And to an extent it is. It's just not as much as I was expecting.
Even a...
--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)

December 8, 2016 at 8:20 pm

#1916943
RE: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

faredoon (12/8/2016)
Jeff Moden (12/7/2016)
faredoon (12/7/2016)
I was thinking more along the lines of a "live" app that constantly displays the hierarchical tree nodes and allowing live edits. It's a situation where...
--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)

December 8, 2016 at 8:01 pm

#1916942
RE: Stretch Pricing

Eric M Russell (12/8/2016)
Jeff Moden (12/8/2016)
$930/Month for only 100GB is an insane amount of money for any kind of data. It's a real "stretch" of the imagination to think...
--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)

December 8, 2016 at 3:29 pm

#1916931
RE: Stretch Pricing

$930/Month for only 100GB is an insane amount of money for any kind of data. It's a real "stretch" of the imagination to think otherwise. 😉
--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)

December 8, 2016 at 1:45 pm

#1916897

Viewing 15 posts - 16,111 through 16,125 (of 59,067 total)