The "media" folder would be the folder that contains the installation media.  So wherever you are running "setup.exe" from is the folder you would use for that.

IF you don't have...

You should be able to use the default installation folder UNLESS it is asking for the installation media folder in which case you will need to point it to your...

I can answer question 1 for you - other transactions on that database that select data may have no issues.  Ones that change data will fail.

For question 2 - I...

• This reply was modified 4 years, 11 months ago by Mr. Brian Gale.

I agree with Phil that it probably isn't a TFS issue.

Step 1 with debugging that for me would be to grab a different developer and have them try what I...

In the event you don't need unicode data in the body, you could convert it to a VARCHAR(MAX) as one thought.

Alternately, if you select the max length of the body...

Dimitri,

I want to apologize for sounding pessimistic about this.  I do see where the tool could be beneficial.  Where I work, it wouldn't be, but like you said, when you...

It is an interesting concept but it is still incredibly tricky to calculate.  Lets say I do partitioning on my table and throw all of the "old" data onto slower...

That is a nice and easy one:

 UPDATE [#partswithcompany]
 SET [companyId] = [PARTS].[companyId]
 FROM (SELECT [partNumber], MAX(companyID) OVER (PARTITION BY partnumber) AS companyID FROM [#parts]) AS PARTS
...

My opinion - I would install the R/Python stuff in SQL if you need it to store processed data in SQL OR you need it to process data that will...

The cause of having 58% sort operation is a 2 part question.  The sort is probably due to something on your clustered index so the data needs to be ordered...

Service Broker (not sure it works in express but I expect so) would be another option and would be near real time, but may also be overkill.  Linked server and...

I would do something like

SELECT appt_time + duration as end_time

BUT that assumes that the datatypes on those 2 columns can be added together.  For example, if they...

I would start by comparing the data in the two systems.  Pick a table and compare the values between the two.  It COULD be that the user expected data, but...

If you NEED to do this in SSIS, I think you are going to need a for each loop (or similar).

If you can do this on the TSQL side before...

I agree with ScottPletcher here that there is little value in that sort of assessment and there is a LOT of things that can impact it.  If your table has...