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

What do you get when you cross a sheep with a bee?

Baa Hum Bug

I've got to put up a Christmas tree, swear at the lights, murder a few carols and fight with relatives, but I will give it a go after Christmas and...

In 192.168.2.10 the octets would be as follows

1. 192
2. 168
3. 2
4. 10

Would I be correct in thinking that by using the most changing octet SQL Server is most likely to think that the...