Viewing 15 posts - 16 through 30 (of 163 total)
DECLARE @FieldB int
SET @FieldB = 124
SELECT * From Table1
WHERE FieldA = (SELECT FieldA from Table1 WHERE FieldB = @FieldB)
January 23, 2010 at 11:50 pm
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...
January 23, 2010 at 11:43 pm
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...
January 23, 2010 at 11:38 pm
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.
November 25, 2009 at 10:17 pm
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...
November 12, 2009 at 5:48 am
Is it the fill factor of the index?
November 12, 2009 at 5:42 am
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...
August 14, 2009 at 2:00 am
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,...
August 13, 2009 at 9:04 am
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...
August 9, 2009 at 10:07 pm
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'...
January 17, 2009 at 7:37 am
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.
August 17, 2008 at 8:43 am
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...
August 17, 2008 at 8:40 am
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...
August 17, 2008 at 6:48 am
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?
August 17, 2008 at 6:25 am
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...
August 7, 2008 at 6:56 am