Don't do it as a trigger, do it as a stored procedure and schedule it for 1st July and 1st Jan.

From previous posts the native defragger is a cut down version of Diskeeper.

If your files are across a RAID array or a SAN then be careful with your chosen defrag...

Don't all indexes hang of the clustered index?

If you rebuild a non-clustered index and then rebuild the clustered index doesn't that alter the first index?

I have noticed that DBCC UPDATEUSAGE(0)...

Have you asked the job to notify you on success.

I had a situation where I got SQLMail to email me on successful completion. Something went pear shaped on the...

If an attempt is made to insert a value in a table with an identity value and it fails the identity value still increments.

I would run a SQL Profiler to...

What value do you have for adCmdStoredProc?

In terms of performance I don't think there will be any difference.

I prefer to specify the columns because if the underlying table changes its structure my query is still bringing...

Firstly SQL Server has two functions that get the system date

GETDATE() retrieves the current system date

GETUTCDATE() which retrieves the Greenwich Meantime Date and Time

There are several ways of getting the...

My question would be "Why do you want to do this"?

If it is something that the front end application requires then I would return the original recordset but have the...

Yes

Provided your query uses Col A the index will be used.

CREATE PROC dbo.MonthReport
@YearOne CHAR(4) , -- I an assuming that Year is a 4 character string such as 1999
@CID VARCHAR(50) -- I am assuming that CID is the customer name.
...

It looks like the psuedo syntax out of a reporting tool.

Cognos queries sort-of look like SQL but aren't really.

I would not be nervous of the physical process but would be very nervous from the perspective of capacity.

I worked on a project where it was calculated that running 2...

Wrap your CASE statement in a CAST(CASE statement AS CHAR(3))

I have had problems with BIT fields doing peculiar things

I would try and use DTS but have three separate queries. The first would be

select

serverproperty ('servername') as 'Server' ,

ISNULL(serverproperty ('InstanceName'),'') AS 'Instance Name' ,

serverproperty ('edition') as 'Edition',

serverproperty ('productlevel')...