Hi, I have SQL Server 2005 STD running on Windows Server 2003 and performance is slow at times. RAM: 8 GB 4 Processors Paging File/Virtual Memory...
hi experts, My 2005 database is experiencing lots of transaction deadlocks. I want to run a Profiler Trace that will collect the Database Name,...
Hi everyone, I'm using (2005's) sys.dm_db_missing_index_details DMV to identify columns that should have indexes. It returns a lot of extraneous...
Hello everyone, In 2005, has anyone found a good way of finding the names of Tables that full scans are occurring on? And maybe even the SQL code...
hi everyone, I'm running 2005 on a Windows 2003 server and I suspect I have a bottleneck in disk I/O. I have read that if I run Diskperf -ye (at...
hi all, My question is for 2005. I have a table that contains information about some tables: table name, number of rows, index name and...
hi experts, This is 2005 SP2 My Maint plan spun out of control and the log became full before the m plan completed. The db data size is 8 GB and...
Hi experts, Using 2005's Export wizard to do a quick, ad-hoc report. When I run the query it does select 15 rows, but the same query inside the...
hi experts, I have been backing up my 20 GB database in various ways, just to see the benefits of the SQL Server compression feature, and I have...
Hi expeerts, hmmmmm. At the database level, the user has only Connect and Select: USE AVNAPPDB; EXECUTE AS USER = 'CORPORATEuserX'; SELECT * FROM...
hi everyone, This is 2005 Std SP2. I would like to log blocing info into a table over a 24 hour period. DBCC inputbuffer(YourSPID) is good for...
hi, We have 2005 at SP2. Management Studio shows 9.0.3042 which I suppose is Build # 3042 the base SP2. 1. Is there a more accurate way to find...
hi everyone, This statement will insert a maximum of 1 row. I thought there was a way to check for number of rows inserted... if you ran that...
hi experts, I had such high hopes for 2005's Blocked Process report. Ran sp_configure 'blocked process threshold', 12; (12 seconds) GO...
Hi all, We are changing the Transaction Isolation Level from SERIALIZABLE to READ COMMITTED... (mostly to prevent severe blocking) My question is...
hi all, When does a SPID status change to 'Sleeping' and what does that indicate? I'm assuming that after so many seconds or minutes have passed...
Hi everyone, In 2000 it was not so easy to find all tables not having any indexes. I'm hoping there is a Dynamic management view in 2005 or another...
hi everyone, This is SQL Server 2005 Std SP2 Hmmm... even after dropping and recreating the index and clustered Pprimary Key, DBCC SHOWCONTIG still...
hi everyone, SQL Server 2005. During periods of heavy usage (especially when blocking is occuring), when I click the 'Activity monitor' in...
Separate names with a comma.
