Interesting to compare the actual execution plans generated, especially when looking at them with SQLSentry Plan Explorer (Free Edition).

DECLARE @DuplicateMembers TABLE

(

MemberID int

, FirstName varchar(25)

, LastName varchar(25)

)

INSERT INTO @DuplicateMembers

SELECT...

Named instances use dynamically assigned ports. The browser service normally handles this behind the scenes but the port(s) used still need to be open.

I'd love to replace it but if I can salvage it now, that would be better. I can look at a replacement when personal funding is better, which will...

Going to start with just a power supply swap. I have several PC's sitting around, just need to be sure that the one I use has the needed power...

DO the the underlying tables in the view have primary keys defined?

Use the NOEXPAND hint when you query the indexed view, see if that helps.

Could use a little advice here.

Looks to me that you may need to run your log backups more frequently than every two hours.

You may also have a problem with many small VLF's. Not sure...

Also, if you don't specify the parameters it is assumed that the values are being passed in using the order that the parameters are defined. In this case your...

A few things would help. First, the actual execution plan for both queries. Second, what is the query attempting to accomplish? If you could post the DDL...

Your code:

SELECT

Tranid,

cmttrantype,

txnflag,

tranref,

FeesType

FROM dbo.etl_TEST

WHERE TranId IS NOT NULL

Look close...

It means the time reported is accurate to 100 nanoseconds. You won't get any time values less than that reported.

If you need more information you may want to try...

Hoping this is late enough not to be useful with your interview but soon enough to help you learn something:

WITH Salaries AS (

SELECT

EmpID,

...

You may get an error, misplaced parens and the sort is wrong.

Making it a hot link:

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/31f80c1f-6285-4966-b7ed-9d0f93816f52