Whatever... it's still called a cross-post and will tick off some of the people trying to help because the problem is scattered across 3 posts instead of on a single...

Yeah... kinda... I normally setup a separate database for "staging tables" of large volumes of data being imported.  I set the recovery mode to "Simple", as you suggest, and I...

There's no single approach that fits all situations.  I've found that there are lots of different factors affecting such a decision... on 24/7 tables, I might use DBCC IndexDefrag because...

Just a note... doing a shrink file may actually kill your performance in the near future...  it's going to grow again... it didn't get that big by accident.  When it...

Actually... you've posted this nearly identical question 3 times on this forum and a couple of times on other forums.  Folks have told you how to do this many ways......

Since the row is automatically deleted after 8 days, I'm thinking it's a combination of a computed column and trigger.... or the trigger just has an update/delete.

I'm thinking that deleting...

The date serial between Excel, VB, and SQL Server vary a bit (a day or two in some cases).  And, Excel thinks that 1900 was a leap year... don't use...

Crud... copy and paste error on my part... I didn't include the exec.  Glad you got it working and thanks for the feedback.

Sol,

Recommend you post the CREATE TABLE statement for the table with 2,000,000 rows in it and the proc that creates the report.  Be sure to include the code for any...

My basic strategy is to avoid using a Clustered Index as a PK if the table suffers a large number of Inserts, Deletes, or Updates to the PK columns because...

Doesn't matter what YOU can see... what can the SERVER see?  The server must be logged in as a "power user" that can see shares and machines.  In Enterprise Manager,...

Anytime you try to put a row source or a table name in a FROM, you must (unfortunately) use dynamic SQL...

DECLARE @sql VARCHAR(8000)