That's why you should move to Denver :), 2 hour flight to Seattle.

I'm glad it appears to be resolved and you didn't have to do anything. I'd cautiously watch the apartment for a new, smaller camera, or blinds/shades moving.

Hope for the best,...

There are any number of ways you could hash things. Here's a quick article on the functions you use (http://weblogs.asp.net/bradygaster/archive/2003/11/26/39935.aspx).

Basically instead of

insert users (username, password) select (@user, @pwd)

you'd do a...

What do you mean by "mask" the password field?

Passwords in SQL Server are already hashed. If this is a user table, you can hash those. The values in a table...

Go to 3!

I thought it was great. One died, and I need to replace it, but havnig 3 worked well. It cost me about $300 for another card and monitor....

Flo has good ideas. If you have some leeway for latency (I had to do the alliteration), and could handle the data update a minute later, I'd think about:

Write a...

That's correct. If you have read only data, go 100% and filll the pages completely.

For those in THE THREAD

New beta search engine. appreciate you trying it and feedback. http://www.sqlservercentral.com/Forums/Forum83-1.aspx

you are welcome.

A couple other notes. Look at the row size for your table, or index, and then compute how many per page. Look at page splits, and then as...

With fillfactor you control how many rows, or how much data, goes into the pages. It could be about size, but don't think of it that way. It's a case...

Right click agent, choose properties. There's a history tab. You can limit by rows or size, and remove history older than xx days.

you run profiler, and pick the Stored procedure events. I see it in

SQL: Batchstarting

SP:starting

SQL:BatchCompleted.

I'd agree with Grant. I assumed (badly) that 30 windows would be multiple servers. If it's not, you might need to rethink the way that you develop code.

I have a list, and PASS has stuffed tickets in the badges for people that used SSC3D before Tuesday (or paid me).

The rest of you will get handled. I'll get...

Great points, GSquared. It's good to let people know that selling blood doesn't necessarily help others with their lives.