Check you data. Might be having default date.

Omit the same if you do not want that default date in where condition.

What is the error your are getting while installing the sql server?

Check the following link

http://www.microsoft.com/downloads/details.aspx?FamilyId=5F63E592-1BD0-492E-9CE6-29270AE671C3&displaylang=en

Check your tables index and index defragmentaion. If your fragmentation level 90% to 95% it will definately improve the performence.

Check the following link

https://forums.microsoft.com/msdn/ShowPost.aspx?PostID=302589&SiteID=1

SET QUOTED_IDENTIFIER { ON | OFF }

When SET QUOTED_IDENTIFIER is OFF, literal strings in expressions can be delimited by single or double quotation marks. If a literal string is delimited...

Select * from table_name where name like'gun%'

If your recovery mode is full/bulk logged the

Before deleting record set database to simple mode

And after deletion is over

set database to full/bulk logged.

What is that your doing in TSQL Steps? Can you able to return any return global variable from that TSQL?

You can use SQL Server Profiler

If you switch from the full recovery model to the simple recovery model you break the backup log chain. Therefore, strongly recommend that you back up the log immediately before...

DBCC CHECKDB checks the linkages and sizes of text, ntext, and image pages for each table, and the allocation of all the pages in the database.

For each table in the...

Check the following link

http://msdn.microsoft.com/en-us/library/ms190673(SQL.90).aspx

Check the following link may be useful to u

http://doc.ddart.net/mssql/sql2000/html/architec/8_ar_cs_9mhx.htm

Use the conversion functions, CAST and CONVERT, to convert expressions of one data type to another data type when these conversions are not performed automatically by Microsoft® SQL Server™ 2000....