Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Monday, December 18, 2017

Dev Articles
Search Directory
SQL Server

Home > Search > Knowledge Base > SQL Server > Bugs and Fixes > Bugs and Fixes
PRB: SQL Server CE Delete Query with a Subquery Over a Large Table May Stop Responding (Hang) (Q303004)        
Total Hits: 643  |  Today: 0       Rating:  
Read Reviews | Write Review | Your Rating: 

A Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) Delete query, with a subquery over a large table, may appear to stop responding (hang). For example, a query similar to the following may take a long time to return if the tables t1 and t2 are large:
delete from t1 where col1 in (select t2.col1 from t2 where t2.col2="something")The creation of indexes on the relevant columns of the tables may not solve the problem for this particular query.

What's New at DevASP.Net
04/23  A Debug Stopwatch
04/23  The virtual bool bug
04/23  Application.EnableVisualStyles Bu..
04/23  The Process Async Reader Bug
04/23  Load a DBF into a DataTable
04/23  Weird Error: Unable to Validate D..
04/23  ASP.NET and jQuery to the Max
04/23  Fixing Error: "SetConfigurationSe..
04/23  Generics in .NET
04/23  Builder Design Pattern
04/23  Abstract Factory Design Pattern
04/23  Prototype Design Pattern
04/23  Bridge Design Pattern
04/23  Composite Design Pattern
04/23  Decorator Design Pattern
04/23  Validation in .NET Framework 4
04/23  Windows Phone 7: How to Encrypt C..
04/23  Text box to accept only number
04/23  Using the Raw Input API to Proces..
04/23  Study EVM (Earned Value Managemen..

DevASP.Net - Disclaimer - Privacy