Sounds like you're hitting this issue. Are you sure this is a SQL SErver 2012 instance?

Add two columns that are only from the Owner. Then set them to null on the second query in the UNION. That ought to return what you're looking for.

All that, and the vNext is also on Windows. They're going to be releasing another full version of SQL Server very soon now. We are in for a wild ride.

Announcements include:

SP1 for 2016 (which also has CREATE OR ALTER).

A single development surface. This means all functionality in Enterprise is also in Standard and Web (WHOOOP!).

vNext community preview available (you...

Sorry. I didn't see that Gail had already alerted you.

Quick note. You all should be watching Connect right now[/url].

That pyramid looks amazing.

BTW, I'll be going on SQL Cruise in January. It's stopping at Cozumel. Who wants to go see the pyramid with me?

VARCHAR(1) is my favorite data type of all time... Well, behind VARIANT, but hopefully that's going to be on the ash heap soon.

Wild. I hadn't even thought of temporal tables as an added protection for the data. Thanks for sharing the concept.

I'm with Thomas, it depends.

However, just a general observation, tempdb and logs are pretty frequent I/O bottlenecks. Lots of other stuff can, and will, be, but you get consistent problems...

If you mean that you are looking at the value for parameterized_plan_handle and it's showing something like this:

What you're seeing is the handle for a plan that has not been...

Marbles?

Pretty sure I lost them years ago.

You're performing a function against the column. That's going to lead to scans. You need to not do that. Using IS NOT NULL is more likely to perform well. However,...

Query Data Store.

It's probably the biggest change to query metrics, query tuning, performance knowledge and system behavior since the upgrade of the optimizer between SQL Server 7 & 2000.

Lowell (11/9/2016)

---

wouldn't creating a dacpac be an option? i

m not sure if they are SQL Server version agnostic or not, but the dacpac has the object schemas, ; i...