Don't forget that when you do schema changes to underlying tables your should do sp_refreshview on the dependent views.

It is worth mentioning the WITH CHECK option. If you have...

Doesn't the Windows XCOPY cope with the open file?

The alternative would be

NET STOP YourService

XCOPY drive.spec\*.MDB drive:spec

NET START yourService.

Down time should be pretty short.

There doesn't seem to be an ANSI standard equivalent of BIT or TINYINT.

BIT fields I can live without because I like to have a specific "Don't know" value rather than...

Joe,

How do you feel about the naming of the integer types?

When I started programming integer meant 16 bit, long integer meant 32 bit. Not everything has shifted up a...

Depends how far behind schedule you are and what the causes are.

If the project manager under-estimated the timescales then there is not a lot you can do about it.

If you...

The bit that concerns me is the BOL entry that warns that this takes 1/8th of the server memory. So a 16GB box is going to lose 2GB RAM...

Yes indeed and as its on a 1TB I was relieved when it reported no errors.

The suspicion is that as the staging table is TRUNCATEd the pointers in the index...

We have databases getting on for a TerraByte and have to be very careful with replication.

If you generate a snapshot then while the snapshot is being generated the tables get...

Thanks for this Eric, do you know what is in the packets that are returned?

If you want to speed up the insert and you don't have identity/autonumber fields you can do

SELECT * INTO dbo.NewTable FROM dbo.SourceTable WHERE 1=0

Followed by

INSERT INTO dbo.NewTable SELECT *...

The quick and dirty method is

SELECT * INTO NewTable FROM sourcetable

However, if the sourcetable is large then this may impact on your servers performance.

You can also right-click on the object in the object tree within SQL Query Analyser

The query optimiser may have detected that it needs to run a query in a different way and therefore has generated a new execution plan.

Have a look what tables are...

Don't forget Innovasys DocumentX. It covers SQL Server, Oracle, Access and also does .NET assemblies, Visual Studio projects, ActiveX and VBA.

After using a proper tool I wouldn't use a...

I'll be 40 in February and the past two years have been an eye opener.

I left a job that paid well, was within cycling distance of home and had colleagues...