SQL Server

On the weekend, I helped a buddy find a tool to view SQL Server redo logs, which is quite good. I do not dare to enjoy it exclusively. I recommend it to you. I have successfully installed SQL server on the machine and can connect to use it, but

Data processing becomes more and more important and critical in modern enterprise operations, and may even become a bottleneck of enterprise development. the importance of data protection is self-evident. if an enterprise does not have a good data

 SQL Server Load balancer cluster:Http://www.grqsh.com/index.htmBeijing glui Trend Micro Co., Ltd. Moebius for SQL ServerAs of SQL Server 2008, Microsoft has not released the Server Load balancer component and can only rely on third-party software.

  I. Application scenarios: 1) The execution script of the job is used when two databases are synchronized at regular intervals using the job; 2) execute scripts for manual data synchronization.   Ii. Example: Use localdatabasename; Go -- Create a

How to interact with XML in SQL ServerXML can be said to be a flexible form of database performance. During database development XML is required, especially for data exchange. In SQL Server 2005, XML has become a popular data type, XML has been made

Generally, you need to obtain the current date and calculate some other dates. For example, your program may need to determine the first or last day of a month. Most of you probably know how to divide a date (year, month, day, and so on ), then,

The following are some SQL Server DBCC commands that can be used to optimize SQL Server. 1 . DBCC cachestats: Displays information about objects in the current buffer cache, such as hit rates. Compiled objects and execution plans. Example: DBCC

Prerequisites: This section describes SQL Server 2008r2. Other versions are not tested. The replication types are mainly transaction replication and P2P replication.   Whether it is high availability, high scalability, or high performance,

How can I forget the SA User Password of SQL Server? Ms SQL Server is installed on both the desktop and the current version to facilitate testing.After a long time, the password of the desktop SQL Server was forgotten ......Don't you ...... No way?

Symptom: Create Three query statements in the query Analyzer Begin tran Select * From Table1 with (tablock, updlock) After each execution, Block the original query statement in the first query analyzer InterfaceThen writeCommit tran At this time,

In the past, SQL Server only performed operations on the graphic interface. Now I find that my SQL language skills are getting worse and worse. For example, how to add associations for two tables, cascade update and delete. I checked it at night and

Restore the qualified files of Location A to the machine of location B. The Administrator of the other party does not understand anything, so he wants to be a dumb as much as possible, so as not to explain to him how to perform the operation for

I have read a lot of questions on the Internet about the BCP UNIX format file in window. The answer is basically to convert it to the DOS format using tools such as ue, because when the-r \ n parameter is added, BCP will automatically change to \ r \

SQL Server uses logs to restore the database A full backup + the latest log backup is required.   * -- Description:Report data changes in the primary database to the standby database in a timely manner.The data of the standby database can be used

Designing an application system does not seem difficult, but it is not easy to optimize the system performance. There are multiple options in terms of development tools, database design, application structure, query design, and interface selection,

The charindex and patindex functions are often used to search for characters or strings in a string. If the searched characters contain the characters to be searched, the two functions return a non-zero integer, which is the start digit of the

If you are in charge of a SQL Server-based project or you have just been in touch with SQL Server, you may have to face some database performance problems, this article will provide you with some useful guidance (most of which can also be used for

I have a question about SQL Server queries. The commodity code of a query statement is unique, and the unit price of the same commodity is the lowest record. The problem is as follows: Product Code quantity unit price supplier001 0.3

Recently I encountered a problem related to cursor locking. In short, it is related to http://support.microsoft.com/kb/953948. So far, reading Uncommitted has been a good experience, but the customer does not want dirty data. Method. I have never

In fact, we have been using the SqlServer connection pool. In the connection string, http://msdn2.microsoft.com/mtps NS = "http://msdn2.microsoft.com/mtps"/-->Pooling indicates whether to enable the connection pool. The default value is true,