SQL Server

Note In Microsoft's SQL server system, you can use indexes to improve the query performance of the database. However, the performance improvement depends on the implementation of the database. This article will show you how to index and effectively

When I have any questions, I often come back to the blog Park to find the answer. Over time, I have summarized some things.Please give your comments and comments on your mistakes. Three basic principles of database design paradigmParadigm 1:

The deadlock policy described in the online book of SQL Server shows the following situation: Worker threads. A queued task waiting for an available worker thread can cause deadlock. if the queued task owns resources that are blocking all worker

Since 2005, the replication technology of sqlserver has become very mature and effective. Many companies have chosen this technology for read/write splitting. Replication now includes transactions,Merge and snapshot, each of which has its own

Many developers want to be a DBA, and many people first position themselves as a DBA. What knowledge and skills do DBAs need to master? Below are my During DBA work and interviews with DBAs, there were thirty questions about DBAs. Among the thirty

The following exception occurs during the configuration of transactional replication in SQL Server 2005/2008. Exception information: Replication. Utilities---------- SQL Server replication requires an actual server name to connect to the

1. Back up the original database file (test_data.mdf, test_log.ldf ). Then, create a new sqlserver registration in the Enterprise Manager. If it is on the local machine, runIf no logs are attached to the database, a new database log file is

System database of SQL Server 2000 After the SQL Server 2000 Server is installed, four system databases are created. They are master, model, MSDB, and tempdb.1. master databaseThe master database is the most important database in SQL Server 2000.

Database backup and recovery I. Back up the database 1. Open SQL Enterprise Manager and click Microsoft SQL server in the root directory of the console.2. SQL Server group --> double-click to open your server --> double-click to open the

Create a simple trigger A trigger is a special stored procedure, similar to an event function, SQL Server? Allows the creation of triggers for insert, update, delete, that is, one or a series of T-SQL statements that are triggered when a record is

Symptom: InstallSQL Server 2000Prompt: "previousProgramInstall a file that has been suspended on the installation computer. You must restart the computer before running the installer.   Solution: First: Open the Registry Editor and

How can I restore some data deleted by mistake on SQL server? Some data of My SQL Server has just been deleted by mistake. I have separated the database. A friend told me to delete some SQL statements in the log file using the log tool, then I

  SelectConvert(Varchar(100), getdate (), 0): 05 16 2006 AM SelectConvert(Varchar(100), getdate (), 1): 05/16/06 SelectConvert(Varchar(100), getdate (), 2): 06.05.16 SelectConvert(Varchar(100), getdate (), 3): 16/05/06

' Method 1 Public   Sub executesqlscriptfile () Sub Executesqlscriptfile (CN As ADODB. Connection, sqlfile As   String ) Dim Strsql As   String , Strtmp As   String Open sqlfile For   Input   As # 1 Strsql =   "

Create Function Fun_getpy ( @ Str Nvarchar ( 4000 )) Returns Nvarchar ( 4000 ) As Begin Declare @ Word Nchar ( 1 ), @ Py Nvarchar ( 4000 ) Set @ Py = '' While

/* Function Name: sp_getrecordfrompageFunction: obtains data on a specified page.Parameter description: @ tblname indicates the name of the table containing data.@ Fldname key field name@ Pagesize number of records per page@ Pageindex: page number

Method: 1. backup log billionlinksoft_vip with no_log (recommended)Then shrink the database in the enterprise manager. You can also execute:DBCC shrinkdatabase (billionlinksoft_vip) 2. Dump transaction database name with no_log (the old SQL

when querying a product on a product introduction website, the product's introductory text may be long. If you use like to perform fuzzy search on the product introduction field, performance is definitely a problem. How can this problem be solved?

This article is justEntry LevelDatabase case. I hope you can share and discuss some typical cases. Database Case 1: A simple user table.   Business hypothesis: User table, 10 columns, no foreign key, 2 million data (if the data volume is

Running environment: Dot NET 2.0 or above Sqlserver2005 management object SMO. Sqlserver2005 is installed by default.   Function: 1. Compile scripts for all images in the specified user database 2. Compile a script for a single object in the