Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,241 through 27,255 (of 59,101 total)

RE: new to calling procedures or scripts

As for the xp_CmdShell thing, if you're afraid to use it on your system, then you either don't know how to use it correctly or your system isn't secure 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)

March 14, 2013 at 6:23 pm

#1597305
RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

Thanks for the feedback. Basically, great minds think alike because all I did was make a "mapping" table. You could certainly incorporate that into your original employee 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)

March 14, 2013 at 5:19 pm

#1597298
RE: An Orders of Magnitude Problem (T-SQL Tuning)

Tom_Sacramento (3/13/2013)
Hi Jerry,
I appreciate this article not just for the technical elements but for the deductive reasoning that identifies the problem from the noise. This is a very good guide...
--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)

March 13, 2013 at 11:01 pm

#1596820
RE: An Orders of Magnitude Problem (T-SQL Tuning)

Jerry_Manioci (3/13/2013)
Jeff,
Divide/conquer is great advice and I expect it would have worked in this situation as well. I absolutely agree FORCE ORDER typically won't be the right approach for...
--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)

March 13, 2013 at 10:55 pm

#1596818
RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

Here's one way. I apologize for not taking the time to make a more optimal solution but it's been a long day and I'm too pooped to pop.
Basically, you...
--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)

March 13, 2013 at 10:31 pm

#1596810
RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

LordHz (3/13/2013)
Jeff, I have been playing with your RebuildNestedSets_MM stored procedure and I have a question. Is it possible to sort the nodes so that the Left and Right bowers...
--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)

March 13, 2013 at 9:55 pm

#1596799
RE: An Orders of Magnitude Problem (T-SQL Tuning)

What a great article! It shows the incredible thought process and the tenacity a true professional has in the world of SQL Server. Nice job and congrats on...
--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)

March 13, 2013 at 6:36 am

#1596468
RE: Resetting DMVs

That got me thinking. Why is this data removed? I'm sure some of the data is stored in memory and automatically reset, but is this the best way to handle...
--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)

March 13, 2013 at 5:50 am

#1596449
RE: Cloud Services. Waiting for the 'paint to dry'?

Phil Factor (3/11/2013)
@jeff
If you know of a small or medium-sized business that hasn't got any offsite backups, what would you advise them? You know my views on security, but...
--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)

March 12, 2013 at 9:53 pm

#1596344
RE: Are the posted questions getting worse?

jcrawf02 (3/12/2013)
WayneS (3/11/2013)
Jeff Moden (3/10/2013)
dwain.c (3/10/2013)
Jeff Moden (3/8/2013)
...Since I'm mostly a data troll...
Does that mean you live under a bridge on Al Gore's information superhighway?
Nah... I've gone wireless. 😛
That ancient...
--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)

March 12, 2013 at 9:24 pm

#1596339
RE: Are the posted questions getting worse?

WayneS (3/11/2013)
Jeff Moden (3/10/2013)
dwain.c (3/10/2013)
Jeff Moden (3/8/2013)
...Since I'm mostly a data troll...
Does that mean you live under a bridge on Al Gore's information superhighway?
Nah... I've gone wireless. 😛
That ancient laptop...
--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)

March 12, 2013 at 9:15 pm

#1596337
RE: What to do about a complete lack of jobs?

John Mitchell-245523 (3/12/2013)
The requirements on many job descriptions are more of a fishing exercise than a statement of reality. You'll probably find your two years' experience qualifies you for...
--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)

March 12, 2013 at 1:00 pm

#1596239
RE: Client does not want to pay overtime. How to deal with it ?

Ask the people at your consulting company to deal with it. Generally, consulting companies have a "no free work" policy that you and their clients must abide by. ...
--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)

March 12, 2013 at 12:27 pm

#1596225
RE: inserting data from one table to another and want to create primary key at same time

Eugene Elutin (3/12/2013)
Jeff Moden (3/12/2013)
.... If you run your code in 2005, here's the result you get.
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
----------- ---- --------...
--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)

March 12, 2013 at 9:31 am

#1596091
RE: inserting data from one table to another and want to create primary key at same time

Eugene Elutin (3/12/2013)
Jeff Moden (3/12/2013)
demonfox (3/12/2013)
When you use
Select Into
the columns created would take the data type ,nullability etc. properties from the columns available in FROM clause.
so make sure you...
--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)

March 12, 2013 at 8:56 am

#1596066

Viewing 15 posts - 27,241 through 27,255 (of 59,101 total)