Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,371 through 38,385 (of 59,098 total)

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
RE: Table locking?

Nah... you're alright. The post I left above will direct people to the original thread.
Just so you know, a lot of the heavy hitters don't look at the individual...
--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:33 pm

#1168041
RE: Blocking Issue?

Yes... step 1... fix the following code... "ID" isn't a valid datatype unless they've done something really different in 2k8 or you have a user type squirreled away somewhere 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 12:26 pm

#1168036
RE: Table locking?

Please... no posts here so we don't split up any answers that may come down the pipe... the original post is at the following URL...
http://www.sqlservercentral.com/Forums/Topic922564-391-1.aspx
Mike... don't double post. 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)

May 16, 2010 at 12:23 pm

#1168035
RE: what are the roles and responsibilities of sql server dba job?

Lowell (5/16/2010)
i just saw something with that same question here that woudl probably answer the question more completely.
😀
--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:18 pm

#1168034

Viewing 15 posts - 38,371 through 38,385 (of 59,098 total)