I don't know if you figured it out already or you still need help, but I know I don't quite understand the question.

Remember to put some salt on that hash, incase someone get ahold of your DB some how. SHA1 should be plenty for storing someone's password. HASH's work great anytime you...

If you stored date time in the '2008-08-26 00:00:00' format in your varchar(64) column instead of 8/29/2008 10:28:39 AM you could then just do string comparisons instead of converting...

It is my understanding that nolock only helps when you have a write lock on a row/table. C# has something simular for accessing objects in a multithreaded environment. You can...

The customer is checking their raid array and will get back to us. They think there may be some sort of hardware issue; but we won't know until they get...

I could see HT causing cache thrashing during heavy usage. Or just lock SQL server to only work with the first half-set of CPU's listed in taskman, as physical CPUs...

Just tossing this out there, no idea if it's related. Does SQL treat large varchars as text? If so, I wouldn't think you could 'order by' because SQL won't compare...

the only time you will get a 'null' result from passing a non-matching join is in with outer joins. If you have something in the where clause and you have...

I never had to work with transactions, but we're working with the 'conception'

begin

declare vars...

begin try

some stuff

...

I noticed that all of your comparisons are in the format

AND a.POST_DIR =

(CASE...

kind of off topic but when you said

are time stamps guaranteed unique or 'just as long as you don't do...

an example might be finding students with the same name but different user

select *

from tblStudent s1

inner join tblStudent s2 on s1.firstname = s2.firstname

and s1.lastname = s2.lastname

...

Create a 3 column table

create table Random (number int, Entropy bigint, status tiny)

insert 0-9999 into number

update Entropy with select convert(bigint,HashBytes('SHA1', convert(varchar(255), number )+convert(varchar, getdate(),121) ))

whenever you select a 'random' number...

According to reddevnews.com

Even MS developers blame it on functionality requirements(trade off) or poor...

Last timeI created a web app, there was a procedure to test to see if incoming data was valid SQL and if so, to throw an exception. How does this...