Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,206 through 47,220 (of 59,102 total)

RE: Invalid Object Name error

Stupid question, but have you checked to make sure the object still exists? Someone may have dropped it or maybe a DBA renamed it to see who squawks 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)

November 15, 2008 at 9:03 pm

#899044
RE: Custom Password Policy Stored Procedure Needed

Ah..., sorry Brian. I was, in fact, missing your point. Now I understand what you meant and why. Thanks.
--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)

November 15, 2008 at 8:59 pm

#899043
RE: Best of SQL Server Central

Just curious... do authors still get free copies? And, what was the cutoff for V6?
--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)

November 15, 2008 at 8:39 pm

#899041
RE: DBCC

I got it right but this is a really bad question for people who are still stuck with SQL Server 2000. These types of questions should probably identify 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)

November 15, 2008 at 8:31 pm

#899040
RE: BYOC

Yet, the same company will break your horns for sending private emails from work or using the company telephone to make personal calls to an old flame in Australia.
Nah... mixing...
--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)

November 15, 2008 at 8:25 pm

#899039
RE: Ethics in IT - Database Weekly (Nov 17, 2008)

Good editorial, Steve. I noticed the following statement...
"On one hand I can understand that ethics and morals are becoming more important."
Heh... when were they ever not the most important...
--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)

November 15, 2008 at 8:18 pm

#899038
RE: Reading File attributes (datecreated,datemodified....) using sp_OACreate....

I just ran the following on my server... only thing I changed was the file name to match a file I had.
DECLARE @hr int,@object int,@objfile int,@datecreated int,
@path varchar(200),@filename varchar(100)
set @filename='c:\Sample.txt'
EXEC...
--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)

November 15, 2008 at 7:59 pm

#899037
RE: Custom Password Policy Stored Procedure Needed

You still miss the point... even if it's for one password, you shouldn't use RBAR to do it. Someone in a pinch will find the code and use 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)

November 15, 2008 at 7:34 pm

#899034
RE: Custom Password Policy Stored Procedure Needed

MadDogs... sorry all of that took so long. The code above solves your problem. Appologies for the delay.
--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)

November 15, 2008 at 6:56 pm

#899032
RE: Custom Password Policy Stored Procedure Needed

Sorry Brian... didn't mean to sound condescending or for you to take any of this as an insult.
The last point was that you used a form of RBAR to drive...
--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)

November 15, 2008 at 6:51 pm

#899031
RE: Custom Password Policy Stored Procedure Needed

K. Brian Kelley (11/15/2008)
I wrapped both in a while loop retesting the same password.
Heh... you used procedureal code to drive a set based solution. :hehe: Ok... I guess I'll...
--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)

November 15, 2008 at 2:24 pm

#899013
RE: DR Strategy with virtual machines?

Remi,
There's a huge hidden benefit to all of this if it's running on a SAN. Most SAN companies have software that make "nearly instantaneous" copies of the entire system...
--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)

November 15, 2008 at 12:20 pm

#899006
RE: Custom Password Policy Stored Procedure Needed

Sorry, Lynn... here it is and, yes, like your's, it's a CTE...
;WITH
cteTally AS
(--==== Create a Tally CTE from 1 to whatever the length
-- of 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)

November 15, 2008 at 11:28 am

#899000
RE: Custom Password Policy Stored Procedure Needed

K. Brian Kelley (11/14/2008)
But truth be told, Jeff, the optimal solution would likely be to make the check with compiled code, whether it be an extended stored procedure or a...
--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)

November 15, 2008 at 9:51 am

#898990
RE: Custom Password Policy Stored Procedure Needed

K. Brian Kelley (11/14/2008)
And I'll acquiesce, because over a run of 20,000 with a permanent tally table (Jeff's condition, and that makes sense since that's the costliest operation), the original...
--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)

November 15, 2008 at 9:29 am

#898985

Viewing 15 posts - 47,206 through 47,220 (of 59,102 total)