Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,661 through 24,675 (of 59,099 total)

RE: Autogrowth, shrink and database performance

IgorMi (1/22/2014)
1) Yes, you can autogrow for 300 MB, however it's better to go with smaller sizes, let's say 50-70 MBs.
2) No, you should not shrink. They are all tiny....
--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)

January 24, 2014 at 3:07 pm

#1683283
RE: Cursor and update

DaveDB (1/24/2014)
...and anything that you can do in a cursor you can be accomplished in a loop and/or temp table.
A temp table and While Loop is just as bad...
--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)

January 24, 2014 at 2:50 pm

#1683274
RE: SSIS 2012 and DTEXEC Issue with xp_CmdShell

Thanks for sharing your answer. 🙂
--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)

January 24, 2014 at 2:43 pm

#1683271
RE: Need to create table relationships

ramadesai108 (1/24/2014)
Hello Jeff Moden,
What is not very clear to me is how to insert or delete data when the data is already existing in the hierarchy...
--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)

January 24, 2014 at 2:34 pm

#1683270
RE: Complex Query

I'm a little concerned for the mTVF that has a cursor in it. It'll be interesting to see how well that scales.
--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)

January 24, 2014 at 2:24 pm

#1683266
RE: Migration of SSIS from SQL 2005 to SQL 2012

sneumersky (1/24/2014)
MS definitely did a decent job of giving you backwards compatibility. We did our migration in three rather painless phases.
1. Co-opt with the main RDBMS migration.....doing the bare minimum...
--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)

January 24, 2014 at 2:20 pm

#1683263
RE: SCUD?

andrew gothard (1/24/2014)
netmikem (1/23/2014)
Thanks for the feedback.
The job ad definitely says SCUD. Here is the particular qualification statement ...
"Must have minimum eight years' experience with SQL, coding queries, SCUD, stored...
--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)

January 24, 2014 at 8:03 am

#1683136
RE: Running Total

Ford Fairlane (1/19/2014)
Thanks for the heads up Jeff, how would you tackle it then ?
I use the Quirky Update method and will probably continue to do so even after my...
--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)

January 23, 2014 at 10:16 pm

#1683001
RE: Need to create table relationships

Greg Edwards-268690 (1/21/2014)
Jeff's articles were very good.
Thanks Jeff!
Our hierarchy was 3 levels deep (Commodity Code) for an Item.
What was a different twist for us - we only assigned the bottom...
--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)

January 23, 2014 at 9:51 pm

#1682998
RE: Need to create table relationships

ramadesai108 (1/21/2014)
Hi Jeff Moden,
I truly appreciate your help. I am working on the the nested set. Only issue could be adding and deleting nodes where I...
--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)

January 23, 2014 at 9:49 pm

#1682997
RE: Migration of SSIS from SQL 2005 to SQL 2012

Koen Verbeeck (1/20/2014)
Jeff Moden (1/19/2014)
For me, you just added more reasons to the list of reasons why I don't like SSIS. 😉
That statement is not justified at all.
Why don't 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)

January 23, 2014 at 8:40 pm

#1682996
RE: Index fragmentation not cutting down to 0

GilaMonster (1/21/2014)
Jeff Moden (1/20/2014)
On the other hand, I've found that it almost takes the same amount of time to filter out such tables as it is to try to defrag...
--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)

January 23, 2014 at 8:28 pm

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

@Dinson,
If done correctly, there won't be any slowdown in the DB. The example I used was a million row example and it all worked in under a minute.
The key...
--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)

January 23, 2014 at 8:05 pm

#1682989
RE: Mastering Dimensions of Time

PHYData DBA (1/22/2014)
Jeff,
In reference to your comments about using date and time data types.
How would you recommend we take a date value and a time value and convert them 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)

January 23, 2014 at 7:44 pm

#1682988
RE: Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)

Andy DBA (1/23/2014)
Jeff Moden (1/23/2014)
If the quotes are consistent in the column, then you are, in fact, missing out on a format file option that MS didn't document because...
--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)

January 23, 2014 at 7:15 pm

#1682984

Viewing 15 posts - 24,661 through 24,675 (of 59,099 total)