Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Troubleshooting   (RSS)

Insight into SQL Server Compact database corruptions

Database corruptions are often the most painful bugs to repro and debug. A good percentage of the SQL Server Compact bugs reported are in this category. However it so turns out that in majority of the cases Compact is not the culprit. Surprised!! Let
Posted by SQLCEBLOG | 2 Comments
Filed under: ,

Query performance

Understanding the reason for slowness of a SQL query and then tuning to boost it is a slightly complicated process, but it can be extremely rewarding in some cases. In this post, I am going to list down some ways in which you can tune the query performance

"Houston, we got some problem..." and "Houston, we got a problem..." - notice a difference?

So you have run into a problem - how to efficiently report this: System configuration: On a Desktop/Server, Run Winver from Start -> Run. On a Pocket PC, Start -> Settings -> About On a Smart Phone, a bit more steps - start -> Settings ->
Posted by SQLCEBLOG | 1 Comments
Filed under: ,

Can’t find P/Invoke DLL sqlcemeNN.dll

I know this is very annoying, uninformative, directionless…blah blah… error. And, kindly pardon me for blogging about this error very lately. Better late than never and here it goes. What are the actual errors? 1) Can't find P/Invoke DLL sqlceme30.dll
Posted by SQLCEBLOG | 10 Comments
Filed under:

Troubleshooting: Can’t load sqlce dll

SQL Server CE/Comapct uses Windows API LoadLibrary ( PlatformBuilder or WinCE or Win32 ) to load the DLLs. When LoadLibrary fails to load any SQL CE dll, we throw the error “Can’t load sqlce dll”. Now, let’s discuss more on why LoadLibrary can fail. 1)
Posted by SQLCEBLOG | 3 Comments
Filed under:
 
Page view tracker