Jeff Moden

Forum Replies Created

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

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
RE: Processing a non-locked row update from within a TRANSACTION

John Barry (12/3/2008)
Jeff,
So are you saying that instead of creating a row at a time in the live table, stamping each one with a sequence number as you insert 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)

December 3, 2008 at 7:13 pm

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

Yes... everything is possible... but what are you going to do if there are 40 rooms on the same floor?
--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 6:57 pm

#907282
RE: Visual Basic code to write the last time a Table was updated in a DB

umanpowered (12/3/2008)
rbarryyoung (11/3/2008)
As Jonathan said: "getdate()" needs to be the definition of the column's default value, and not the definition of the column itself.
Hi,
As a side question, do you know...
--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 6:52 pm

#907280
RE: Determine if parameter is passed or DEFAULT

David Leaver (12/3/2008)
Yikes - Dip, Dive, Duck and Dodge! Doesn't pay to leave the forums for a few hours.
Here's the scenario - I'm taking an existing procedure that historically...
--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 6:41 pm

#907279
RE: Determine if parameter is passed or DEFAULT

Trebuchet... the ultimate pork chop launcher... can launch the whole pig and makes statements followed by "When pigs fly" come absolutely true. 😛
--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 6:37 pm

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

I see a bunch of stuff in that code snippet that I think is working against you. Please post the real table creationtion statement for the table you're deleting...
--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 6:20 pm

#907275

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