You can download SSDT-BI for Visual Studio 2013 at https://msdn.microsoft.com/en-us/library/mt204009.aspx

Good luck.

- Brian

Could someone please explain why it's necessary to cast NULL(DT_STR,6,1252) to (DT_STR,6,1252)?

Shouldn't it be possible to use the expression

rather than

(DT_STR,6,1252)(TRIM(DepartmentID) == "" ? (DT_STR,6,1252)NULL(DT_STR,6,1252)...

Could you give an example where it would be useful to add a constraint to a FileTable?

Grant, Jeff, and Wayne:

Which ORMs do you have experience with? I would think that the designers of these ORMs would very much like to hear of your experiences with these...

The correct answer is:

See https://msdn.microsoft.com/en-us/library/ms176047.aspx and in particular, under Remarks,...

And for those of you who are wondering why LEN(@SQL) is 48,893 it's because

LEN(', CONVERT(VARCHAR(10), CAST(1 AS INT )) as ABC') is 47 and there are 9 single-digit numbers...

The answer provides a reference to the sys.foreign_keys topic (https://msdn.microsoft.com/en-us/library/ms189807.aspx) but should probably provide a reference to the sysforeignkeys topic (https://msdn.microsoft.com/en-us/library/ms177604.aspx) instead since that is what was used in the...

If you are only interested in the employees' names then the query from J Livinston SQL is correct. You can amend it to include the MaxOrderDate if you wish. For...

In your initial post you said the question was to return the EmployeeID, FirstName + LastName as Fullname for all employees that have not made a sale since July 1998...

SQL-DBA-01 (6/18/2015)

---

Thnx Steve. I knew the answer so it did not take time to click the right radio button.

But, 1 question, if any of the non cluster indexes in a...

I disabled the clustered index (also the primary key) of a table called junk and when I ran DBCC CHECKDB in the database, I got the message:

Index 'PK__junk__3BD019E5787EE5A0' on table...

Thanks, Hugo. I read the section of your article on segment elimination again and it actually does include a Saledate column which apparently is part of the columnstore index for...

I note from Hugo's article that if a string (char, varchar, nchar, nvarchar) is part of the columnstore index, then filtering on that column does not result in segment elimination.

I...

I have a question about the answer provided. It says:

Declaring a "FLOAT" without providing the number of bits to use, e.g. FLOAT(n), results in the default FLOAT(54) which is equivalent...

Very nice question. I especially like how you included IX_Filtered5 (WHERE Col IN (1,2)) as a workaround for IX_Filtered6 (WHERE Col = 1 OR Col = 2), IX_Filtered8 (WHERE Col...