Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,656 through 41,670 (of 59,102 total)

RE: SSMS Continously Locks up for short periods

I don't know what it's called in Vista but turn on the equivalent of TaskMgr and see what the cpu and kernal are doing. If the cpu is pegging,...
--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 10:21 pm

#1062090
RE: Pivoting test results with SQL Server

It would also help if the documented code matched the documented results.
--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 10:07 pm

#1062088
RE: Update row with substring from another row.

Then you'll like this pro tip... what you are apparently calling rows are really columns.
--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 10:04 pm

#1062087
RE: Totally Caching a Frequent Query for Maximum Performance

Post the query.
--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 10:01 pm

#1062084
RE: substring NOT working

Francis Yee-483501 (10/5/2009)
Guys, thank you for the efforts and I got the solution already.
Thanks again.:satisfied:
Cool. Can you post your solution, 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 9:57 pm

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

Viewing 15 posts - 41,656 through 41,670 (of 59,102 total)