Lock Pages in Memory is a Windows security setting policy that determines which accounts can use a process to keep data in physical memory, which prevents the system from paging the data to virtual memory on disk, directly improves the response time speed of the process, especially data-intensive program such as SQL Server database management system, as access time from RAM is definitely faster than disk I/O.

Continue reading Enable Lock Pages in Memory to Prevent Database Paging to Disk » » »

MySQL Workbench is the next-generation visual database design tool. MySQL Workbench is the successor to DBDesigner 4 from FabForce, and database administrator (DBA) or MySQL developer can use the utility to design, model, create, manage, maintain and document database schemata in a single, seamless environment for the MySQL database system.

Continue reading MySQL Workbench - Visual Database Deign Tool Free Download » » »

MySQL database has built-in full-text search capability that allows SQL queries to perform search quickly using MySQL database engine. The full-text search capability depends on the FULLTEXT index which is been created on various table fields or columns. However, some search queries may not return the experted results or datasets, even though the data is verified to exists on full-text search, especially on short keywords or search terms.

Continue reading How to Change MySQL FULLTEXT Index Minimum and Maximum Length of Words » » »