microsoft sql server

Asp+ The original author: Rain Morning Initial consideration (i) It includes the configuration of the running platform, the creation of Pagelet, the use of new ado+, the use of new datasets for data access, the transformation of HTML forms to

asp.net|server|sql| Recovery Last done a project, involving the restoration of the database and recovery, to the Internet to find a bit, is the use of SQLDMO implementation, as long as the addition of SQLDMO reference is good, and then use the next

Microsoft SQL Server database administrator, think fast! Without using any documents, write a query that extracts the list of indexes from the SQL Server 2000 system tables, then enumerates the fields in each index, and determines whether the field

If you delete data or objects in an Access database, an Access project, you can create fragmentation and result in less efficient disk space usage. At the same time, the size of the database file does not decrease, but it grows until your hard disk

ado| Optimization 1 Connection 1.1 Pooling in the Web application, often there are many users at the same time access to the database, and the ASP's object scope is page-level, that is, said that each page should be joined and disconnected

Error | Connection Database | network Occurs when connecting to a database "General network Error" The alternative explanation Revision History: Version Date Creator Description 1.0.0.1 2003-11-15 Zheng Draft Implementation

Introduction | Index today, "a once-in-a-century" blackout, read a day book. The evening made a full text index, decided to paste out the experience, I try to write in detail, we learn together, welcome to correct me! 1, start Microsoft Search

SQL language | QuickStart SQL is an abbreviation for the English Structured Query language, meaning Structured query language. The main function of SQL language is to establish and communicate with various databases. According to the ANSI (American

web| Server installs WebSphere Application server IBM WebSphere Application Server provides the ability to build, publish, and manage E-commerce. Its Standard Edition provides an open, standard platform. WebSphere Application Server includes the

Strategy Trace flag An overview Trace flags are used to temporarily set specific characteristics of the server or to turn off specific behavior Two categories 1. Bol record of the tracking mark Describe 260 print version information about the

Online analytical Processing Overview development background With the wide application of database technology, enterprise information system has produced a lot of data, how to extract information from these massive data to enterprise decision

The day of the wrong beginner SQL, feel like just learning to walk, gait can be, stumbling. I fell a lot of ridiculous somersault. Take out everyone to entertain, also mention each other wake up, such a mistake we can try to avoid. Look at this

asp.net|server|sql| Security | security | data | The database SQL Server installation has two options for Safe mode. The difference between them is which software performs the authentication process. Authentication is the process of confirming the

Functions | Encryption how does Microsoft SQL Server encrypt passwords? How do I make an undisclosed cryptographic function? If the users of the MSSQL information is interested, may find master.dbo.sysxlogins inside the user's password, but,

server| Solution | data | database The first is to provide a complex method for compressing logs and database files as follows: 1. Empty logDUMP TRANSACTION Library name with NO_LOG2. Truncate the transaction log:BACKUP LOG database name with NO_LOG3

server| Data | database Lock is a very important concept in network database, it is mainly used to guarantee database integrality and consistency under multi-user environment. The basic theory of lock used in various large databases is consistent,

sql2005| objects 1. Brief Introduction:In this series, I'll demonstrate how to use the SMO (SQL Management Objects) to implement a variety of common database management tasks, such as backup, recovery, indexing, integrity checking, etc.In this

server| Access | server Configure the SQL Server Analysis server to be accessed via HTTP Its HTTP access mechanism is the same as SQL2000 analysis, which enables access to the Analysis server by adding Application Mappings (ISAPI extensions) in

server| Security 1. Confirm that you have installed the latest patches for nt/2000 and SQL Server, needless to say everyone should have been installed, but I think it is best to remind you here. 2. Evaluate and select a network protocol that takes

server| Microsoft A workaround for SQL Server blocking. Blocking definition Blocking occurs when the first connection from the application controls the lock and the second connection requires a conflicting lock type. The result is to force the