Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,626 through 41,640 (of 59,067 total)

RE: Auto update stats not good enough

Now hold on a minute... you said that updating the stats helped just a bit and you also said that the table is highly transactional. I suspect that 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 5, 2009 at 9:53 pm

#1062081
RE: Update or Create Table from 2Million row table, only when 3 column concatenation is unique or Changes

Heh... you're sure? That's an SQL Server 2005 solution and this is and SQL Server 2000 forum. Even for 2k5, though, it seems a bit complex compared 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 5, 2009 at 9:40 pm

#1062080
RE: INSERT INTO vs. SELECT for inputting values

mgodinez (10/5/2009)
Excellent article by the way.
Thanks for the kudo, Mike. I appreciate it.
--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 5, 2009 at 9:28 pm

#1062079
RE: INSERT INTO vs. SELECT for inputting values

I use it a lot in demonstration code for two reasons...
1. It cuts down on the actual visual clutter and takes less horizontal and vertical space.
2. I'm lazy....
--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 5, 2009 at 9:23 pm

#1062078
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Carla Tillman (10/5/2009)
Hi Jeff,
Thanks for the article! Good Stuff. I was just confused by one aspect.
(I am not a DBA so if my question shows ignorance, be patient/gentle! ;-)...
--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 5, 2009 at 8:10 pm

#1062062
RE: Are the posted questions getting worse?

Jan Van der Eecken (10/5/2009)
Thanks, now I can pour away my glass of red coz I spewed my nasal excrements into it.
Ah, you need to become a member 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 5, 2009 at 6:39 pm

#1062056
RE: Are the posted questions getting worse?

Jan Van der Eecken (10/5/2009)
"What are some uses of Dihydrogen Monoxide?"
Heh... the very same as Hydrogen Hydroxide. "Oh bartender! Can you fix me a Perrier and water, please?"...
--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 5, 2009 at 4:56 pm

#1062037
RE: The multi-part identifier could not be bound

Jeff Moden (10/5/2009)
Try changing the derived table aliases to something besides actual table names and see if the fixes it.
Never mind... I missed the V_ in the derived tables.
--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 5, 2009 at 9:07 am

#1061805
RE: The multi-part identifier could not be bound

Try changing the derived table aliases to something besides actual table names and see if the fixes it.
--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 5, 2009 at 9:05 am

#1061803
RE: Certification choice-Dev or BI advice please!!

"When you come to a fork in the road, take it." --"Yogi" Berra
--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 5, 2009 at 8:15 am

#1061751
RE: Comma separated Value

I still want to know why the OP wants to do this type of denormalization, though...
--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 5, 2009 at 8:14 am

#1061748
RE: master..xp_cmdshell works. But Exec master..xp_cmdshell doesn't work

But if i remote login to the server, it works
I'm pretty sure that's the nature of the beast and you won't be able to do much about that. This...
--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 5, 2009 at 8:05 am

#1061741
RE: Comma separated Value

I'm glad that someone else realizes how comparatively slow COALESCE is compared to ISNULL or a preset empty string.
However, my real question to the OP is (drum roll, please)... why...
--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 5, 2009 at 7:59 am

#1061734
RE: The multi-part identifier could not be bound

"Must look eye"...
ON WIP_DTL_HIST.DATE_WRK =DAILY_SCRAP.SFT_DATE
AND WIP_DTL_HIST.PAYROLL_SFT_WRK=DAILY_SCRAP.SFT_NUM
AND WIP_DTL_HIST.PART_NUM=DAILY_[highlight]SCARP[/highlight].PART_NUM
AND WIP_DTL_HIST.WKC=DAILY_SCRAP.WC_NUM
--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 5, 2009 at 7:50 am

#1061723
RE: Dictionary Table

I don't believe that you'll find anything about indexes or columns or a couple of other things in SysObjects. Even the sys.All_Objects in Master doesn't contain everything.
--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 5, 2009 at 7:27 am

#1061703

Viewing 15 posts - 41,626 through 41,640 (of 59,067 total)