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')...

Firstly what are the datatypes of your three columns and why store a date as three columns when a SMALLDATETIME will do?

My approach would be to use the CONVERT statement...

Why not read a different thread then and leave us old farts to wallow in the rosy glow of nostalgia.

* * *

Of course no one is mentioning having to crimp...