As your dates are in DMY format, you need to ensure that the connection is set to use dates in DMY format or put an implicit change in the procedure...

DateDiff in hours then divide by 6 to get the result.

select datediff(hh,@date1,@date2) / 6 = 36

Was assuming that the "ran" ment in the past, which is where the sysjobhistory came...

So why the need to keep the data intact? If they want it real time they are going to have data fluctuation as values will always be changing.

Query sysjobhistory providing that it stores enough rows and doesnt purge, or tell your job to log the run time to an audit table then query that.

Please provide examples of values which will and will not convert from your table

mirroring logshipping are out of the question.

so your looking at replication, which replication method you want to use is up to you

Correct, it is just meta data which looks at the underlying tables.

So if the data needs to be static, then you need to export the data to a different table(s)...

Please provide the current report along with what the report should look like,

But it sounds me that you need to add some grouping, but cannot be sure without seeing what...

Well you will have a smaller amount of IOPS available per RAID array, so you cant do as many read write operations a second as you could with 6 disks.

But...

Yes I would aggree as the clustered index IS your table.

It needs somewhere to store the B-Tree so you would expect it to be slighltly larger after changing from a heap to a clustered index.

Not enough information to point you in the right direction.

What is BSM? Who owns the source code? What is the app written in? What kind of app...

SQLArcher (2/12/2013)

---

In terms of the licensing to get a better understanding I suggest that you look at the following:

http://download.microsoft.com/download/7/3/C/73CAD4E0-D0B5-4BE5-AB49-D5B886A5AE00/SQL_Server_2012_Licensing_Reference_Guide.pdf

However, it is always best to speak with your Microsoft representative as...

Yes, your data files and log files, should be on completely different storage environments. So partitioning the D drive into D and E, but still using the same 2...

Set the frequency on the schedule to Monthly on the X X of every 9 month(s)