摘要: Original link: http://sqlinthewild.co.za/index.php/2007/09/04/execution-plans-estimated-vs-actual/This is the second post on execution plans. I’m going to briefly discuss estimated execution pla...阅读全文

摘要: The best place to start for analysing and resolving performance issues are these two articles by Gail.http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-p...阅读全文

摘要: ProblemOne of the junior SQL Server Database Administrators in my company approached me yesterday with a dilemma. He want to know how to enabled the Dedicated Administrator Connection in SQL Server 20...阅读全文

摘要: 在.NET平台下，程序集并没有直接承载在进程中（而传统的win32程序是直接承载的）。实际上.NET可执行程序承载在进程的一个逻辑分区中，术语称为应用程序域（也称AppDomain)。可见，一个进程可以包含多个应用程序域，每一个应用程序域中承载一个.NET可执行程序，这样的好处如下： 应用程序域是.NET平台操作系统独立性的关键特性。这种逻辑分区将不同操作系统加载可执行程序的差异抽象化了。 和一个...阅读全文

摘要: osql.exe -S %TARGETSERVER% -E -d Northwind -Q"select db_id()" > nulif %errorlevel% == 0 ( @echo. @echo Northwind DB already exists. @echo. goto end)@echo.@echo Creating Northwind DB ...@echo.osql.e...阅读全文

摘要: 'CString' to 'std::string':std::string cannot always construct from a LPCTSTR i.e. the code will fail for UNICODE builds.So the following conversion will lead to error:CString cs("Hello");std::string ...阅读全文

摘要: Original link: http://www.codeguru.com/forum/showthread.php?t=436716A: An easy way is to use FindFirstChangeNotification, FindNextChangeNotification and one of the wait functions in a worker thread. A...阅读全文

摘要: 1. #ifndef HEADER_BASE_HPP#define HEADER_BASE_HPP class base_class{ // some code};#endif // HEADER_BASE_HPPThe first line checks whether we have not yet defined 'HEADER_BASE_HPP'. If we have not, then...阅读全文

摘要: 在Windows的shellapi文件中定义了一个名为SHFileOperation（）的外壳函数，用它可以实现各种文件操作，如文件的拷贝、删除、移动等，该函数使用起来非常简单，它只有一个指向SHFILEOPSTRUCT结构的参数。使用SHFileOperation（）函数时只要填写该专用结构--SHFILEOPSTRUCT，告诉Windows执行什么样的操作，以及其它重要信息就行了。SHFile...阅读全文

摘要: Original link: http://www.codeguru.com/forum/showthread.php?t=269905Q: Why does program work in debug mode, but fail in release mode?A: First of all, there is no such thing as 'debug mode' or 'release...阅读全文