What is the purpose of creating this table?  Wouldn't it be easier to create a view and use that instead of duplicating data?

You can use LEAD() to get the next viewChecked value - calculate the difference between the current viewChecked and the next viewChecked.  Add up the times associated with the play...

A couple of issues you have with this query.  First - you should join on the OperatorID and not the name (in fact - the name should not be in...

Did you apply the certificate from the old system?

This is a physical server in a cluster - the storage is an Enterprise SAN and we have multiple data drives and mount points configured.  I also have...

Are you really still on 2005?  If so - then any of the utilities here will be worth the expense - as every one of them can stream the backup...

No - these are not the same...the first one excludes all claims on 2006-01-01 where the eff_date is not 9999-12-31.  The second one includes only those claims where the claim...

Do you anticipate - at any time in the near future - scaling your SSRS environment out to multiple servers to load balance report access and generation?  If not -...

If you don't know the order - and want just the first 4 values:

Select @string
  , max(Case When i.ItemNumber = 1 And i.Item2 =...

For a running total - you need to set the row boundaries in the windowing function so that row only calculates for the data from the beginning to the current...