Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,711 through 19,725 (of 59,098 total)

RE: What Kind of DBA Are You?

jasona.work (9/1/2015)
Jeff Moden (8/31/2015)
The percentages are a bit funny. At this particular time, 8 of 8 of the respondents selected "Production Support/Admin" but the numbers are all handled as...
--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)

September 2, 2015 at 6:32 am

#1823947
RE: How to Perform Update Query that Involves Multiple Tables?

I agree with Lynn. Please post the entire error message exactly as it is returned. Also, have you actually verified that the objects exist by checking sys.objects?
--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)

September 1, 2015 at 5:39 pm

#1823837
RE: How to Perform Update Query that Involves Multiple Tables?

Steve Jones - SSC Editor (8/31/2015)
You can add tables in your update statement and join them, as shown here:
update table1
set x = y
from table 2
where table1.pk =...
--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)

September 1, 2015 at 5:35 pm

#1823836
RE: Are the posted questions getting worse?

SQLRNNR (9/1/2015)
Sean Lange (9/1/2015)
Sean Lange (9/1/2015)
Alvin Ramard (9/1/2015)
Sean Lange (9/1/2015)
Alvin Ramard (9/1/2015)
SQLRNNR (9/1/2015)
GilaMonster (9/1/2015)
Ed Wagner (9/1/2015)
ZZartin (9/1/2015)
Steve Jones - SSC Editor (9/1/2015)
Passwords: http://www.pcworld.com/article/2978316/security/tired-of-memorizing-passwords-a-turing-award-winner-came-up-with-this-algorithmic-trick.html
Now if only all websites used the same...
--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)

September 1, 2015 at 4:45 pm

#1823835
RE: Pivot Table Help Needed

tnpich (9/1/2015)
I have code that creates a pivot table from a view and then appends a summary row with a UNION ALL.
I need to take the above output and put...
--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)

September 1, 2015 at 1:02 pm

#1823770
RE: Percentage of Fragmentation increased after 6 hours

coolchaitu (9/1/2015)
Good morning Gail Shaw Madam and Everyone,
To confirm that an index is unused, should the values for seeks,scans,lookups and updates be zero. That is, only if
seeks=0 and scans=0...
--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)

September 1, 2015 at 8:30 am

#1823643
RE: What Kind of DBA Are You?

The percentages are a bit funny. At this particular time, 8 of 8 of the respondents selected "Production Support/Admin" but the numbers are all handled as single votes so...
--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)

August 31, 2015 at 5:45 pm

#1823521
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (8/31/2015)
I'm not sure this is as big a deal as some people have written. Hard to decide if this is journalism run amok for 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)

August 31, 2015 at 3:49 pm

#1823507
RE: The Problem Solver

JustRightOfCenter (8/31/2015)
@jeff Moden, I am a "developer" (21 years experience, 20.5 years SQL experience). No excuses here. I say if you are currently in this kind of situation...
--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)

August 31, 2015 at 3:44 pm

#1823504
RE: Help Needed in Performance Tuning

KGJ-Dev (8/30/2015)
Regarding the point #1 - I have transactionNumber column in the testdump table and i am generating this number based on file data. Sorry that i didn't mention 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)

August 30, 2015 at 10:18 pm

#1823292
RE: Analyzing CPU value in profiler.

Joy Smith San (8/30/2015)
Checking with database Engine Tuning Adviser as well.
Be very careful when using the DTA. It should be taken with a very small grain of salt. ...
--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)

August 30, 2015 at 9:48 pm

#1823291
RE: Add Total Row For Each Name

JoseMenendez (8/29/2015)
The name can be, but will not always be the 2nd word in the string. It will be 1 of 8 names, and if none of those names...
--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)

August 30, 2015 at 3:23 pm

#1823281
RE: The Problem Solver

Conversations like this strike me in an odd way. If there's a performance problem, the first thing people do is blame the database and if it takes more than...
--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)

August 30, 2015 at 2:25 pm

#1823277
RE: Not Exist causing major performance problem

and not exists (select * from ContractorCoverageException cce where cce.contractorcoverageid = a.id and postalid = postal.id)
--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)

August 30, 2015 at 1:50 pm

#1823276
RE: Help Needed in Performance Tuning

Doing a much deeper dive on everything that you've presented so far and being a bit of a troubleshooter, I'm having a logical problem with a point or two on...
--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)

August 30, 2015 at 1:00 pm

#1823274

Viewing 15 posts - 19,711 through 19,725 (of 59,098 total)