Try this:

DECLARE @FieldB int

SET @FieldB = 124

SELECT * From Table1

WHERE FieldA = (SELECT FieldA from Table1 WHERE FieldB = @FieldB)

I am not sure from where did you get those statements, but the data files (and the log files) of internal resource databases should be touched only by SQL Server...

I also see a DISTINCT clause on all queries.

You can also try removing them and place only one DISTINCT. I am not sure on the performance, but...

The issue could be connected to many areas:

1. Network error.

2. Application times out in less time (someone has changed the configuration value)

3. Execution plans have changed.

4. ...

If you are using transaction replication, it has two phases: During the initial setup, snapshot replication is set and it does not care about triggers.

When you add/update/delete rows after...

Is it the fill factor of the index?

So my question is: Does anyone have strong recommendations (other than readability:-D) regarding LEFT JOIN versus either of the other two? Are there any circumstances in SQL Server where...

10. WHERE clauses - In a WHERE clause, the various operators used directly affect how fast a query can run. Here are the conditional operators used in the WHERE clause,...

For example, table & index partition is an EE only feature. I haven't tested this, but that is what BOL says 🙂

So I expect you to face...

I too am facing the same problem. I installed sp3 on this server. I received an interesting description

DATE/TIME:1/17/2009 7:42:12 PM

DESCRIPTION:The SQL Server performance counter 'Buffer cache hit ratio'...

Additionally, did you try installing it on another computer? IF you get the same error, you can be sure that it is an issue with the installation files.

Install without VSS Writer first and try it as a single component again (through update process)

You can figureout the issue.

Also if it is not working, I am pretty sure...

Hi,

How much free space you have in the file?

I suspect that you are trying to shrink the file to a size where your data is holding larger space.

If that is...

This error could be an isolated issue related to the installation package you have and/or your computer settings.

Can you try installing evrything else except the troublesome component?

This could even be a data issue. IS there any branching, looping conditions you have?

Is your package starts and after processing something it fails (without error) or goes into an...