I am running SQL Server 2005 SP1. I have a linked server connection between 2 servers with replication set up. When I run the following, data is...
We have 18 servers, all running Windows 2003 R2, with SQL Server 2005 SP1. We have approximately 40 databases per server (give or take, plus or...
Can high CPU due to high recompiles feed off itself, meaning, the connections and activity on our server increases: 1. Which causes a higher number...
We have about 200 databases on approximately 20 servers and possibly doubling in the near future. These databases have identical schemas. We are...
So, if I run DBCC LOGINFO(TempDB) and return the following, is that telling me all the Status 2 rows are waiting to be written to TempDB, have been...
We have a number of complex queries in stored procedures that sometimes run well (under 5 seconds), but other times take several minutes (with an...
I was wondering...I have a select statement that inserts into a Temporary Table. From my understanding, the select statement should not be locking...
I have a blocking issue, running SQL 2000, SP4, on Windows 2003.<br /><br />The SPID at the head of the blocking chain = 226. SPID 226 has the...
I am attempting to optimize a query inside a stored procedure that has approximately 16 joins, having about 10 inner joins, and 6 left joins. I have...
How do you explain the different results between the following statements: --**************STATEMENT #1 **************************** DECLARE @GUID...
I am running SQL Server 2005 on Windows 2003. I ran the following statement and returned the following: SELECT SERVERPROPERTY('productversion'),...
I am trying to wrap my mind around the counter values returned from master.sysperfinfo.<br /><br />For example, the object/counter SQLServer<img...
I have a server that is undergoing performance issues. Showcontig shows little fragmentation. Server memory setting is dynamic, with 0 Min and 8023...
To make use of the counter value returned when running sys.dm_os_performance_counters, looking at Object_Name = SQLServer<img...
We are nearing the time to migrate to SQL 2005 and am trying to transition from master..sysprocesses to sys.dm_exec_requests. When I run...
I am trying to understand the Wait_Time column in sys.dm_exec_requests. BOL says concerning Wait_Time: "If the request is currently blocked, this...
If I execute the following statement on a nonclustered index there is no reduction in fragmentation on the index: DBCC DBREINDEX...
How might one rewrite the following WHERE clause of the following "Original Statement" into an equivalent dynamic SQL. The data type of variable...
I run a select statement resulting in the following explain plan:<br /><br />SELECT Min(TableUID) AS Table_UID, Field1, FieldFKID FROM dbo.MyTable...
I have the following query that needs to be rewritten (if possible) so that the clustered index on column "coldate" can be utilized. Any suggestions...
Separate names with a comma.
