Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,226 through 21,240 (of 59,098 total)

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
RE: Rebuild index

Barcelona10 (3/19/2015)
hi ,
Is it possible to reclaim space after rebuilding indexes(shrinking is not an option).
Thank you advance
No. Not directly. And the indirect method is a huge PITA.
Are you...
--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 9:51 pm

#1785266
RE: Common Mistakes

According to the interviews that I've done in the last 3 years of Front-End Developers, Database Developers, and DBAs, the biggest mistake made is not knowing what they don't know...
--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 9:35 pm

#1785265
RE: Update with Recursive CTE?

NP. At least this ol' brain remembered who showed me. Thanks for the confirmation. 😛
The numeric method won't work on VARCHARs that have non-digit-only characters in them 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)

March 19, 2015 at 9:08 pm

#1785263
RE: Report Builder 3.0 Expression to extract 2 parts of a string

Apologies for the extreme delay. The following demonstrates one way to do this.
--===== This just creates a table and populates it with sample data all on the fly.
...
--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 8:44 pm

#1785262

Viewing 15 posts - 21,226 through 21,240 (of 59,098 total)