Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,196 through 21,210 (of 59,072 total)

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

I've never had a performance problem because of such switches but if I were forced at gunpoint to make a conjecture, I would unfortunately still have to say I don't...
--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, 2015 at 8:05 pm

#1785598
RE: Finding Beginning Date from multiple lines of date ranges

Thanks, Eirikur, but the brilliance is not mine. I'm just translating the work of the truly brilliant Itzik Ben-Gan.
Speaking of brilliant, using CHECKSUM() to convert the VARCHAR(30) ID 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)

March 22, 2015 at 7:58 pm

#1785596
RE: Using WHILE to avoiding Cursor

My pleasure, good Sir. Thank you for the feedback.
My question now is do you have any questions about how the solution I provided actually works?
--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, 2015 at 2:19 pm

#1785585
RE: Finding Beginning Date from multiple lines of date ranges

As a bit of a sidebar, storing the "guaranteed to be 7 digits" ID in a VARCHAR(anything) data-type is not what I would do. At the very least, 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, 2015 at 1:34 pm

#1785583
RE: Finding Beginning Date from multiple lines of date ranges

One of the major faults with requirements like this is that the problem definition is based on given data and people code to only the conditions in the given data....
--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, 2015 at 12:32 pm

#1785581
RE: the Size of DB became very big , any idea to cut it to smaller

wagdy_maher (3/21/2015)
its DB for online system ,I can take it down for one hour in the week end
it's normal single server no HA till now
Data size 300...
--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 21, 2015 at 9:03 pm

#1785539
RE: Sql Insert in Batches

Also be aware of the "tipping point" that every server has. Depending on a seemingly intangible and tangible set of multiple factors, 1 million rows might insert in just...
--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 21, 2015 at 8:26 pm

#1785537
RE: Using WHILE to avoiding Cursor

First of all, you didn't read the article that Alex Suprun provided the link to above. Go back to his post, click on the link, and read that article....
--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 21, 2015 at 8:18 pm

#1785536
RE: Who is using source control?

We don't use source control for the classic reasons that someone might use source control. We use them to keep code related to a single change together and 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)

March 21, 2015 at 7:47 pm

#1785535
RE: Rebuild index

Barcelona10 (3/20/2015)
rebuild----defrag(space issue)
shink------frag.
rebuild----defrag(space issue)
shink------frag.....
Just to be sure, if you shrink the database, do a REORGANIZE instead of a REBUILD (reorg is done in place rather than separately so causes nearly...
--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 21, 2015 at 2:46 pm

#1785526
RE: Add 15 minutes to a time in char format

CELKO (3/20/2015)
If you like math, here is a link to “interval algebra” and other options for the math:
http://www.ics.uci.edu/~alspaugh/cls/shr/allen.html
Good golly! No wonder many programmers hate temporal math! Allen even...
--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 21, 2015 at 2:04 pm

#1785522
RE: Bulk Insert (How do I find my rowterminator?)

DKY (3/21/2015)
I think I may have figured out a work around.
> I bulk insert the entire file into a one column table
> I then bcp the data into three different...
--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 21, 2015 at 9:42 am

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

Thanks for the question, Dwain. It's real simple.
Assuming that you already have a hierarchy table (We'll call it "H" for this example and all names will be greatly simplified....
--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 20, 2015 at 8:04 am

#1785354
RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

sarat_reddy (9/19/2014)
Remember trying this a while back. updates took a long time. also correcting data was difficult. Prefer an adjacency list with a lineage column method
That's why the article suggests...
--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 20, 2015 at 7:45 am

#1785348
RE: SQL Query Divide Amount between months

CELKO (3/19/2015)
The goal of any tiered architecture is to do all display formatting in a presentation layer; you embed it in the base table.
{snip}
Most encoding schemes use fixed...
--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 19, 2015 at 11:15 pm

#1785274

Viewing 15 posts - 21,196 through 21,210 (of 59,072 total)