Could you describe the behavioral difference you are experiencing?

Regards,

Andras

lalit (10/19/2007)

thanks again for the help.

I am using SSIS 🙂 to do all of this and that is why need a SSIS specific solution to this..

I have added a data...

How large are your tables? If the table size is small, like only a few pages, then the rebuild will not only result little or no speed improvement, it will...

Have a look at Red Gate's SQL Log Rescue. It will restore your table based on the transaction log and earlier backups. It is a free tool and it works...

Hi Lalit,

the reason fro populating CustomerDetails first, is that your CustomerMaster table does not have anything to identify the original customer. It only contains the identifier of this customer, but...

Cathan Kirkwood's "How to Diagnose and Fix Wait Locks" article describes this in some detail. See http://www.sqlservercentral.com/articles/Administering/wait_types/856/

Regards,

Andras

Something along the lines of:

DROP TABLE dbo.CustomerDetails ;

GO

SELECT IDENTITY ( INT, 1,1 ) AS CustomerId

, Customers.CustomerName

, Customers.CustomerAge

...

Hi Susan,

you can do what Matt suggested with a statement...

Using sqlcmd is certainly a good idea :). People often forget that SSMS's Object explorer also uses a connection, and in single user mode this will prevent new query windows.

Regards,

...

How large is your database? How large are the tables? How many indexes do you have? How fragmented are the indexes? How low is the load on your database when...

Kenneth seems to be right about the declaration being evaluated only once, and then only assignments happening. If you add a print statement to the original code and set @p...

Just to add, for your current session you can do:

SELECT host_name

FROM sys.dm_exec_sessions

WHERE session_id = @@SPID

Regards,

Andras

Hi vmon,

yes, have a look at sys.dm_exec_sessions and in there the host_name column.

Regards,

Andras

This is something that can happen in read committed isolation level. Have a look at http://blogs.msdn.com/craigfr/archive/2007/06/12/query-failure-with-read-uncommitted.aspx.

Normally you can get around it if you impose some more restrictions on the transactions...

Hi Martin,

assuming that your existing stored procedures can validate individual rows, the service broker could indeed help. You could send a message every time a new row is inserted, and...