Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,851 through 32,865 (of 59,099 total)

RE: Are the posted questions getting worse?

Ninja's_RGR'us (8/18/2011)
Sorry to break the rules but..
I've possibly discovered a bug that corrupts your db when doing a deployment script. I've tested on 2K5 sp3 and 2K8 R2 RTM,...
--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)

August 18, 2011 at 12:18 pm

#1370304
RE: t-sql execute faster

On second thought, there is some duplication of conditions that you could get rid of... here's your original code...
alter PROCEDURE [dbo].[brw_Rec]
@rId numeric(18,0),
@rId2 numeric(18,0) = NULL
AS
BEGIN
select RID,PA_ID
from app_table
WHERE...
--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)

August 17, 2011 at 10:12 pm

#1369935
RE: t-sql execute faster

There's just not enough to go on to make any recommendations, Wendy. Take a peak at the second link in my signature line below ... doing those things will...
--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)

August 17, 2011 at 10:06 pm

#1369934
RE: Using Between operator...

DatabaseHell (8/17/2011)
Same values Chump
Heh... not sure where you come from but the word "Chump" isn't a complimentary one. You won't get any reasonable answers when you use such words....
--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)

August 17, 2011 at 9:56 pm

#1369932
RE: How to modify $pshome PowerShell 2.0 variable so that it points to a different directory

shew (8/17/2011)
We are a "locked down" hosting facility (xp_commandshell as well as a host of other features is not allowed),
Heh... xp_CmdShell. 🙂 One of my favorite points of...
--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)

August 17, 2011 at 9:47 pm

#1369931
RE: Any easy way to find if duplicate rows exist in a table?

Thomas Abraham (8/17/2011)
Thomas Abraham (8/17/2011)
Jeff Moden (8/10/2011)
As a side bar, I obviously don't know the condition of your tables but, at the risk of sounding a bit like Celko, unless...
--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)

August 17, 2011 at 9:42 pm

#1369928
RE: a=b=c?

SQLSandwiches (8/17/2011)
@jeff, your audience must be on a more advanced level than mine here. I usually have to explain even the concept of a common table expression: "It's almost like...
--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)

August 17, 2011 at 9:39 pm

#1369927
RE: If you could use xp_CmdShell securely, would you?

Marios Philippopoulos (8/17/2011)
Jeff Moden wrote:
More specific to the problems you’ve resolved through the use of thoughtful and narrowly-scoped CLRs, my question on that would be, why do most (and 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)

August 17, 2011 at 8:15 pm

#1369919
RE: If you could use xp_CmdShell securely, would you?

ALZDBA (8/17/2011)
Of course it is only like the fence around a house.
I couldn't have said it better, Johan. Worse than making the realization that it's only a "fence", I've...
--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)

August 17, 2011 at 8:04 pm

#1369918
RE: If you could use xp_CmdShell securely, would you?

Michael Valentine Jones (8/17/2011)
I think xp_cmdshell can be used securely if you take the trouble to set it up correctly.
The one thing that I don't like is that you basically...
--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)

August 17, 2011 at 7:14 pm

#1369915
RE: If you could use xp_CmdShell securely, would you?

colin.Leversuch-Roberts (8/17/2011)
If I need to use xp_cmdshell then I do - it depends upon client requests and their perception of course, There's always a certain amount of using what 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)

August 17, 2011 at 6:58 pm

#1369912
RE: If you could use xp_CmdShell securely, would you?

Perry Whittle (8/17/2011)
Jeff, the biggest problem in the past (SQL Server 2000 era) is that XP_CmdShell could not be disabled or removed. It was an open invite for a hacker...
--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)

August 17, 2011 at 6:53 pm

#1369911
RE: If you could use xp_CmdShell securely, would you?

Matt Miller (#4) (8/17/2011)
While they did make some improvements to how it operates (the fact that you can in fact disable it is very good) - I still don't understand...
--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)

August 17, 2011 at 6:23 pm

#1369907
RE: If you could use xp_CmdShell securely, would you?

Matt Miller (#4) (8/17/2011)
While they did make some improvements to how it operates (the fact that you can in fact disable it is very good) - I still don't understand...
--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)

August 17, 2011 at 3:19 pm

#1369877
RE: If you could use xp_CmdShell securely, would you?

muthukkumaran Kaliyamoorthy (8/17/2011)
I tried to avoid using xp_cmdshell but sometime I can't.
Most of time I used the xp_cmdshell for deleting the old backups because the drive got full and apps...
--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)

August 17, 2011 at 10:08 am

#1369718

Viewing 15 posts - 32,851 through 32,865 (of 59,099 total)