Jeff Moden (11/15/2008)

---

Heh... you used procedureal code to drive a set based solution. :hehe: Ok... I...

Jeff Moden (11/15/2008)

---

Let's up the anti a bit... let's actually solve the MadDogs' (the OP) original request and time it against 100,000 rows of 10 character passwords. It's gotta...

Jeff Moden (11/15/2008)

---

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),...

Jeff Moden (11/14/2008)

---

What about the time to write set based code? Well, if you look at the amount of code that Brian had to write to use the loop...

Jeff Moden (11/14/2008)

---

You missed what I'm trying to say... the "costs" you see in the execution plan have nothing to do with reality.

Tell you what... let's do a "real" test....

Let's look at this more closely. Good point, I didn't catch it was only showing the first iteration of both loops. Let's look at the cost per "row" for the...

On a related note, here is the procedural based code:

DECLARE @Password varchar(20)

DECLARE @i tinyint

DECLARE...

But see, you put row in quotes meaning you are shoehorning in the definition! Aha! We could say CBAC although that doesn't flow as well (for either character by agonizing...

If you mean who is a member of the sysadmin fixed server role,

EXEC sp_helpsrvrolemember 'sysadmin';

GO

With respect to finding databases owned by SA:

SELECT name

FROM sys.databases

WHERE owner_sid = SUSER_SID('sa')

I would disagree that this is RBAR. RBAR implies you're doing a set-based type of operation. Checking a password for complexity, at the end of the day (since you still...

You can do a loop where you cycle through the password that has been entered one character at a time using SUBSTRING. Then you can use a set of nested...

Well, their expectations are unrealistic and I...

John Erdovegi (11/13/2008)

---

DELETED SOME...

You could create a similar system to be use internally for your business, and on secure-websites, then you have more control and security. It can be run...

dphillips (11/13/2008)

---

Wouldn't allow. For instance, an internal system would...

John Erdovegi (11/13/2008)

---

All of these Social-websites, and even email, can, and sometimes is under surveillance by people. Someday some of these "Futuristic"/Sci/Fi concepts, may become reality. It makes it easier...