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, 10 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...

Was just reviewing the execution plan, and my thoughts are (experts feel free to tell me I'm wrong here):

1 - the "SELECT(COUNT()...)" statements are checking if the result is less...

Kristen,

In your scenario, I am not sure service broker is the route I would go either.  The biggest part that would make me use a different solution is that there...