When my contracted hours were lower I used to do a lot of research in my own time. My wife works nights and I work days so there are...

CREATE DEFAULT df_now AS GETDATE()

CREATE DEFAULT df_today AS CONVERT(SMALLDATETIME,CONVERT(CHAR(10),GETDATE(),102),102)

CREATE TYPE dbo.ty_now FROM DATETIME NOT NULL

CREATE TYPE dbo.ty_today FROM SMALLDATETIME NOT NULL

exec sp_bindefault 'df_now','ty_now'

exec sp_bindefault 'df_today','ty_today'

I had SQL2K, SQL2005 and MySQL4.2 all coexisting on a development box.

I'm not sure if that is such a good idea on a production box but if you could have...

I would start reading up about full-text indexes in SQL Server.

I would also look at the Thunderstone website for their Webinator search engine. It is a spider, which means...

I think of the INFORMATION_SCHEMA views as being something like a programming interface. I know interfaces don't contain implementation, but as Andrew says, the underying tables may change but...

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