I do not have a SQL Server 2014 instance at hand to play around with so I need to go by what I find documented at https://msdn.microsoft.com/en-us/library/dn452279%28v=sql.120%29.aspx.

I do not see...

It...

For problems such as that (and many more), it can be convenient to have a Calendar table in your database. A simple table with one row per date, showing the...

It is not required to post the full CREATE TABLE statements; simplifying by removing columns that are not used in the problem is okay (and as far as I'm concerned...

SQL_Surfer (4/24/2016)

---

Anyway, why my non-column store index is not performing well as it should? I'm querying a 5 million row table. I've attached a query plan. Any tips to speed...

My understanding (from an admittedly limited exposure to Biztalk) is that normal SQL Server backups are used.

The only thing Biztalk does extra is use some markers or other logic to...

ptownbro (4/24/2016)

---

I'm trying to only display certain columns and order by different columns from an aggregate group by query using a grouping set. To do this I'm using a sub-query.

I...

I like that one!

The Dutch version translates as "when God distributed brains,...

Yes, I understand why you used the LIKE operator. I also see from the query results that your table contains 2704 rows that have a description that starts with "DTEF...

See if this article helps you:

https://www.simple-talk.com/sql/t-sql-programming/questions-about-using-tsql-to-import-excel-data-you-were-too-shy-to-ask/%5B/url%5D

A benefit of having a CurrentRowFlag column is that you can create a filtered index on it. That is not possible with EffectiveDate and EndDate only because you cannot compare...

In the query with LIKE, replace "COUNT(1)" with "Descrip". Check if the rest of the text matches as well. Your like only checks the first part, there might be differences...

I can take this one. Nice synergy with my article on trusted vs untrusted constraints.

I am quite busy so if you're in a hurry you'll need to find someone else.

(And...

Alternatively, in SSMS select the "output to text" option, then go to the query options for output to text and choose to use comma-delimited output.

I cannot see the picture you included, but I can give you a generic reply.

Problems like this are often caused by invisible characters in the data. In a system on...