Most of that information can be found in the DMVs. (dynamic management views)

Here's a free eBook:

Performance Tuning with SQL Server Dynamic Management Views

You cannot update a table using the OLE DB Destination.

You need to use the OLE DB Command for that. However, this component will update the table row by row, so...

Great question, thanks.

Number 1 will indeed install a shell of VS 2012.

I guess it depends most if the table is a heap or if it has a clustered index.

Additional indexes will slow down the insert even more, especially in larger indexes.

Other...

I think you should include a PARTITION BY in your ROW_NUMBER() function.

Something like ROW_NUMBER() OVER(PARTITION BY keySystem ORDER BY id) AS [rowNumber1]

Bumped against that wall a few times myself 🙂

OK.

Keep in mind though that in the second CASE example, you will get a NULL when the length of sample is bigger than 9.

Personally I would check the length of...

Phil Parkin (10/29/2014)

---

It was an iso, but I extracted the files from it using 7-Zip and then did the install from...

This CASE statement does the following:

* if sample is NULL, return NULL

* if sample has a length bigger than 9, return 0

* else return first 3 characters of "0-prefixed sample...

Do you install from an .iso you downloaded?

Your entire case statement can be rewritten as RTRIM(SUBSTRING(Sample, 1, 6)).

This will return NULL when Sample is NULL. SUBSTRING on a non-null string will never return NULL, so you can...

Carlo Romagnano (10/29/2014)

---

I prefer STUFF

SELECT

stuff(Ms, 1, 1,'')

FROM

( SELECT

...

That is indeed quite close 🙂

You still need to install SSDT-BI. If Visual Studio is already installed, the BI templates will just be added to VS.

However, VS 2013 is for developing BI projects on SQL...