Viewing 6 posts - 16 through 21 (of 21 total)
I haven't got an answer, except to say you're not going mad - I have exactly the same problem on my PC. I have given up using ODBC Data Source...
February 9, 2006 at 2:46 am
IMHO, SQL Server is short of analysis tools - Oracle, for example, comes with a tool named tkprof which does pretty much what you want.
For SQL Server, SQL Profiler is...
February 9, 2006 at 2:40 am
OK.
What version of SQL server ?
What indexes do you have on the table ?
What is the execution plan (Query Analyzer will show you that) ?
February 7, 2006 at 11:01 am
I don't know about spawning SPIDs via sp_OAcreate. But the "Host" and "Application" columns in the process info view (which are simply read from the table master.dbo.sysprocesses) are filled in...
January 24, 2006 at 2:06 am
In reply to Carl B: I don't think I've seen this behaviour in any documentation. I discovered it the hard way - first from the logging info given by Trace...
November 3, 2005 at 4:48 am
It is possible to get a deadlock just with a SELECT, even at the default READ COMMITTED isolation level. IMHO this is a design error in SQL Server. SELECTs never...
November 2, 2005 at 7:17 am
Viewing 6 posts - 16 through 21 (of 21 total)