Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,176 through 20,190 (of 59,098 total)

RE: "ID" or "Id"

yb751 (7/8/2015)
Where I work "ID" was used everywhere if it was the primary key. Then foreign keys would become AccountID for example. Programmers claimed it was easier 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)

July 8, 2015 at 10:21 am

#1811041
RE: A Case FOR Cursors...

patrickmcginnis59 10839 (7/6/2015)
Again I am not sure why Oracle can make their PL/SQL using cursors as fast as set based operations and MS cannot. Cursors are not evil, and not...
--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)

July 6, 2015 at 6:51 pm

#1810606
RE: The Importance of Our Work

jckfla (7/6/2015)
Steve Jones - SSC Editor (7/2/2015)
Lynn Pettis (7/2/2015)
Work to live, not live to work.
yes
+1 and Amen
By the same token, work does allow you to live. It's good 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)

July 6, 2015 at 2:48 pm

#1810580
RE: How to get file date using xp_cmdshell?

SQL-DBA-01 (6/5/2015)
HI Jeff,
Is this possible to club the details of all the folders/files if one mentions any location/path???
This one is only working against files and a v nice one as...
--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)

July 6, 2015 at 2:21 pm

#1810574
RE: Using xp_cmdshell to grant fulladmin (read/write/xecute/full control) to a sql user

SQL-DBA-01 (7/6/2015)
Hello Experts,
Good Morning
I want to grant a SQL USer Full Privilege to a folder in a path using xp_cmdshell as I dont have RDP rights.
I dump the output 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)

July 6, 2015 at 2:18 pm

#1810573
RE: I Feel Like a Magician

Steve Jones - SSC Editor (7/6/2015)
...the problem is MS is not investing in the tooling or features beyond what's needed to get a sale. That's short term thinking that allows...
--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)

July 6, 2015 at 1:36 pm

#1810562
RE: A Case FOR Cursors...

patrickmcginnis59 10839 (7/5/2015)
Jeff Moden (7/3/2015)
patrickmcginnis59 10839 (7/3/2015)
Jeff Moden (7/3/2015)
andrew.norris 90251 (6/7/2015)
Nothing wrong with cursors they have their place and are very useful.
Do you have examples for something other hierarchies and...
--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)

July 6, 2015 at 9:31 am

#1810486
RE: Moving TempDB Production - rebuild space

krypto69 (7/6/2015)
Hi,
I ran out of space while rebuilding indexes over the weekend.
I'm thinking of adding additional space (additional Lun) and then moving my tempdb over to this new space....
--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)

July 6, 2015 at 8:37 am

#1810464
RE: Interaction between the DB size, DB log size, tempdb size and tempdb log size

Mark Dalley (7/6/2015)
Hello Gail
Just got an email from the DBA saying that he had shrunk the DB as a maintenance measure after rebuilding the indexes. I thought - based purely...
--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)

July 6, 2015 at 8:34 am

#1810461
RE: Learning About Temporal Tables

While it's ok to get a leg up on this particular new feature, please understand that there's been many suggestions on this feature by fellow MVPs on the MVP discussion...
--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)

July 6, 2015 at 8:10 am

#1810450
RE: i want to convert a division of int result into decimal

Actually, they're all pretty bad. For one, you don't define what the precision or scale for what a lot of your conversions to DECIMAL are. That probably won't...
--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)

July 4, 2015 at 9:32 am

#1810272
RE: A Case FOR Cursors...

Hugo Kornelis (7/4/2015)
Jeff Moden (7/3/2015)
andrew.norris 90251 (6/7/2015)
Nothing wrong with cursors they have their place and are very useful.
Do you have examples for something other hierarchies and bin stacking problems?
A few...
--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)

July 4, 2015 at 8:34 am

#1810270
RE: Skill Supply and Demand

andrew gothard (6/26/2015)
Jeff Moden (6/25/2015)
... one of them even told me that he'd never worked with clustered indexes before because he'd never had to work with clustered servers before.
Did you...
--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)

July 3, 2015 at 11:53 pm

#1810264
RE: Project suggestion for a noob

paul.knibbs (5/18/2015)
Jeff Moden (5/16/2015)About 8 months ago I interviewed a handful of "developers" and a couple of "senior DBAs" that didn't know that ROW_NUMBER() even existed.
Well, to be fair, if...
--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)

July 3, 2015 at 11:48 pm

#1810263
RE: Problems importing CSV files using SSIS.

Phil Parkin (6/2/2015)
P Jones (6/2/2015)
We do lots of csv import and have found that | isn't a good delimiter character as it can easily be mistyped into data when hitting...
--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)

July 3, 2015 at 11:19 pm

#1810262

Viewing 15 posts - 20,176 through 20,190 (of 59,098 total)