Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,536 through 8,550 (of 59,091 total)

Reply To: Is SSIS really that bad?

To be clear, I've not worked with SSIS beyond the tiny little maintenance plans that I used to make many years ago and so most of my "evidence" is anecdotal...
--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)

October 20, 2019 at 4:16 pm

#3690449
Reply To: Using a Surrogate vs Natural Key

jcelko212 32090 wrote:
Codd never says anything about the physical implementation. This abstraction makes soooo many different implementations. 🙂
That's what I was getting at. You said that "What he had in mind...
--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)

October 17, 2019 at 7:48 pm

#3689902
Reply To: CPU Usage high

Admingod wrote:
No much activity on the server and CPU usage is not dropping to normal CPU Usage. Would restarting the server would be the only option? However, one of 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)

October 17, 2019 at 6:33 pm

#3689883
Reply To: SQL profiler

On the subject of index maintenance...
I went for 2.5 years with virtually no index maintenance on my production box. With that I can tell you that it IS more important...
--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)

October 17, 2019 at 6:31 pm

#3689882
Reply To: Using a Surrogate vs Natural Key

Thanks, Joe. As you've just shown, while Dr. Codd does express that it should be similar to an index, it does NOT, however, say anything explicit about it intending 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)

October 17, 2019 at 5:03 pm

#3689819
Reply To: Very large t-log with backups

Are you doing index maintenance on this database? And, if you are, are you making the mistake of following the supposed "Best Practice" recommendation of "REORGANIZE between 10% (or 5%)...
--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)

October 16, 2019 at 11:49 pm

#3689500
Reply To: Using a Surrogate vs Natural Key

jcelko212 32090 wrote:
Dr. Codd defined a surrogate key as being generated by the database engine and never exposed to the users. What he had in mind would be more like a...
--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)

October 16, 2019 at 11:35 pm

#3689498
Reply To: Outer Joins

When you're doing an "Upsert". That is, you're checking to see if rows already exist or not to know whether you have to do an INSERT or an UPDATE.
--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)

October 15, 2019 at 9:05 pm

#3689079
Reply To: Changing Credentials

Rechana Rajan wrote:
Jeff Moden wrote:
Rechana Rajan wrote:
Thanks Michael, both the reasons you mentioned are valid for SQL Accounts but Service Account and Admin Accounts are strictly with DBAs and Windows Admins.
If you're sharing...
--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)

October 15, 2019 at 2:12 pm

#3688891
Reply To: Gathering Business Requirements and Determining Database Schemas

CoolKid40 wrote:
What is simplest way to go about gathering business requirements and determining database schemas?
Create a functional flow diagram.
--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)

October 14, 2019 at 11:23 pm

#3688737
Reply To: 3rd party vendor performance issue

We went through that same issue because they went cheap on the RO node storage. They also forgot to do things like change the settings for parallelism, etc.
--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)

October 14, 2019 at 1:49 pm

#3688485
Reply To: Changing Credentials

Rechana Rajan wrote:
Thanks Michael, both the reasons you mentioned are valid for SQL Accounts but Service Account and Admin Accounts are strictly with DBAs and Windows Admins.
If you're sharing the passwords...
--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)

October 13, 2019 at 4:08 pm

#3688309
Reply To: set up data archiving

Maybe you can simply modify the vendor's purge job by adding OUTPUT/INTO to their deletes to write to your archive tables. It would save you from reinventing the wheel.
Be advised...
--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)

October 13, 2019 at 5:03 am

#3688272
Reply To: Partitioning Table FileGroups Question

Step #1 is to identify WHY you think you want to partition a table. So WHY do you want to partition whatever table you're working with? What are some of...
--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)

October 13, 2019 at 4:47 am

#3688270
Reply To: 3rd party vendor performance issue

Sounds like a stupid question but what condition are the index and column statistics in?
--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)

October 13, 2019 at 4:44 am

#3688269

Viewing 15 posts - 8,536 through 8,550 (of 59,091 total)