Jeff Moden

Forum Replies Created

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

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
RE: Change 9999 to read 99.99

Heh... I wanna piece of the check that has 16 digits to the left of the decimal place. 😛
--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 14, 2008 at 8:03 pm

#898950
RE: Change 9999 to read 99.99

anam (11/13/2008)
you can run query below for all numbers which are not having decimal.
create table #tmp
(id varchar(10))
insert into #tmp
select '10.10'
union select '1010'
union select '20.20'
union select '2020'
select *, cast(id as...
--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 14, 2008 at 7:42 pm

#898947
RE: Sending Query Results in SMTP Mail

Denis Wilkinson (11/14/2008)
Thanks,
Iam still mentally upgrading from 2000 - 2005 and was still trying to use SMTP mail. Configured the query with sp_send_dbmail and it works perfectly.
Any chance of seeing...
--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 14, 2008 at 7:25 pm

#898945

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