Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,096 through 22,110 (of 59,072 total)

RE: Faster way to populate number table variation with inline tally?

sqldriver (12/29/2014)
Jeff Moden (12/29/2014)
sqldriver (12/29/2014)
I'm not exactly sure how to test that, but I do have a 2014 Dev edition installed, and ran the below code.
If there's something 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)

December 29, 2014 at 6:46 pm

#1766900
RE: Faster way to populate number table variation with inline tally?

sqldriver (12/29/2014)
I'm not exactly sure how to test that, but I do have a 2014 Dev edition installed, and ran the below code.
If there's something in particular you'd like...
--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 29, 2014 at 5:40 pm

#1766892
RE: Faster way to populate number table variation with inline tally?

Michael Meierruth (12/29/2014)
Jeff Moden (12/28/2014)
As a bit of a sidebar, it's a shame that CTEs are truly treated as inline views and that a single self-join of a CTE causes...
--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 29, 2014 at 5:39 pm

#1766891
RE: Schedule backup/ copy backup and rename to other folder

Heh... call a DOS command through xp_CmdShell and be done with it. If that makes you too nervous, create a job with an Command Task. If you really...
--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 29, 2014 at 11:20 am

#1766825
RE: I'm arguing with BCP

BenWard (12/29/2014)
Ah yes I did mean columns.
silly mistake there!
In that case, BCP will still work. You need to list the columns in your format file and give them...
--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 29, 2014 at 7:17 am

#1766760
RE: ETL Through Linked Server

I do understand about not being able to see anything of what you need. The full table pulls using BCP probably are the best way to go for 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 28, 2014 at 11:48 pm

#1766659
RE: ETL Through Linked Server

bantrim (12/28/2014)
Jeff,
Thank you for your reply. I haven't tested the queryout option against the incremental query, but I guess I had assumed that I would run into the same...
--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 28, 2014 at 6:54 pm

#1766650
RE: 15 Quick Short Interview Questions Useful When Hiring SQL Developers

ScottPletcher (12/26/2014)
Jeff Moden (12/25/2014)
ScottPletcher (12/25/2014)
Geoff A (3/3/2013)
Jeff Moden (2/28/2013)
Shifting gears a bit, I’m glad that these are essay-style questions so that I could write in what I believe is 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 28, 2014 at 6:10 pm

#1766648
RE: Fantasy Football 2014

Heh... you should send me a prize for not joining. 😛
--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 28, 2014 at 5:59 pm

#1766647
RE: Are the posted questions getting worse?

@Dwain,
Congrats on the new house and belated Merry Christmas and early Happy New Year to you both, too!
--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 28, 2014 at 5:52 pm

#1766646
RE: ETL Through Linked Server

bantrim (12/28/2014)
Hey everyone,
I am currently trying to optimize an ETL process that pulls around 150 tables from a OLAP-esque system through a linked server. It's the AllScripts Touchworks EMR...
--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 28, 2014 at 5:34 pm

#1766645
RE: NEED COLUMN NAMES FROM TABLE DYNAMICALLY

Kannan Vignesh (12/28/2014)
Nolock doesn't allows to table get lock.
It was a rhetorical question to mostly suggest that it shouldn't be used in most cases. WITH(NOLOCK) is actually the proper...
--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 28, 2014 at 5:25 pm

#1766643
RE: Lists

Hugo Kornelis (12/28/2014)
Jeff Moden (12/28/2014)
The link for the "poor documentation" that I was speaking of is actually in Books Online under UPDATE... as in "Quirky Update", which can be controlled...
--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 28, 2014 at 5:19 pm

#1766641
RE: Lists

The link for the "poor documentation" that I was speaking of is actually in Books Online under UPDATE... as in "Quirky Update", which can be controlled but is absolutely 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)

December 28, 2014 at 3:07 pm

#1766636
RE: NEED COLUMN NAMES FROM TABLE DYNAMICALLY

Lynn Pettis (12/28/2014)
Okay, I have read the OPs posts and I am slightly confused at what he is attempting to accomplish. I get the idea that the OP wants...
--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 28, 2014 at 2:15 pm

#1766632

Viewing 15 posts - 22,096 through 22,110 (of 59,072 total)