nder normal circumstances, SQL database, the contraction does not reduce the database size to a large extent, its main role is to shrink the log size, should do this on a regular basis so as to avoid database log is too large. ......    [more]

In order to improve the server security, one of the most effective way to upgrade to SQL Server 2000 Service Pack 3a (SP3a). In addition, you should install all security updates have been released. ......    [more]

true: only the list of local examples; false: List all instances. SmoApplication.EnumAvailableSqlServers (String) Note: Specify the SQL Server instance installed on the computer name. Lists all the available instances of SQL Server. Return value is D......    [more]

List all names of duplicate records of the person (1) the most intuitive idea: to know all the names of duplication of personal data, you must first know which name to repeat:......    [more]

SQL Server 2008 setup and installation have also been improved. Configuration data and engine bits have been separated, so it makes the system is not configured to create a basic disk image becomes possible, which enables distribution to multiple ser......    [more]

Party A Party B in this contract rental lease period of the net web hosts continue in force, valid until Party submitted online rental period expires, only. Expiry of the contract Party A Party B that is shut down network net web host account; the tw......    [more]

Multi-dimensional data set is on-line analytical processing (OLAP) in the main target is a data warehouse can quickly access the data technology. Multi-dimensional data set is a collection of data, usually from a subset of the data warehouse structur......    [more]

SQL Server there are two kinds of backup, one is to use the BACKUP DATABASE database file backup to go out, another was a direct copy of the database files mdf and log files ldf way. In this article we describe the latter will focus on backup and rec......    [more]

Graphical user interface that allows system management more intuitive and simple. A rich programming interface for user application, designed to provide greater choice. With the Windows NT operating system, the organic integration, multi-threaded arc......    [more]

But I always believed that every generation must be because the concept ran into insurmountable problems. In other words, without it, will inevitably lead to some of the problems difficult to solve. So I think from this angle cut into the hope that t......    [more]