Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,126 through 16,140 (of 59,067 total)

RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Thanks, Damian. I appreciate 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)

December 7, 2016 at 9:14 pm

#1916669
RE: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

faredoon (12/7/2016)
I was thinking more along the lines of a "live" app that constantly displays the hierarchical tree nodes and allowing live edits. It's a situation where the reporting is...
--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 7, 2016 at 5:47 pm

#1916657
RE: How many megabytes is 128 GB?

Gail Wanabee (12/7/2016)
The server has 160 GB of physical RAM.
P.S. Thanks for the warning. Don't ask me why I appreciate your admonition so much.
If that's the case and it's Standard...
--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 7, 2016 at 5:44 pm

#1916656
RE: Database Size After Deleting 200-million rows

Eric M Russell (12/7/2016)
alex.sqldba (12/7/2016)
Hi Eric,
Whilst it is not a heap, there is a clustered index on a datetime field, I am curious as to how one would go about...
--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 7, 2016 at 5:09 pm

#1916655
RE: How many megabytes is 128 GB?

Gail Wanabee (12/7/2016)
So, what is the appropriate setting in the Server Properties GUI, Memory page section, for the "Maximum server memory (in MB):" entry, to max the RAM allocation 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)

December 7, 2016 at 4:55 pm

#1916652
RE: Are the posted questions getting worse?

This Saturday, 12/10, marks the anniversary of a very unhappy event for me. It's the day that Dwain Camps fell to cancer. Dwain was a remarkable author...
--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 7, 2016 at 7:02 am

#1916503
RE: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

faredoon (12/6/2016)
Hi Jeff. Excellent article and techniques.
One question: What would be the best way to use this when we expect CRUD operations on the Employee list. Take a typical app...
--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 7, 2016 at 6:26 am

#1916492
RE: Split list of string into all possible combinations

Shifting gears back to the problem at hand, will there ever be CSVs with more than 3 elements?
--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 6, 2016 at 6:03 pm

#1916390
RE: Split list of string into all possible combinations

N_Muller (12/6/2016)
Jeff Moden (12/6/2016)Can you post a copy of the FN_ListToTable_8K function so that we can try out your code? Thanks.
CREATE FUNCTION [dbo].[FN_ListToTable_8K]
(
@listVARCHAR(8000),
@delimiterCHAR(1)
)
RETURNS TABLE WITH SCHEMABINDING
AS
RETURN
--
-- Thist function has...
--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 6, 2016 at 6:01 pm

#1916389
RE: relative performance sizing/estimation

sqlguy-736318 (12/6/2016)
I'm trying to understand relative sizing for[font="Arial Black"] design conversation purposes[/font]. For example, in this context, would it be reasonable to state that?:
* Selecting 1 row from 1...
--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 6, 2016 at 5:54 pm

#1916388
RE: Split list of string into all possible combinations

N_Muller (11/30/2016)
Alan.B (11/29/2016)
My solution can be totally optimized and simplified but here's a solution that uses DelimitedSplit8K (see the link in my signature):
You'll notice three UNION ALL's. The first query...
--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 6, 2016 at 3:24 pm

#1916381
RE: Pages Read & Written by a single query

sgmunson (12/6/2016)
r5d4 (12/6/2016)
I'm working in an environment where some very wide tables are present (400+ columns).
Whilst long term I will be restructuring these and applying some normalization, I 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)

December 6, 2016 at 8:47 am

#1916262
RE: Converting time - from "seconds after midnight"

sgmunson (12/6/2016)
Jeff Moden (12/5/2016)
sgmunson (12/5/2016)
Jeff Moden (12/5/2016)
sgmunson (12/5/2016)
Jeff Moden (12/5/2016)
Lynn Pettis (12/5/2016)
Jeff Moden (12/3/2016)
tacy.highland (12/2/2016)
The only thing I have against these nice simple answers:
As you can see, the neat thing...
--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 6, 2016 at 7:54 am

#1916237
RE: relative performance sizing/estimation

sqlguy-736318 (12/5/2016)
I'm trying to get a better understanding of relative performance expectations for different types of queries. For example, given a typical SS configuration, what type of response 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)

December 6, 2016 at 7:36 am

#1916230
RE: Troubleshooting

tarr94 (12/5/2016)
Thank you for the suggestions so far!
There have been questions about whether the size increase relates to the data or log file. I can confirm that the sys.master_files.size...
--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 6, 2016 at 7:25 am

#1916223

Viewing 15 posts - 16,126 through 16,140 (of 59,067 total)