Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,341 through 38,355 (of 59,072 total)

RE: Precious Ideas

Oh no... I understand what you're talking about and I wasn't talking about theft of "ideas"... I was talking about outright theft of code (just like plagarism) to actually start...
--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)

May 16, 2010 at 7:34 pm

#1168094
RE: Code generation

Heh... typical... OP wants a "miracle" and gets it. OP is never heard from again especially if you ask a favor in return. Oh well... next problem,...
--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)

May 16, 2010 at 6:57 pm

#1168092
RE: Code generation

Adam Gojdas (5/13/2010)
Cool stuff! I definitely learn a lot from Jeff's code. So thanks Jeff!
It might be nice to change this very slightly:
,
cteCharacters AS
( --=== This is...
--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)

May 16, 2010 at 6:45 pm

#1168089
RE: Code generation

mister.magoo (5/13/2010)
Brilliant answer Jeff!
I like this a lot, but every time I see NEWID() used like this it just makes me yearn for a decent random number generator so that...
--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)

May 16, 2010 at 6:39 pm

#1168088
RE: How to Convert Rows into Columns?

Actually, you can get very sophisticated with this type of thing and it can all be done "auto-magically" with a bit of dynamic SQL. Please see the following article...
--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)

May 16, 2010 at 6:22 pm

#1168086
RE: Database Size Increase After Index Rebuild

rob 58081 (5/16/2010)
Hi
I recently perfomed an Index Rebuild using a Maintenance Plan on a large table in my database because it was 91% fragmented. After the Index Rebuild the database...
--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)

May 16, 2010 at 6:14 pm

#1168085
RE: Blocking Issue?

GilaMonster (5/16/2010)
Jeff Moden (5/16/2010)
GilaMonster (5/16/2010)
mike 57299 (5/16/2010)
I have tested this issue by issuing an INSERT command in the command window. It hangs until I use the task manager 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)

May 16, 2010 at 6:00 pm

#1168084
RE: Five Things to Trim From SQL Server

Steve Jones - Editor (5/16/2010)
I'm not sure it's the weakest link, but it's a weak one. Brent had a good rant on things being buried, not clean, some dialogs getting...
--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)

May 16, 2010 at 5:52 pm

#1168083
RE: Five Things to Trim From SQL Server

sjsubscribe (5/16/2010)
Jeff Moden (5/16/2010)
sjsubscribe (5/16/2010)
SSMS is probably the weakest link in the entire SQL tool chain.
How so?
Compared to the stability and usability of Enterprise Manager it replaced, there's no contest....
--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)

May 16, 2010 at 5:50 pm

#1168082
RE: Blocking Issue?

GilaMonster (5/16/2010)
mike 57299 (5/16/2010)
I have tested this issue by issuing an INSERT command in the command window. It hangs until I use the task manager to kill the exe...
--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)

May 16, 2010 at 4:40 pm

#1168072
RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

@paul-2 White,
Hey Paul... just so you don't think I'm blowing smoke (I know you don't but it makes me feel better to prove I'm not) or have lost my mind...
--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)

May 16, 2010 at 4:13 pm

#1168069
RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

Joe Celko (5/16/2010)
Jeff Moden (5/15/2010)
Better yet... I'm going to bow out of this thread. I swore to myself that I wasn't going to show any of my new methods...
--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)

May 16, 2010 at 4:03 pm

#1168068
RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

Joe Celko (5/16/2010)
>> you wish, move a branch using the HierarchicalID method and compare that to how easy it is to move a branch for the Adjacency method. Or,...
--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)

May 16, 2010 at 3:35 pm

#1168065
RE: Blocking Issue?

mike 57299 (5/16/2010)
When I run it from DOS, it works fine. No hang. Debug messages get written. It hangs on the 'update web_processing_queue...' statement.
Mike
Hmmm... does the app...
--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)

May 16, 2010 at 2:49 pm

#1168058
RE: Blocking Issue?

Ok... The next step is to find out where the hanging occurs...
What happens if you run the .exe command from a DOS window?
--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)

May 16, 2010 at 12:36 pm

#1168042

Viewing 15 posts - 38,341 through 38,355 (of 59,072 total)