My apologies, I hadnt copied the last...

The SQLIO utilities and PAL are a good way to evaluate the performance.

You can also look at capturing a trace from your production system and then replaying this on your...

If I understand you correctly your main concern with restoring the production database onto your development enviornment is that you will overwrite changes made whilst in the development stages.

You have...

You can remove the use of the derived table:

;with t4 as (

select '2011-01-02' as dd, 123 as prodID union

select '2011-01-03' as dd, 345 as prodID union

select '2011-01-04' as dd, 345...

That was pretty much my thinking. Ill see what the recruiter comes back with. To be honest I was not looking for a change but there is no harm...

I must admit I have never used that application. But if it is just tables \ data you are importing using SSIS or Import Export wizard is as...

Also I was taking about the SQL Server Import Export Wizard in SSMS not any tools within MS Access.

What do you mean by SSMA? Are you referring to SQL Server Management Studio (SSMS)?

Having just re-read your question and realising you are using a maintenance plan.

You can edit your maintenance plan and if you click on the button that looks like 2...

Ryan1 (9/9/2013)

---

I am currently reading Itzik Ben Gans book about Microsoft Server 2008 TSQL Fundamentals and I have run into another code example I cannot seem to grasp. The...

There are a few articles out there but I find the wizard straight forward enough. However here is few examples:

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

http://www.fmsinc.com/MicrosoftAccess/SQLServerUpsizing/importing/Import_Access_DB.asp

The error does not show enough detail to debug the problem. Have you tried running the the package using the dtexec command line and redirecting the output to a...

We had a problem with our transaction log restores taking quite an increase due to the custom log shipping setup we had.

The DBA that set it up...

I used to work for a company which followed a similar approach. In my experience its usually been down to the overall attitude towards how the product is developed....

That's a very sweeping statement. Without any details on the environment they have you cannot definitively say that a restore will be quicker than one of the afore mentioned...