Archive for March, 2008

MSJetSQLforAccess2000 Intermediate article (III)

Monday, March 31st, 2008 Posted in SQL SERVER | No Comments »

  "Based on Microsoft Jet SQL for Access 2000" the article tells us how to use SQL to retrieve and manage stored in a database of information.    This ... Read more..

Not open the SQL Server password encryption function

Monday, March 31st, 2008 Posted in SQL SERVER | No Comments »

  If the MSSQL users are interested in the information may be found master.dbo.sysxlogins stored inside a user's password, but then, password field, if not null is a pile ... Read more..

SQL Server understanding of the importance of the transaction log

Monday, March 31st, 2008 Posted in SQL SERVER | No Comments »

  The transaction log (Transaction logs) in the database structure is very important but often overlooked part.    As it is not like the schema in the database as ... Read more..

How to fix SQLSERVER database "indisputable"

Monday, March 31st, 2008 Posted in SQL SERVER | No Comments »

  You can see in the SQLSERVER ERROR LOG OS and application logs should have the wrong message 1105:    SQL Server transaction log may be filled, this ... Read more..

SQL Server2005 and the contrast DB28.2

Monday, March 31st, 2008 Posted in DATABASE BASIC | No Comments »

  An overview of the results comparison    In this paper, the two database platform in the comparison showed that in the construction of the database application, the ... Read more..

SQL Server storage experience and optimize the process of the preparation of measures

Monday, March 31st, 2008 Posted in DATABASE BASIC | No Comments »

  I. Introduction: After a period of storage after the development process, wrote a summary of some of the development time and experience and share the hope that useful ... Read more..

SQL Server2000 a specific description of the experiment

Monday, March 31st, 2008 Posted in DATABASE BASIC | No Comments »

  Today do sql server 2000 of an experiment to compare the kind of simple, the new database, modify the size of the log file it, and so on, ... Read more..

sql to the Oracle database should pay attention to the issue of conversion

Monday, March 31st, 2008 Posted in DATABASE BASIC | No Comments »

  There are many applications, the time to start MYSQL database can basically achieve the various functional requirements, with the number of users, the increase in volume of data, ... Read more..

SQL Server database query optimization and paging algorithm (3)

Monday, March 31st, 2008 Posted in DATABASE BASIC | No Comments »

  Third, to achieve small amount of data and massive data storage shows that the General tab of the establishment of a web application, the tabbed browsing essential.    ... Read more..

Optimize the use of practical tools to optimize the performance of SQL Server

Monday, March 31st, 2008 Posted in DATABASE BASIC | No Comments »

  In the Microsoft SQL Server 2000 to provide some practical tools optimize the use of these tools can be effective in raising efficiency in the use of the ... Read more..