HI guys When catching waittime for waittypes from sysprocesses, sometimes I see values as high as "2005188812" for WRITELOG and some of these kinds...
Hi guys I have a question about profiler. When I trace a query, profiler shows it took 35 seconds to execute but if I run the same query in query...
Hi guys, I have a scenario in which I have a primary DB. I maintain either standby secondary DB using log shipping or I maintain secondary DB using...
Hi all The server is SQL Server 2000 (SP3) on Windows 2000 Advanced Server. The client tools are installed on a machine with Windows 2003 Server...
Hi I have a table called lockkeys which experiences frequent deletes/updates (may be 1000 per second while under heavy load). And because of this...
Separate names with a comma.