Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,886 through 21,900 (of 59,098 total)

RE: Tipping point for a numbers table vs inline tally

sqldriver (1/16/2015)
Jeff Moden (1/16/2015)
sqldriver (1/15/2015)
I have several tables with between 1 billion and 2 billion rows in them that I have to generate reports on. Sometimes periods of inactivity, sometimes...
--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 16, 2015 at 8:42 am

#1770776
RE: Tipping point for a numbers table vs inline tally

sqldriver (1/15/2015)
I have several tables with between 1 billion and 2 billion rows in them that I have to generate reports on. Sometimes periods of inactivity, sometimes periods of high...
--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 16, 2015 at 1:00 am

#1770657
RE: What are First Steps for a dba in new Office?

GilaMonster (1/15/2015)
The backups.
Ditto that.
--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 16, 2015 at 12:54 am

#1770654
RE: Help With Trying to Import File Names into a Table

Jeff Moden (1/15/2015)
Samuel Vella (1/15/2015)
Apologies for the delay - a combination of Laptop battery dying, intermittent mobile internet coverage and Visual Studio not liking my Virtual Machine 🙁
Two packages built
One...
--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 16, 2015 at 12:45 am

#1770653
RE: Help With Trying to Import File Names into a Table

Samuel Vella (1/15/2015)
Apologies for the delay - a combination of Laptop battery dying, intermittent mobile internet coverage and Visual Studio not liking my Virtual Machine 🙁
Two packages built
One which loads...
--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 15, 2015 at 9:29 pm

#1770634
RE: Help With Trying to Import File Names into a Table

Lempster (1/15/2015)
Jeff Moden (1/14/2015)
We don't even use the "Maintenance Plan" bit of SSIS available in the Object Explorer of SSMS.
I'm with you on that one Jeff, but I have 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)

January 15, 2015 at 9:25 pm

#1770633
RE: Problem Escaping Quote Characters

Polymorphist (1/6/2015)
Oh my god, could SSIS be any more of a PITA? Amazing anyone even uses this POS tool.
I need quotes in my expression. Everything i'm reading out...
--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 15, 2015 at 9:02 pm

#1770630
RE: build tree from child-to-parent table approach

mario17 (1/15/2015)
Hi,
I'm playing with CTE and just want to expand my skills and ask how you would build this tree structure to fill that [Tree] column for table 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)

January 15, 2015 at 8:58 pm

#1770629
RE: Tipping point for a numbers table vs inline tally

sqldriver (1/15/2015)
Hello,
At what number of rows do you consider the tally table method to perform less efficiently than using an actual numbers table? I've recently had to do some stuff...
--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 15, 2015 at 8:56 pm

#1770628
RE: Export SQL Data to CSV using Batch Scripting

venkyzrocks (1/15/2015)
Hi,
I have thought about doing this for a long time, let me know if it feasible or if there is a better approach.
Execute a pre written SQL on double...
--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 15, 2015 at 8:53 pm

#1770627
RE: Help With Trying to Import File Names into a Table

Lempster (1/15/2015)
Jeff Moden (1/14/2015)
We don't even use the "Maintenance Plan" bit of SSIS available in the Object Explorer of SSMS.
I'm with you on that one Jeff, but I have 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)

January 15, 2015 at 8:49 pm

#1770626
RE: SQL Query

Nita Reddy (1/15/2015)
Let me give with Example:
I have table called Tracking_changes which contain 4 columns a
I want to get the output ONLY with differences in other column 2 and 3...
--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 15, 2015 at 8:46 pm

#1770625
RE: How to get current date between?

Thanks for the feedback.
--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 14, 2015 at 5:45 pm

#1770310
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (1/14/2015)
Grant Fritchey (1/14/2015)
Back on topic for a moment.
Maybe I'm in a weird head-space at the moment, but it seems like the questions have gotten... 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)

January 14, 2015 at 5:33 pm

#1770308
RE: Help With Trying to Import File Names into a Table

Polymorphist (1/14/2015)
What's interesting to me is that most senior DB folks we interview refuse to use SSIS or have very little experience with it.
They're not alone. I'm one 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)

January 14, 2015 at 4:00 pm

#1770291

Viewing 15 posts - 21,886 through 21,900 (of 59,098 total)