SQL Server

A business scenario that requires a union query:The query is very slow and takes about 37 seconds:Direct replication SQL in the database client execution, fast, it is known that the reason for MyBatis, on-line search, you can configure fetchsize= "50

Original text: A brief analysis of the locking problem of SQL Server to prevent the range lock of Phantom read under Serializable isolation levelThe source of this article: http://www.cnblogs.com/wy123/p/7501261.html(It is not the original works

Original: SQL Server Bug: Replication schema change parameter (REPLICATE_DDL) is invalidRecently tested schema change issues for updatable subscriptions, and a bug was found.In replication, when schema changes are made to the publication database at

In SQL Server replication (Replication), it is possible that the need for a new table or some tables to an existing replication (publish subscription) may occur due to changes in business requirements, which should be normal and common. However, in

When using SQL Server, we often encounter a situation where a database on one server needs to be transferred to another server. When the transfer is complete, an error often occurs when you need to associate a "user" with a "login":"Error 15023:

Recently, no intention to discover the MySQL client monitoring tool "Nero profile SQL", just at the beginning do not know how to use, after half an hour groping, now will use the steps to write down.Background: When developing, if the data storage

MD5 and sha1 are one-way encryption Algorithm It is often used for password verification and other scenarios requiring encryption operations. In general, developers can write related functions themselves or use their own functions through Delphi or

SQL Server 2000 SQL Server evaluation period has expired Solution Two days ago, the server had to be restarted for some reason. After restarting, it was found that SQL Server2000 could not be started. Click "start" in the Service Manager and it

When porting a server, because the environment also needs to be transplanted, but the ODBC registry configuration and the installed office are pilot, an error is reported, and the enterprise manager and ODBC cannot be opened. The following error

Yesterday, someone discussed in the group three functions that SQL server returned the last identity value: ident_current, @ identity, and scope_identity, and made some markup and summary. In fact, msdn has an official explanation for this: all

Source: http://blog.csdn.net/qygaojiansheng/archive/2009/04/26/4126364.aspx   If the table already exists, the SQL statement is: Insert into AA select * From OpenDataSource ('Microsoft. Jet. oledb.4.0 ', 'Data source = D: \ outdata.xls;

There are many reasons for slow query speed in SQL Server databases. The following are common causes: 1. No index or no index is used (this is the most common problem of slow queryProgramDesign defects) 2. Low I/O throughput, resulting in a

Author: drillchina, source: blog, responsible editor: Li shuqin, in SQL Server performance tuning, there is an incomparable problem: that is, how to take a long time Code Or are temporary datasets processed in frequently called code? Table

For those that have downloaded Visual Studio 2008 to get the latest version of SQL Server compact and sync services for ADO. net, you'll notice that we don't install the documentation for these products with Visual Studio. Why? Well, our

Cursor is a method for processing data. To view or process data in a result set, A cursor provides the ability to forward or backward data in a result set by one or more rows. We can use a cursor as a pointer, which can specify any position in the

19.2.1 understand SQL Server Profiler SQL Server Profiler is a graphical real-time monitoring tool that helps the system administrator monitor database and server behaviors, such as the number of deadlocks, fatal errors, and track Transact-SQL

Monitoring Overview We mentioned MSSQL monitoring based on SQL event in the previous section, but sometimes we need more detailed monitoring that is suitable for tuning and troubleshooting. The visibility of running SQL Server is the possibility of

Common SQL server connection failure errors and Solutions   When using SQL Server, the most common problem you encounter is that the connection fails. Generally, there are two ways to connect to SQL Server. One

Post a translation FAQ (if I can write this level ...), This step is almost applicable to the most common SQL connection problems. FAQ: Check for SQL connection errors. Q: I have encountered many SQL connection errors. Is there a wizard to solve the

 1. Insert data to Excel in SQL SERVER 2. Export the data queried in SQL SERVER into an Excel file      1. Insert data to Excel in SQL SERVER Insert into opendatasource ('Microsoft. JET. OLEDB.4.0 ', 'excel 5.0; DATABASE = c: \ book1.xls ')...