Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,816 through 46,830 (of 59,101 total)

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

LSAdvantage (12/3/2008)
I have been getting my daily SQLServerCentral.com emails and ashamedly skipping by them lately. I just had other stuff going on and hadn't lurked here in a while....
--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 3, 2008 at 9:35 pm

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

rbarryyoung (12/3/2008)
Great article, Jeff. Like The Return of the King, it was well worth the wait! 🙂
Heh... that has a familiar "ring" to it. 😛 Thanks 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)

December 3, 2008 at 9:15 pm

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

jcraddock (12/3/2008)
I've had better luck writing code that writes my SQL. I wrote a set of code that you point at any table, it accepts any column within 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)

December 3, 2008 at 9:07 pm

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

dphillips (12/3/2008)
Thank you for your efforts here Jeff. An article of this level takes hours to prepare, and the effort shows. Although I am an Analysis Server and...
--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 3, 2008 at 8:57 pm

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

mtassin (12/3/2008)
My favorite way to do cross-tabs is to cheat..
Put the data into a cross tab friend format (measures and values to break it out by)
and feed it into crystal...
--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 3, 2008 at 8:47 pm

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

mtassin (12/3/2008)
That was just an amazing read... learned some neat tricks that I didn't even think were possible (but in retrospect should have known)... very informative...
Thanks for the great...
--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 3, 2008 at 8:45 pm

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

Chris Morris (12/3/2008)
Top work, Jeff. You have a rare talent for mixing informal narrative with a technically challenging subject - and with ruthless precision 😎
Cheers
ChrisM
Now, there's a tag line I...
--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 3, 2008 at 8:31 pm

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

Carla Wilson (12/3/2008)
Awesome! Having spent years using all sorts of languages to prepare cross-tabs, I really love the results here.
I, too, went back and read the discussion on 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)

December 3, 2008 at 8:19 pm

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

Paul DB (12/3/2008)
I also enjoyed the article. I like that you include applications and explanations of best some practices, e.g. the discussion on using a SELECT instead of an...
--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 3, 2008 at 8:17 pm

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

Luke L (12/3/2008)
Another Great article Jeff. Very informative and useful.
-Luke.
Thanks, Luke. I appreciate the feedback! 🙂
--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 3, 2008 at 8:09 pm

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

Holy moly... good thing we're not doing deletes or it would also be deleting from a bazillion indexes (some with duplicate functionality). My recommendation would be to simply drop...
--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 3, 2008 at 8:06 pm

#907313
RE: Script to find the datafile size and logfile size?

madhu.arda (12/2/2008)
thanks Jeff,
This script is giving the mdf and ndf file. But I would like to get the actual space allocated for datafile and the available space inorder to monitor...
--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 3, 2008 at 7:29 pm

#907300
RE: What do you use to copy large backups

RichardB (12/3/2008)
Jeff Moden (11/29/2008)
Heh... not trying to be a smart guy here... FEDEX overnight. Works great.
Thats actually the solution I have recommended.... 😎
Heh... Simple, effective, and fast... no chance...
--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 3, 2008 at 7:25 pm

#907299
RE: decrypt sql server 2005 sp

Mad-Dog (5/26/2008)
ok i found script that use the DAC connection to decrypt SP and it's works great.
THX
Heh... two way street here, MD... share your solution. Where did you find...
--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 3, 2008 at 7:22 pm

#907297
RE: Import Excel File to SQL Database

philcart (12/3/2008)
Why you would want to do this in VB and SQL Server is beyond me. Like Jeff says, you don't need to go anywhere near the database 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)

December 3, 2008 at 7:20 pm

#907295

Viewing 15 posts - 46,816 through 46,830 (of 59,101 total)