If you are in a job you love with people you enjoy being with, time just flies by and you don't keep track of the hours.

My first job was 37.5...

From what I remember both SQL2000 and SQL2005 are cluster aware, which means that the 2nd instance will install on both nodes.

The installation routine should detect the existing instance and...

DECLARE @TableName SysName ,
@ColumnName SysName
SET @TableName = 'tblAccommodation'

SELECT @ColumnName=COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE table_name=@TableName
AND COLUMNPROPERTY(Object_Id(TABLE_NAME),COLUMN_NAME,'IsIdentity')=1


PRINT @ColumnName

Personally I save all changes in a script and practise the deployment.

The bigger the deployment the more important it is to have it automated.

SELECT COUNT(A) AS Total , SUM(CAST (A AS INT)) AS SLA_OK

FROM TABLE

At the end of the day if the app fulfills the business need then it is mission accomplished whether it was written in VB3, 4, 5, 6 or JFDI.NET.

Yes migrating...

I fully understand your point but from my limited experience with .NET the stories of M$ investing more in .NET than NASA did in the moon shot are entirely believable.

It...

Basically, it is a memory hog. If you have less than 1GB forget it.

Also, in the Tools/Options make sure that under the General tab you select "Open Empty Environment"...

The big thing with .NET is the framework of 7,000+ functions.

There are a lot of things that .NET does with very little effort that required an good knowledge of the...

I 2nd the "work in small teams" part.

It also helps gain a bigger picture of the project so you don't go down a blind alley.

When I develop I...

The way I would approach this would be to have a user defined table function that splits out your country string and returns a table.

Your query would then become

SELECT *...

The RedGate software site has an article by "Phil Factor" lamenting the fact that you have to leave your techy past behind you to get into the higher echelons of...

numeric fields can hold values to 2*10^+-38 where as integers are 2*10^+-31 so if you need more than 4 billion values then numeric fields offer a solution.

Storage size for Numerics...

As a DBA my main concern is with apps developers who code things up with the assumption that they will have access to the SA password or similarly excessive access...

If stress makes you crack then you are damaged for life.

You can x-ray broken bones, examine stitches and wounds, but there is no empirical measure for a broken mind.

It...