SQL Server

1, first to understand what is called the implementation plan?An execution plan is a query scheme that the database makes based on the statistics of SQL statements and related tables, which are generated automatically by the query optimizer, such as

Original: SQL Server Tuning Series Basics (Summary of common operators)ObjectiveIn the previous article we looked at how to view the query plan, this article will introduce the analysis techniques in the query plan we looked at, as well as several

Tag: SQL Server transaction is fullError description: The transaction log for the database is full. To find out why the space in the log cannot be reused, see the Log_reuse_wait_desc column in sys.databases.First introduce the concept of transaction

SQL Server Profiler is a SQL Server Enterprise Edition with a very powerful statement tracking and analysis tool. Using it skillfully is useful for us to analyze database performance issues, such as when data Access uses an ORM framework such as EF,

Often in the forum to see the question of high CPU, Shenyang 463 plastic Surgery Hospital Procedures Simple summary.1, first of all you have to confirm that the high CPU is not caused by the SQL Server process or other processes caused, this is easy

SQL Server Profiler-Debug DeadlockTracking generic exceptions is simple, but dealing with deadlocks is difficult, with a deadlock message number of 1205 and a severity of 13. The only suggestion that the server can "rerun the transaction" is that it

Original: (original) automatic remote database backup for SQL Server 2005Due to project needs, the database on the target server needs to be backed up and transferred daily, check some of the online help, combined with their own actual needs, wrote

First of all, I am just a programmer, not a professional DBA, the following article is written from a problem solving process, rather than the beginning to give you a correct result, if there is something wrong in the text, please correct the

Source: http://www.cnblogs.com/marvin/p/HowCanIHandleBigDataBySQLServer.htmlFirst of all, I am just a programmer, not a professional DBA, the following article is written from a problem solving process, rather than the beginning to give you a

SQL Server black Box tracing--How do I enable black box tracing?This trace is configured by setting the @options parameter value of the sp_trace_create to 8来. @options Specifies the option for tracking settings, when the setting value is 8, which is

Text: line break for SQL Server print statementsline breaks for SQL Server print statementsYou want to wrap the print statement in the output, you can do this/*Line Wrap tab for SQL char (9) newline character char (10) Carriage return char

When you understand a SQL Server database, you can first observe it from the architecture of your database. The architecture of SQL Server contains 4 main components: Protocol layer (protocols) Relational engines (relational engine),

It is not very understandable why the option to block saving changes that require re-creation of tables is included in SQL Server 2008 and later versions. It is too troublesome to be "blocked" every time the table structure is modified. It's not

AskSQL Server database queries are slow for a number of reasons, and are common in the following ways:1, no index or no index (this is the most common problem of slow query, is the defect of program design)2, I/O throughput is small, forming a

Original: SQL Server index and table architecture (including column index)Include column indexOverviewThe include column index is also a nonclustered index, and the index structure is the same as the clustered index structure, where the non-key

SQL SERVER Build Number: SQL Server Version Internal Database Version SQL Server 2014 98| SQL Server 2012 706 SQL Server R2 665 SQL Server 2008

Original: SQL Server index and table architecture (clustered index)Clustered indexOverviewThe concept of index and table architecture has always been the discussion of a lot of topics, including the table of various storage forms is the focus of

Take a look at the example of a foreigner, an example of an incorrect place,Http://www.kodyaz.com/t-sql/sql-merge-command-for-summary-table.aspxCreate Trigger trmergeproductsummary on productdetails after Insert, Update, Deleteasbegin; Merge

SA and Windows Authentication cannot log on to SQL Server for some reason, and you can modify the SA password in exclusive modeStop the SQL Server service in Service Manager, then open the command line, go to the SQL Server installation directory,

How to send HTML-format mails in SQL Server, SQL Server SQL server sends an html-format email. The reference code is as follows: DECLARE @ tableHTML NVARCHAR (MAX); -- get the current system time and data statistics time set @ d_nowdate = convert