Haha

But that only means that your duedate varchar column always contains dates in the format YYYYMMDD...

Here the problem is that it is different for different records in the database.

Why...

And that I fully agree with

I agree, you have no need for DTS in this case.

But I disagree with that you cannot get speed increases if your SP only queries one table (imagine aggregation functions...

Hello!

This leads to quite a problem parsing your data. But if you know that these two are the ONLY types of dates inserted (somehow I would verify it VERY carefully)...

...and if the Excel team hasn't fixed the bug with the 'guess rows' parameter you should watch out for wrong data anyway. If the Excel Import determines that one column...

...and as we all know it is a BIG no-no doing SELECT ... INTO ... FROM ... since it holds locks on a lot of system tables for the duration...

Okay, if they are not in tempdb they are not true temporary tables. Taskpad is a MS tool that relies on the db statistics and might have some errors if...

Remember that an dynamic SQL is always executed with the same permissions as the user executing the dynamic SQL has.

I.e. if in an SP you have dynamic SQL you have...

If you are sure the format of your varchar, in your table, is always the same or implicitly convertible to a date (which it seems like it is not in...

Encrypting a SP only affects the SP definition, not the actual SP. Which means it works exactly as before with the notable exception that you cannot view the 'text' that...

If they are true temporary tables they reside in the 'tempdb' database. Every SQL Server restart autmatically drops 'tempdb' and recreates it.

Hence all true temporary tables or objects in 'tempdb'...

Hi,

You cannot devide one datafile between two filegroups.

One filegroup can have many files.

One file can belong to maximum one filegroup.

One DB can have many filegroups.

One filegroup can belong to...

I do not know what you mean by an IDX database. SQL Server databases (usually) have the extensions .MDF (data file) with an associated .LDF file (log file).

How do you...

I do not really see the connection between SQL Mail and that product. Unless you start fiddeling about with the system SPs for SQL Mail and it is still just...