Can you have duplicate OperatorID's in the Transaction table?

try running the following query on the Transaction table:

WITH duplicateCheck AS
(
SELECT OperatorID, count(OperatorID) OVER (PARTITION BY OperatorID) AS OperatorCount
FROM...

I still see that link taking me to an article about Data Compression Double Take which seems different than SQL and T-SQL for Beginners or is that where it is...

• This reply was modified 6 years, 2 months ago by Mr. Brian Gale.

With the sample hourly rate being 10,000, I was just trying to make sure I picked a value that was substantially large enough to cover almost everything possible in the...

Do you need this to be "real time" data or can you load the data into some system (Hadoop, SQL Server, Oracle, etc) on a nightly basis?

I am not the...

I would not recommend putting an excel file on here.  Not many people will nab that as there is inherit risk of downloading random files from the internet...

I would just...

I think all you need to do is change how it is formatting the cell.  When I paste that in with a straight paste (no paste special or anything like...

Without seeing the data or having any idea of what things look like, what I would do is something like this for your case statement:

CASE 
 ...

• This reply was modified 6 years, 2 months ago by Mr. Brian Gale.

I think the link in the OP points to the wrong post?

The problem with trying to manage 1,2,3 as well as a,b,c is what happens when you hit 1,a,1?  One solution could be to just sign each letter a numeric value...

I see a few things that will make this tricky.  The first being that the datetime column has no time.  So how do you know that m5 went from 3...

With them being physical disks, I think that setup looks like it should be good.

Your next question about the types of disk (SSD or Other) and RAID, that really depends...

Are your disks on a SAN or physically attached to the machine?

SAN disks in a good SAN should be set up in RAID by the SAN controller and should be...

If you do go the SSIS route, there are a few things to watch out for:

•  if any step in the SSIS package fails, the whole package fails
•  

  SSIS will...

I am not aware of any archiving tools that work on generic data.  And designing one would not be the most fun thing to do as each table can be...

Did you look at the execution plan to ensure that SQL was using the full text index?

a nice read on CONTAINS vs CONTAINSTABLE is here:

http://www.qdpma.com/CBO/FullTextQueryPlans.html

If it IS being used, my...