(RESULT not like '%<%') or (RESULT not like '%>%')

will pass everything except NULLs to the convert as anything excluded by the first clause will be included by the second...

If you were to need a more obscure interval - maybe its an astronomy application and needs to be timed based on the rotation of some planet other than Earth...

The other option would be to schedule it every 30 minutes, check last run time and if less than 80 minutes (or some other value slightly less than 90 but...

Ross.M (3/24/2014)

---

lol no problem 🙂

Don't suppose you know of any other SPs that can send emails without using sp_send_dbmail?

I'm currently checking through xp_cmdshell calls like you suggested earlier,...

Have you checked the properties of the PDF file extracted - there should be a PDF tab which will indicate the version of the writer used to create it and...

Sean Lange (3/18/2014)

---

This looks a lot like something you grabbed from the internet and don't understand what it...

I have come across SSD raid arrays where there are basically two SSDs mounted on the same PCB along with a RAID controller. These are RAID 0 arrays but it...

I couldn't see it getting a classification suitable or young teens without some major changes to the backstory - the frequent violence and murder references would need toned down significantly

Yes one based the Magician trilogy and another on the "of the Empire" one could...

For a good visualisation of server and database roles try here

http://social.technet.microsoft.com/wiki/contents/articles/2024.database-engine-fixed-server-and-fixed-database-roles.aspx

call.copse (2/28/2014)

---

I don't think it could be a movie - maybe a HBO show or something - but I'd love to see the Foundation series adapted well. Tricky one mind...

twin.devil (2/18/2014)

---

WHERE 1=1

AND 1=1

AND NOT ('A' LIKE '%Z%'

AND J1.JRNAL_SRCE IN ('B/F', 'CLRDN')

...

Why don't you just create two jobs?

For the case where both sets of compression are performed using the same algorithm (probably a reasonable assumption if SQL server is handling both - definitely not safe to assume...

Well I went for the answer that the OP was clearly wanting rather than the correct answer i.e.

D) Any of the above.

In most cases where the data in both databases...