Do you think it is helpful to create an index of an integer field if the
possible values are few.
eg.
The possible values will only be from 1 to 5?

I am trying to retrieve records from text database (text driver) through ODBC.
SELECT * FROM MyDatab.txt WHERE [TimeStamp]>'2008-07-03T00:00:00'
"TimeStamp" is column of type DATE
It returns error: data type mismatch in criteria expression

I created an SQL 2005 Express Database in VS 2008. I have the mdf
file.
What do I need to do to upload it to my hosting account?
Is uploading the mdf file the best way to do this?

I’d like to increase the IO performance on the server (SQL Server 2005 is
installed), by using the 32 GB Solid State Parallel ATA Hard Drive from Dell.
I wonder if there are any recommendations for using  Solid State technology
for SQL data or log files

For simple data types like int and char(), is dropping a column always a
simple metadata operation - assuming the column is not indexed, not an FK,
etc?
Have some big tables to try it on ...

Does anyone know if SQL Server 7.0 supports multiple processors and or
multi-threading?
Thanks!

One of our server has Notification Service installed and uninstalled. But
the notification server NS$FlightInstance, NS$RealtorInstance etc are still
exists in SQL Server Configuration Manager services list view. Can anybody
tell me how to remove them?

Hi.  I have a column named 'Departments' which contains a comma-separated
list of integers (i.e. - 1,2,6,10,25).
I want to write a SELECT statement where I can pass-in the integer I'm
looking for and retrieve that record.  For example (this is just pseudo-code):

One of our customers has a big Novell network, but want to use our solution
based on a SQL 2005/Express server.
Since they are not interested in paying for 3000 client access licenses to a
Windows server we have to find the cheapest wasy to do this.

I am an Oracle DBA who has to support SQL SERVER 2000 databases. I need to
find most time consuming SQL statements in SQL Server 2000 Standard Edition
databases. It seems one can get this information from SQL Profiler tool, but
I want to find is there any other way.

    We are installing SQL Server 2005 Developer edition(x86) in a Windows VISTA
machine having Visual Studio 2005 Professional Edition with SQL Server
Express Edition 2005.We have the latest service packs for Visual Studio and
SQL Sever.The problem is that we are not able to install ...

In the query results windows, I have several text fields that contain
approximately 800 characters of text.  Access has a feature that if you press
Shift F2 you can display the entire contents of the fields in a pop window.  
I am not able to find any similar functionality in SQL ...

This is probably a really basic question but ..
I have a database in SQL2005 that has lots of triggers, stored procedures,
Keys and relationships. I just want to copy that complete database from SQL
2005 to 2008.

One of our departments is running SQL 2000 Enterprise SP4 and the scheduled
daily full database backup job has suddenly started to take 12 hours to
complete. Until 5 days ago it only took about an hour. The weekly
optimizations job which was taking 2-3 hours now takes 5 hours.  ...

I need to get a list of rows from a table which have a DueDate of
today.
Problem is, the due date is maybe 2008 24 09 09:45...
If I say where DueDate = GetDate() it will only work for this