I agree with Michael - Teradata is a great data warehouse platform, but it's also expensive as all get out from software licenses to employee costs. You can reasonably...

You do however need to install either developer or the full-blown express (advanced express) edition, either will install on a client o/s (e.g. XP), none of the other editions will...

If your web application is configured to use only a single identity rather than windows authentication you're going to run into trouble differentiating between users.

Ideally, you can set your web...

I'd have to agree with Jeff here, all you need to do is encrypt/hash the search criteria beforehand.

Take a look at EncryptByCert in the BOL and you should be able...

Loner -

I feel your pain but have also been on the other side of the equation (e.g. managing a bunch of geeks) and I can only say that you really...

One option might be to convert the physical machine to a virtual machine and then store the VM on tape for future use if needed? VMWare has a tool...

Hmm... OK, the answer is a firm "it depends".

How many rows are you indexing, how many unique values are included in your column(s)?

The usefullness/value of any given field...

SOX, etc. don't require that you can't have access they require that any changes made to the various systems are audited/documented/logged.

Look into products like SQL Sentry, etc. that track all...

Ahh, the joys of firewall administration. As an alternative to opening 1433 to everyone perhaps you should consider whitelisting only those hosts/subnets that should be accessing your sql servers?

Joe

I'm partial to SVN with tortoise and VS integration. Throw in SQL Compare professional to generate diff scripts...

Joe

One thing that has always driven me a little nuts is that many folks hear of "active/active" and immediately assume that an "active/active" cluster = horizontal scalability (NOT) = Oracle...

I would take a look at UOPS_MODIFIED_TS = CURRENT_TIMESTAMP, what is the value of current_timestamp? String or binary would be truncated usually indicates that the value you're trying to...

Can you clarify exactly what you're looking for?  Microsoft release patches for Daylight Savings Time changes some time ago (though I've heard more may be on the way)...

Joe

No worries.  I would disable autoshrink (autoclose too) - just not worth it, causes more problems than it was ever worth.  If you need to shrink the database do it via...

Moosamca -

With the exception of the clustered index question, the rest of the SQL here looks to be something other than T-SQL (SQL Server dialect of SQL), perhaps Oracle?

As...