I'm with Jeff here. I tried a couple of experiments to see if I could break this. Nothing obvious worked.

Sean Lange (1/14/2015)

Koen Verbeeck (1/14/2015)

The question of today wasn't...

Another approach would be to hard code your list into a temporary table in the query and then join to that. Not pretty, but it'll work. There just has to...

Exactly what I was thinking. Where do those other two values come from? They have to be stored somewhere and then you join to that.

Instead of doing a UNION operation, what about just a JOIN operation. You have three columns that are going to give you a relationship between the two tables. You only...

Those are based on the queries run from the query window. You can change connections and it will still maintain the count of executions from that query window.

It's not the...

In addition to what Perry says, I also understand that there are a number of internals improvements leading to a higher degree of stability and better performance overall.

IO latch waits are an indication of disk activity. What are your sec/read and sec/write currently? What are the other wait types in the top 10. Just the page latches...

SELECT * FROM sys.partitions;

SELECT * FROM sys.dm_db_partiton_stats;

Personally, I'd keep it really simple. Are they starting a new projects? SQL Server 2014. If they're going to go and purchase brand new software, right now, they might as...

Are you hitting any other memory problems? What are the top waits? Just looking at PLE in isolation doesn't really say much about the system.

Yeah, probably rolling back those transactions. Glad the recovery on the other end wasn't as long or longer.

Good luck with the tickets. If you do get a more complete answer,...

That's awesome. Well done.

What Gail said.

I don't know how that started, but I've seen examples of that approach to naming files going back to when I started working with SQL Server 4.2... Sybase...

You could try looking at third party tools then. Redgate SQL Compare for the structures and SQL Data Compare for the data. You'll have to do manual mapping on the...