Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,146 through 20,160 (of 59,072 total)

RE: Aggrigation of 200 Mil Data records

sudhirnune (7/7/2015)
Hi All,
We are having a requirement to Aggregate the data and create LY, CY data across 5 Metrics.
the Volume of Data will be 200 Mil - 250 Mil
Server Configuration:
Memory:...
--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 3:32 pm

#1811146
RE: A Case FOR Cursors...

patrickmcginnis59 10839 (7/8/2015)
Jeff Moden (7/8/2015)
Specifically, the following seemed to be a whole lot condescending on your part...
the folks here aren't database server implementers, they are database server users, and 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 3:00 pm

#1811140
RE: Problems importing CSV files using SSIS.

Orlando Colamatteo (7/7/2015)
Your argument against XML, JSON, even CSV with delimiters available on a 101 keyboard rings very similar to the assembler programmer that used to sit down the hall...
--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 11:52 am

#1811085
RE: A Case FOR Cursors...

patrickmcginnis59 10839 (7/6/2015)
Jeff Moden (7/6/2015)
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...
--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 11:46 am

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

Viewing 15 posts - 20,146 through 20,160 (of 59,072 total)