SELECT DATEADD(s, integer_value, '1970-01-01')

> Or lets forget my query for a moment. If an option is given to choose between dynamic sql and clustered index scan which would it be and why.

Comparing dynamic...

What is villaName? Is it a variable, or a constant string that you want to search for? A columnname?

As always, the best way to solve this kind of problem is...

SELECT OBJECTPROPERTY(OBJECT_ID('tigger_name'), 'ExecIsTriggerDisabled')

SQL Server always 'prefers' to be alone on a machine. That way it is easier to configure and optimize the server for SQL Server. But it depends on what your...

First of all, from looking at your code I guessing that what you have is a "mega-lookup table", containing lookup values for several other tables. If so, then that is...

To add to the above, since accessing the system tables directly is not recommended, here is another way to check if a table has an identity column:

SELECT OBJECTPROPERTY(OBJECT_ID('owner.tablename'), 'TableHasIdentity')

To check...

I have no experience of using DTS from sp_OA-procs, but it sounds to me as if something is not being closed and deallocated correctly with your sp_OA-usage. Any memory requests...

I would not recommend including the entire ADOVBS.inc file in an ASP page though. That is one of the extremely many problems with ASP, an include includes everything and not...

There is no reason to use Enterprise Edition for these licensing prerequisites you give. Enterpise Edition contains features that Standard does not, but if you do not need those then...

Well, xp_smtp_sendmail requires the extended stored procedure xp_smtp_sendmail to be installed.

It can be downloaded from http://www.sqldev.net/xp/xpsmtp.htm.

However, it can only be used to...

Yep, like the others are saying it is not a good query performance-wise to run on any large table. In fact, I would not run it on any table at...

Like alzdba says, there is no way to give a 'process' lower priority in SQL Server. Where did you find the information that DBCC INDEXDEFRAG should be a low priority...

SELECT OBJECT_NAME(id) AS tablename, rowcnt FROM dbo.sysindexes WHERE indid IN (0, 1)

This select statement will return the number of rows for every table. However, this rowcount is not guaranteed to...

Well, the term statistics and index is used a bit incorrectly here. Statistics are gathered for all indexes, and used by the optimizer when deciding how to respond to a...