You could reverse engineer the fix, unless it cleans RAM indiscriminately, not only where the password is lying. Or try DBCC CLEARTEXTPASSWORD or DBCC PASSWORD('user') WITH NO_HASH. 🙂

Is there still a licence condition on Microsoft SQL Server that you need Microsoft's approval to publish product benchmarks? I suppose that could affect open discussion of third party...

Maybe it's the contrast with dreadful reality but I believe I detect a Dr. Seuss flavour? As in

http://en.wikipedia.org/wiki/Oh,_the_Places_You'll_Go!

(if that comes out as an actual link.)

Will you succeed?...

James Horsley (9/15/2009)

---

It seems to me we have a forum here with lots of people rolling their own solutions - surely this would be an ideal open source project to...

Well, set operations on a relational database aren't the way to do everything in computing, particularly if you're developing an application for computer operators who are not trained in set-based...

rboggess (9/11/2009)

---

However, where I really get hold-my-breath-excited, is my hopes to build a new home server running X-windows at home. I can afford to invest a lot more into...

I believe I am jaded about progress on the desktop because whenever we get faster hardware, we get slower software and the user experience is approximately the same. If...

Jeff Moden (9/9/2009)

---

Actually, we've gotten a bit off track. I don't mind people asking questions on forums... in fact, I recommend it because there are so many great folks...

Jeff Moden (9/9/2009)

---

jonathan allen (9/8/2009)

---

Buck Woody's blog is quoted as saying 'the best' depends on circumstances. Some of us are in that predicament when it comes to training, knowledge, time...

Of course an admin is receiving considerable trust anyway. But giving them possession of all other users' passwords is something else again. As you say, they can impersonate...

If we're talking about specifying a database or server design, there are principles, although I don't know if I can tell you what they are. There's material in the...

Sanjay Rohra (9/4/2009)

---

I believe we can use the procs sp_spaceused and sp_statistics for temporary tables by changing the context to "tempdb" database. But that can be done only in the...

TheSQLGuru (9/3/2009)

---

I expect there to be lots of 'messes' out there related to MERGE and triggers. So incredibly difficult to follow some of the logic trees when both are...

markjvernon (9/3/2009)

---

What if you would like to query using a where clause?

For example...

SELECT COUNT(*) FROM books WHERE title LIKE '%Harry Potter%'

Or...

SELECT COUNT(*) FROM invoices WHERE deleted = 0

I could be...

Paul White (9/2/2009)

---

wbrianwhite (9/2/2009)

---

I had always heard that you should do a "select count(1) from table".

http://www.techonthenet.com/sql/count.php

"TIP: Performance Tuning

Since the COUNT function will return the same results regardless of...