Just for fun I created an SSIS package that performs the processing using a C# script component. The package runs two separate threads to get some parallellism. It is easy...

Just curious: How many different customers do you have, and how many stores do you have ?

You are missing a space after on.

It should be

SET @string ='use '+@db+' DISABLE TRIGGER TRIGGeR_NAME on '+ @db

I dont think the physical reads are the problem. The query in production runs for over 4 hours. During this time only about 30000 physical reads are performed. There is...

Paul White NZ (3/21/2010)

---

In addition, only one of the methods presented so far is SARGable - meaning that an index seek might be used. The other methods all require...

Digs (3/18/2010)

---

You sent me on correct highway thanks...:-)

This is the code the will work for me..

DECLARE @iDate DATETIME,

@val INT

SET @iDate...

Backups can only be created on the filesystem on the sql server.

Maybe you could create a backup on the remote server and then use ftp to transfer the finished backup...

I still dont really understand what the problem is.

In you first script you never created any partitioned tables at all. Of course the switch command did not work in that...

Hmm As far as I know it is not even possible to create a partitioned table with a partitioning column that is not included in the partitioning key.

If you run...

I would use SqlBulkCopy() to get a buffer full of data into a temporary table, then I would call a stored procedure that performs the necessary work to move the...

Paul White NZ (3/19/2010)

---

Much better to use TOP. The use of ROWCOUNT with anything other than SELECT is deprecated and will be removed from the next version of SQL...

If all you wanted to do was to quickly check if a certain value was in the table you could have used something like this:

DECLARE @execid NVARCHAR(50)

SET ...

Well, the EASIEST way is to simply write a DELETE statment that does what you want. 😉

Since you are asking here I assume you are really asking about the MOST...

Paul White (3/18/2010)

---

stefan.gustafsson 60897 (3/18/2010)

---

Of course there is some difference between 72 bytes per row and 16 bytes per row.

What I am saying is that this difference is irrelevant for...

My guess is that the production server is more heavily loaded than the test system.

The might mean that SQL server is not able to use as much memory for caching...