Let's take some advantage of the new features of SQL2005 :w00t:

Post the Execution plan !

Run your query (include actual execution plan (ctrl+M)) in SSMS on both boxes and on the...

How about:

declare @AgentSession table (AgentID [integer],SessionStart [datetime],TalkTime [decimal],BreakTime [decimal])

set nocount on

Insert into @AgentSession values (1, '20080920 11:15:00', 2700, 900)

Insert into @AgentSession values (1, '20080920 12:15:00', 2700, 900)

Insert into...

Make sure you install the same edition and service pack (+ hotfix) than your original server !

- I would try to reinstall that instance (starting from rtm) trying to restore...

- You'd indeed be better off putting your test instance at another server (not on your production box)

- You may even consider installing a developer edition (not that $$)

- If...

- Is sales_id the first column of your index ?

- is the other column the first one of the index ?

- from your total column distribution, which percentage is of...

and it should !

Partitioning is an advanced topic.

It needs proper peparation and if performed untidily it will bite you in the back !

you can grant on schema basis.

Check bol !

- Do read http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm

Make sure you understand it !

Then play around and test a bit !

Then make a "plan of attack" for production :w00t:

- don't use xp_cmdshell ! unless there is no way around.

- You could launch a sqlagent job to process a simple "move c:\x.txt to y:\"

- as already stated SSIS can...

- Please post version details (@@version)

- Did you apply cumulative hotfixes to your sp2 ?

- do you rebuild indexes on a regular basis ,

- did you add the deadlock traces...

I'm used to that :w00t:

1) married

2) dba

:D:):P:w00t::hehe:

There is this very nice and eye-opening article concering ranges ...

Called "The "Numbers" or "Tally" Table: What it is and how it replaces a loop."

http://www.sqlservercentral.com/articles/TSQL/62867/

Please read this little guideline to get the info you want asfast as you want.

Forum Etiquette: How to post data/code on a forum to get the best help

http://www.sqlservercentral.com/articles/Best+Practices/61537/

No problem...

What version are you on

Select Serverproperty( 'BuildClrVersion' ) as BuildClrVersion

, Serverproperty( 'Collation' ) as Collation

, Serverproperty( 'CollationID' ) as CollationID

, Serverproperty( 'ComparisonStyle' )...

I'm still inivestigating the cause for this issue, but I suspect the automatic updates just ruined my 24/7 (MOM) db server. :crazy:

http://www.sqlservercentral.com/Forums/Topic571088-146-1.aspx

I must admit, at the plant where I have...