So the BIGINT value was actually milliseconds since midnight 1970-01-01, not minutes. Good to know.

Since mirroring requires using the full recovery model you need to have scheduled periodic transaction log backups running to manage the size of your transaction log file. Without regularly...

defyant_2004 (4/17/2014)

---

Thank you. Is the following safe to assume?

All log files up to the point of the NEW FULL database backup are unusable and could be deleted. Even...

Yep, told you that would happen earlier.

Now, what date and time does 1397750400000...

Okay, using what for a base? ...

ScottPletcher (4/17/2014)

---

Lynn Pettis (4/17/2014)

---

ScottPletcher (4/17/2014)

---

Lynn Pettis (4/17/2014)

---

ScottPletcher (4/17/2014)

---

You need to do further research before you change the existing index to a filtered index, because that index will no longer satisfy...

Unfortunately, you get an overflow error when trying to convert the BIGINT value provided to an INT value when using DATEADD.

ScottPletcher (4/17/2014)

---

Lynn Pettis (4/17/2014)

---

ScottPletcher (4/17/2014)

---

You need to do further research before you change the existing index to a filtered index, because that index will no longer satisfy queries originally using...

Also, what date and time does the value provided equate?

You could probably do an in place upgrade. You could test that on a test system to be sure it works.

ScottPletcher (4/17/2014)

---

You need to do further research before you change the existing index to a filtered index, because that index will no longer satisfy queries originally using it if you...

Try this and let us know the results:

select

schema_name(schema_id) As SchemaName,

name As ObjectName,

type_desc as ObjectType

from sys.all_objects where name = 'HighCharacter'

Simplest way to fix this, remove the token 'already' as this appears to exist in all the messages. It doesn't make any sense to me to search for 'already'...

Yes, the queries used to define views will take advantage of the indexes on the underlying tables if they assist in the return of data from those tables.

Well, you provided DDL and sample data, but I'm not quite sure what you expect as output. Please provide expected results based on the sample data you provided.