Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,831 through 19,845 (of 59,072 total)

RE: Changing roles

Koen Verbeeck (8/18/2015)
Jeff Moden (8/18/2015)
The correct answer is "It Depends" on which version of SQL Server you're using. 😉
When not explicitly mentioned, the last version that is publicly available.
Heh... yeah......
--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)

August 18, 2015 at 9:51 am

#1820803
RE: Delete XML data

PJ_SQL (8/18/2015)
I have a table which has XML data, so it takes lot of time to delete it.
Here's the condition:
Archive all data older than 2 months and delete it.
What 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)

August 18, 2015 at 8:12 am

#1820757
RE: The Tally Table

Iwas Bornready (8/18/2015)
Though I have used a tally table a few times, it really is rare for me. I've heard so many people say how great they are so need...
--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)

August 18, 2015 at 8:08 am

#1820751
RE: The Tally Table

Eric M Russell (8/18/2015)
Jeff Moden (8/18/2015)
Alan.B (8/17/2015)
Jeff Moden (8/14/2015)
Alan.B (8/14/2015)
BobAtDBS (8/14/2015)
I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do...
--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)

August 18, 2015 at 8:02 am

#1820746
RE: Nope to NoOps, No way to NoDBA

MWise (8/18/2015)
Jeff Moden (8/17/2015)
robert.sterbal 56890 (8/17/2015)
A wiki for people in technology to document issues might be a helpful tool in learning from our mistakes.
Does anyone use one?
We do. It's...
--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)

August 18, 2015 at 7:44 am

#1820732
RE: The Tally Table

Alan.B (8/17/2015)
Jeff Moden (8/14/2015)
Alan.B (8/14/2015)
BobAtDBS (8/14/2015)
I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do at the TSQL level very...
--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)

August 18, 2015 at 7:37 am

#1820721
RE: The Tally Table

J Livingston SQL (8/18/2015)
Alan.B (8/17/2015)
Jeff Moden (8/14/2015)
Alan.B (8/14/2015)
BobAtDBS (8/14/2015)
I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do at 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)

August 18, 2015 at 7:31 am

#1820717
RE: Filtering on multiple input pairs

Pagan DBA (8/18/2015)
Thanks guys, but like I said in my original post I already know processing account transaction delta one at a time is slow. Hence this post.
And, I can...
--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)

August 18, 2015 at 7:25 am

#1820712
RE: Changing roles

The correct answer is "It Depends" on which version of SQL Server you're using. 😉
--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)

August 18, 2015 at 12:42 am

#1820622
RE: Recursively select records in single table when having main categoryid and textvalue of subcategory

sqlserverstarter (8/17/2015)
Thanks all! I marked the answer to my original question as the solution. Seeing the simplicity of the query provided by AKIMwilliams I did end up making sure 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)

August 17, 2015 at 9:37 pm

#1820608
RE: Filtering on multiple input pairs

Pagan DBA (8/12/2015)
It's been going well processing the transaction delta[font="Arial Black"] one account number at a time
[/font]
That would be the real problem.
--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)

August 17, 2015 at 2:21 pm

#1820582
RE: Recursively select records in single table when having main categoryid and textvalue of subcategory

AKIMwilliams (8/17/2015)
Below is a little script I created which seems to work the way you want. Check it out and see if it works for you.
declare @item varchar(50) = 'headrest'
;with...
--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)

August 17, 2015 at 12:18 pm

#1820538
RE: Nope to NoOps, No way to NoDBA

robert.sterbal 56890 (8/17/2015)
A wiki for people in technology to document issues might be a helpful tool in learning from our mistakes.
Does anyone use one?
We do. It's also the most...
--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)

August 17, 2015 at 12:14 pm

#1820535
RE: Small Money, Money, Float - what's the best

Sean Lange (8/11/2015)
RonKyle (8/11/2015)
If you're going to use the decimal data type, you should probably go to 4 decimal places. There is rounding that needs to take place behind...
--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)

August 17, 2015 at 8:23 am

#1820449
RE: substitute line breaks for

mick burden (8/17/2015)
With help from a colleague I've come up with the following that works.
SET NOCOUNT ON;
SET DATEFORMAT...
--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)

August 17, 2015 at 8:15 am

#1820447

Viewing 15 posts - 19,831 through 19,845 (of 59,072 total)