SQL Server

Optimize SQL Server 2000 settings SQL Server has been well configured to optimize its own performance, which is much better than other relational databases on the market today. However, you still have several settings that need to be modified so

1. instance reproduction of four types of transaction concurrency problems in SQL Server Zhu Er (2006.3 reproduced please note the author) http://blog.csdn.net/netcoder/article/details/633153This articleArticleIt will use instances to reproduce

"[Dbnetlib] [connectionopen (connect ().] SQL server does not exist or access is denied" occurs when the SQL server remotely connects to the database. There are many reasons, which are generally checked: 1. Firewall;2. port 1433;But today we find

Http://www.microsoft.com/showcase/en/US/details/4c8ad153-f195-47ae-aa2b-9d7847ec0b20 This video speaker is senior from the SQL customer Advisory Team (CAT ).ProgramManager mark Simms, a well-deserved "manager" of streaminsight (haha, because Mark'

Program Idea: Use select name from sysobjects where xtype = 'U' to obtain all tables, and then open the table cyclically, according to rs_colums.fields (I ). name: field name. fieldtype (rs_colums.fields (I ). type) to obtain the field type,

Read data from the ms SQL Server data table and save it to an Excel worksheet. Sub Returnsqlrecord () ' Sht is the Excel worksheet object variable, pointing to a worksheet Dim I As Integer , Sht As Worksheet ' Define the data link

String functions are widely used in database application development. The commonly used functions are indexed as follows)1. Str : Converts a number to a character. An optional parameter is used to specify the total length of the result (including

From: http://www.cnblogs.com/aodailiheben/archive/2008/08/06/1262227.html For the sqlserverexpress database connection configuration, I have seen it several times before. I have seen it again in an open-source software this morning. I feel it is

The syntax is as follows: 1 Description: copy a table (only copy structure, source table name: a new table name: B) (access available)Method 1: Select * Into B From A Where 1 <> 1 Method 2: Select Top 0 *

Document directory Data Synchronization in SQL Server 2000 Data Synchronization in SQL Server 2000   1. whether the ms SQL Server and SQL Server Agent services are started and run as domain users (. \ administrator users are also allowed) If you

You must regenerate the system database to repair the damage problem in the master, model, MSDB, or resource system database or modify the default server-level sorting rules. This topic provides step-by-step instructions on how to regenerate a

During database migration, SSMs is used to perform view operations. However, after the view migration is complete, configure peer-to-peer replication. In the last step, an error is reported, and the subscribed part is not created successfully. For

This article mainly describes the SQL Server temporary tables and table variables, as well as the differences between SQL Server temporary tables and table variables, when using tables in a database, we generally encounter two ways to use tables,

Use sqldmo to back up and restore Microsoft SQL Server databases Sqldmo (SQL distributed management objects, SQL distributed management object) encapsulates objects in the Microsoft SQL Server database. Sqldmo is the application interface used by

From: http://blog.csdn.net/missmecn/archive/2008/10/06/3019798.aspx related articles: MySQL database lock Several lock modes in Oracle Recommendation circle:Pipboy More related recommendations The Study of the lock mechanism requires two

After importing data to the customer today, we found a column containing many NULL data. When SQL Server is used for data import, the data type is float by default, and cannot be changed. As long as you turn to the omnipotent network I found it on

Encryption and decryption of SQL Server Stored Procedures and stored Functions StorageStoredProcess and storageStorageFunction ENCRYPTION: WITH ENCRYPTION       CREATE procedure dbo. sp_XML_main  @ Table_name nvarchar (260) = '',  @ Dirname

SQL Server has two parameters. Syntax:ISNULL (check_expression, replacement_value) The check_expression and replacement_value data types must be consistent.If check_expression is NULL, replacement_value is returned.If check_expression is not NULL,

Chapter 2 Disk I/O Configuration. For SQL Server, disk I/O configuration is mainly for database workloads. Consider and weigh two points: 1. disk capacity VS Disk Throughput A 1 TB database is placed on a 2 TB disk. The capacity is enough, but can

How to view disk I/O operation information The set statistics io on command enables SQL Server to display information about the disk activity volume generated by the Transact-SQL statement. We can analyze the index performance very