Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,786 through 46,800 (of 59,095 total)

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

Kris (12/5/2008)
I was reading somewhere that instead of using cross tabs they used inner joins on same table, Is it save to assume that both Pivot and Cross Tabs preform...
--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)

December 5, 2008 at 5:20 pm

#908727
RE: Data Vices

Heh... I do smoke, but it's better than fuming. 😛 and, I drink about 3 to 4 quarts of coffee a day which is still less Caffeine than someone...
--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)

December 5, 2008 at 2:17 pm

#908676
RE: Data Vices

Sorin Petcu (12/5/2008)
Oh, I hate smoking and its effect!! There are many peoples here where I am working who go out of the building and smoke. This is wasting...
--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)

December 5, 2008 at 2:14 pm

#908675
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

That's part of the reason why people still use cross-tabs on the server side... "Respect the pipe!" 😛
--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)

December 5, 2008 at 6:08 am

#908210
RE: Recommended path for advanced training?

Brandie Tarvin (12/5/2008)
Yeah, Jeff'll never hire me. @=)
Jeff Moden (12/4/2008)
correct answer is NOT "When you think there's no other way"
Actually, I must point out that I've run into one...
--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)

December 5, 2008 at 6:03 am

#908205
RE: Advice for array oflarge arrays

Click on my name to the left of this post near my avatar... send me an email.
I'll be happy to look at it through email before you post...
--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)

December 5, 2008 at 5:46 am

#908191
RE: Convert Rows to columns so...

rog pike (12/4/2008)
Exec Rac
@transform='(Room) as Room',
@rows='[Floor]',
@pvtcol='Room',
@from='Rooms',
@defaults1='y',@rank='Room',@racheck='y',@shell='n'
Floor Room1 Room2 Room3 Room4 Room5 Room6
------- ----- ----- ----- ----- ----- -----
Floor 1 101 102 103 ...
--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)

December 4, 2008 at 11:06 pm

#908073
RE: UPDATE SET =NULL running over an hour

Heh... that code never get's past the first 10000... keeps updating the first 10000 over and over and over.
Lemme build a test table, write a bit of code, and I'll...
--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)

December 4, 2008 at 7:32 pm

#908042
RE: Look up a table fields, data type, etc.

bitbucket (12/4/2008)
And the gods of T-SQL preserve me
Pickle juice or formaldehyde? With or without pork chops? 😛
--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)

December 4, 2008 at 7:23 pm

#908040
RE: Poor Performance : Select count(*) takes 30 Mins ? Why ?

Sorry... I missed the fact that you were doing a count on the table... not returning rows... Got a PK or any decent indexes on the table?
--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)

December 4, 2008 at 7:15 pm

#908038
RE: performance while importing data

I never import directly into the final target table... I always use a staging table. That way, I can do validity checks before the new data actually get's added.
If...
--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)

December 4, 2008 at 7:12 pm

#908037
RE: SQL Query not returning records for today

SELECT RIGHT(GETDATE(),7)
--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)

December 4, 2008 at 7:07 pm

#908036
RE: Poor Performance : Select count(*) takes 30 Mins ? Why ?

No chance of using indexes... it's gonna return the whole table. How many rows are in the table? Also, are you sure it's a table and not 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)

December 4, 2008 at 6:45 pm

#908034
RE: Daily/Weekly reports for developers and app owners...

I tried sending server health reports to developers, once. The response was, "I already get enough email... would you stop sending these to me?" 😉
--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)

December 4, 2008 at 6:00 pm

#908031
RE: Convert Rows to columns so...

fausto usme (12/4/2008)
>>What about column names? With an indeterminate number of rooms, figuring out what to name the columns dynamically becomes an issue.
Exactly, the rooms in this hospital are...
--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)

December 4, 2008 at 5:54 pm

#908030

Viewing 15 posts - 46,786 through 46,800 (of 59,095 total)