Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,681 through 19,695 (of 59,072 total)

RE: Newbie saying Hi

Welcome aboard!
--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 8:28 am

#1824008
RE: Interesting Design Issue

mar.ko (9/2/2015)
Call center data - large volume....millions of rows.
When a sale is made, a column value is established with the Lead ID in the source data table.
I need to set...
--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 8:27 am

#1824006
RE: Formatting a date affecting MIN

John Mitchell-245523 (9/2/2015)
Yes, or just do the conversion after calculating the minimum:
CONVERT(varchar(17),MIN(a.orderdue),103)
This has the added advantage that it only has to do the conversion once (on the minimum date) instead...
--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 8:23 am

#1824005
RE: File group is running out of space frequently.

Alvin Ramard (9/1/2015)
EasyBoy (9/1/2015)
Thanks for your prompt response. I understand that we can't limited to growth. But, this is how they implemented tempdb. According to technet.microsoft if we have 200...
--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 8:17 am

#1824000
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

Viewing 15 posts - 19,681 through 19,695 (of 59,072 total)