SQL Server

For the database replication function has not been used, just this time need to do data synchronization between the database, the database replication synchronized collation. Database synchronization can be the synchronization of data between

Microsoft has a hobby called binding. I hate it most. A binding is the binding of IIS to Windows-upgrading IIS to upgrade the operating system, the server is not a PC, the system does not want to reload can be re-installed.When using SQL Server log

Introduction We do not talk about what the cursor concept, steps and syntax, first look at an example:Table One originsalary table two addsalaryNow there are 2 tables, one is the Originsalary table-the payroll, there are three fields 0_id employee

SQL Server black Box Trace--Learn more about SQLDIAGSQL Server provides a special command tool, SQLDIAG, to help collect information that is used to locate problems with SQL Server. You can find the file in the same directory as the other SQL Server

SQL Server ring buffers (ring buffer)--loop buffering in AlwaysOn applicationsYou can get some diagnostic AlwaysOn information from the SQL Server ring buffer, or dynamically manage views from sys.dm_os_ring_buffers. The ring buffer is created when

SQL SERVER default tracking app 4--automatic growth of detection log filesUsers complain that the SQL Server database is running very slowly. This query, which is tracked by default, can identify the long run caused by the log file autogrow activity.

A stored procedure that merges word Fulu is recently being processed, and in the development of a test system, a string merge function is used to do it directly in SQL.Example:Table contents:Name Content1 ABC1 AAA1 dddd2 12232 FKDJFD-----------------

partition table in SQL Server 2005 (vi): Converting a partitioned table to a normal tableCategory: SQL Server2009-12-14 14:28 5210 People read comments (+) Favorites report SQL Servermergefunctionsql2010goMy Russian name is "do not toss

Recently found that the server on the outside of the network inexplicably restarted, the server is currently mainly started the IIS services, SQL Server services. Remote login, found that the system response is very slow, there is a noticeable sense

Original: SQL Server lock partitioning feature raises deadlock resolutionThe lock partitioning technique allows SQL Server to better handle concurrency scenarios, but it can also have a negative impact, as described in this example, to analyze the

Original: SQL Server optimizer attribute-implicit predicateAs we all know, a SQL statement submitted to the optimizer produces a corresponding execution plan and then executes the output, but how does his execution plan come about? This may be the

Anatomy of SQL Server sixth to avoid regressions in system tests for Orcamdfhttp://improve.dk/avoiding-regressions-in-orcamdf-by-system-testing/The risk of bugs is increasing as I continue to add new features and new data structures to support the

After AlwaysOn is configured, because there is no use of the full recovery model, the simple or bulk-logged mode is not available, so the log is growing and cannot be emptied using the change recovery modeManual operation shrinking or truncating the

The first step:See if these CPUs are used by SQL Server.Step Two:Determine if SQL Server has raised a 17883\17884 errorStep Three:Find out which statements are optimized using the highest CPU. (Sys.dm_exec_query_stats

As we all know, a SQL statement submitted to the optimizer produces a corresponding execution plan and then executes the output, but how does his execution plan come about? This may be the most complex part of a relational database. Here I'll

A temporary table is a table that is built into a temporary system folder and, if used properly, can be done in a variety of ways, like a normal table, and automatically released when VFP (Visual FoxPro, the latest Visual database management system

Generally do not modify the default level of SQL Server transactions. Forced lock is not recommended1 Execute EXEC sp_lock report information about the lock1 How to lock a row in a tableSET TRANSACTION Isolation Level READ UNCOMMITTEDSELECT * FROM

Multiple update operations in a stored procedure, followed by an exception to the update operation, if you do not manually rollback the previously modified data is not automatically revoked! BEGINTRYBEGIN TRAN-- ..... COMMIT

Isolation levels in SQL Server control the locking works between transactions.SQL Server supports the following isolation levels Read UNCOMMITTED Read Committed (the default) Repeatable Read Serializable Snapshot Before

Respecting the original works: This article is for reference from http://www.jb51.net/article/43540.htm--begin distributed TRANSACTION [Transactionname]--Flag a TSQL distributed transaction managed by the Distributed Transaction Coordinator MSDTC