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

If anyone is interested the SQL2000 equivalent is

USE Master
GO
CREATE PROC dbo.sp_DBA_spaceused_AllTables2
@updateusage varchar(5)='false'
AS
SET NOCOUNT ON

IF @updateusage IS NOT NULL
BEGIN
-- Allow for case sensitivity
SET @updateusage=LOWER(@updateusage)
IF @updateusage NOT IN ('true','false')
BEGIN
RAISERROR(15143,-1,-1,@updateusage)
RETURN(1)
END
END

-- Retrieve the current...

I seem to remember that there is a non-documented stored procedure that runs the resultset of a query.

In some situations I do build up a string of commands and then...

Thanks for the comments Andy and Jeff. I don't get too worried about criticisms, we are fortunate enough to live in a democracy and as Voltaire said.

I disapprove of...