Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,046 through 18,060 (of 59,102 total)

RE: xp_delete_file does not remove older backup files

Heh... it's funny that you brought this up. I've found and deleted more than 60,000 such files on one of my legacy servers. It believe it may be...
--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)

March 25, 2016 at 4:43 pm

#1867815
RE: SSIS on a dedicated server?

sqlfriends (3/24/2016)
Even this some nights the ETL runs use a lot CPU and crash the server.
It's likely NOT going to help to move to separate server if that's what's going...
--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)

March 25, 2016 at 8:11 am

#1867744
RE: Tree structure of parent child

You're welcome. Thank you for the feedback. The question now is... do you understand it so that you can maintain 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)

March 25, 2016 at 7:26 am

#1867737
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

peter-757102 (3/24/2016)
@jeff Moden,
These are two new functions I like to see, with a broader scope then just string splitting (but they are suited for it).
If I had these I would...
--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)

March 24, 2016 at 8:45 am

#1867462
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

peter-757102 (3/24/2016)
Out of pure frustration I will comment my idea here as the connect site is completely and utterly broken for me (can't post or comment even after signing in).
Hopefully...
--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)

March 24, 2016 at 8:00 am

#1867429
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

mburbea (3/23/2016)
I 100% agree that without a guarantee of ordering, or an explicit item ordinal the function is not complete.
However, I want to reiterate that the function does perform...
--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)

March 24, 2016 at 7:49 am

#1867422
RE: parent/child relationships

scottcabral (3/22/2016)
for example, in the tables above you will see that Policy 100024 was a renewal of Policy UK120241 effective 11-1-2014. Policy 100024 was also renewed and became Policy 1007441...
--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)

March 23, 2016 at 8:56 am

#1867115
RE: The New Men of IT

Them: "Where do you see me in 5 years?"
Me (in my mind, not spoken): "Don't know, don't care, so long as it's not here because you lied on your...
--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)

March 23, 2016 at 8:39 am

#1867104
RE: Insert Stored Procedure Results Into New Table Without Using OPENQUERY

I've reported the fact that the rating for this article appears to have been deleted as has all of the discussion that used to be on this thread. 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)

March 23, 2016 at 8:09 am

#1867089
RE: The Younger Generation

brannanliz (3/22/2016)
In college Database work was the last thing I wanted to do and SQL wasn't being taught yet. Databases sounded so boring. Then I needed a job, part time...
--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)

March 23, 2016 at 7:56 am

#1867083
RE: Looping and scalar value

drew.allen (3/22/2016)
I agree that there are cases where the order is important, but my point was that the number of cases is far smaller than most people think. Running...
--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)

March 23, 2016 at 6:50 am

#1867063
RE: Insert Stored Procedure Results Into New Table Without Using OPENQUERY

Damned Temp Tables... they're both the boon and the bane of stored procedures. :pinch:
--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)

March 22, 2016 at 11:15 am

#1866881
RE: Insert Stored Procedure Results Into New Table Without Using OPENQUERY

qbrt (3/22/2016)
Great read and thanks for taking the time to write it up and sharing.
Getting Jeff Moden's blessing and support is fantastic, as I value his opinions tremendously.
Thanks 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)

March 22, 2016 at 9:05 am

#1866829
RE: Insert Stored Procedure Results Into New Table Without Using OPENQUERY

To quote Phil McCracken...
"SQL Spackle" is a collection of short articles written based on multiple requests for similar code or to share short methods for getting certain things done. These...
--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)

March 22, 2016 at 8:42 am

#1866808
RE: Looping and scalar value

drew.allen (3/21/2016)
Eirikur Eiriksson (3/21/2016)
kuopaz (3/21/2016)
I see, thanks. As it's scanning the tally table row-by-row from start to the predicate value, the order of N may be important in some cases...
--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)

March 22, 2016 at 7:51 am

#1866781

Viewing 15 posts - 18,046 through 18,060 (of 59,102 total)