The ultimate solution would involve partitioning based on date, if your purging is date based, then all you would need to do is drop the partition to delete, much faster...

Sometimes SPN content can go missing after doing these type of migrations. Check that your SPNs are set properly on the NEWSERVER for the OLDSERVER

https://technet.microsoft.com/en-us/library/bb735885.aspx

I would advise using simple update scripts on your database objects before propagating them to production. Since your objects are simple text any scripting language/powershell can manipulate your t-sql...

Great article, didnt read any previous articles before (assuming you started at 1). It should be noted that with any production DB system, even one that seems simple, changing...

I would love to see what the partitioned table solution would look like.

The real answer here is that it doesn't really matter if a Tally table contains 10,000 rows or a million rows. It it's used properly and if it has the...

Notice your taking 'Fisc' information and from the tally table determining the Y W D information. But what if your tally table was just Y W D information, since...

That can happen on multi-processor systems that SQL is allowed to use.

I wish I had a true single processor system (no hyper threading or multiple cores) to have tested this on to see how it worked. Would I have thought...

Glad you found a solution, however you did NOT get a 'it cant be done' answer here in this 'forum'.

Greg R

Actually,

You can run the SQL Server Agent as a specified domain user.

http://msdn2.microsoft.com/en-us/library/ms191543.aspx

Greg Russell

What about creating optimized views for her to query against?

Just a thought.

Greg

Without knowing more about how your clients access data I will assume(bad I know ;)) that your clients only need to read data, if this is true then you want...

Since your dealing with an ACCESS databases have you tried using the compact and repair function?

Check MSDN for corruption ACCESS Database

Here is what I found that could be useful.

http://support.microsoft.com/kb/279334/

Since your using SQL 2005 CE why not use Merge Replication?