SQL Server

It is understood that the vast majority of developers understand the index is smattering, limited to the majority of daily work without opportunities, and what is not necessary to care about the index, it is a query is too slow to find the query

Original: 17th-Configuring SQL Server (2)-memory configuration in 32-bit and 64-bit systemsObjective:This article covers memory configurations in 32-bit and 64-bit systems, where DBAs often try to turn on AWE to limit memory in SQL Server 2005/2008.

IntroductionSQL Server 2008 introduces CDC (Change Data Capture), which can record:1. What data lines have changed2. The history of data row changes, not just the final value.It implements asynchronous change tracking (like transactional replication)

Original: SQL SERVER memory allocation and common memory issues (1)--IntroductionFirst, the question:1. The amount of memory that SQL Server consumes has been increasing since startup:First of all, as a mature product, the chances of memory overflow

ObjectiveIn the previous article, we analyzed how the query optimizer works, including: detailed operation steps of the query optimizer, analysis of filter conditions, optimization of index items, and other information.In this article we analyze the

Anatomy of the SQL Server kernel Architecture (reproduced)This article in my computer for a long time, today careless to turn out, think write very good, so posted out to share.Have to admit that a good software is a step-by-step accumulation of

DB driverThe following drivers are common: Odbc ODBC, open Database Connectivity, is an integral part of the database in the Microsoft Open Service Architecture (Wosa,windows Open Services Architecture), which establishes a set of

SQL ServerExtended Event (Extended Events)--monitoring deadlock script implementation using extended event tracking--Create a new event session (it is better to Create a new session and not modify the system ' s built-in session "System_h Ealth "):

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 of our commonly used operator optimization techniques, the same emphasis

In large database applications, it is common to encounter partial data offline and multiple database consolidation issues. For example, there is now a province-wide application, each city has deployed a separate application server and database

Microsoft has introduced many highly available technologies for SQL Server, such as early replication, later log shipping, database mirroring, SQL Server clustering, and so on. In SQL Server 2012 There is also a killer, and Oracle has a fight! SQL

SQL Server 2016 really makes a person's eyes shine. A few days ago Microsoft provided a download of the RCO (candidate release version). I've been watching a lap RCo version, one of the most drag features is database-scoped configuration (db Scoped

Original: SQL Server 2012 autogrow column, value hopping problemIntroducedStarting with the SQL Server 2012 version, when the SQL Server instance restarts, the values for the autogrow column of the table will jump, and the size of the specific hop

In the previous section, we discussed how to create a partitioned table directly and how to convert a normal table into a partitioned table. So what's the difference between these two ways of creating a table? Now, I've created two more tables in a

The role of replay trackingYou can use a trace as a test tool, and when you call some stored procedures in the correct order, you will be able to regenerate specific failures.Tracking templatesThere are four options for saving a trace (file-to-Save

The Java Connection database method is broadly divided into two types: forward connection and reverse connection. The reverse connection requires the compiler to provide the relevant plug-in to support the current mainstream Java IDE supports the

Usually we do the association, generally are a table, not too concerned about such a complicated way of writing, then today we look at these writingFor these three kinds of things to say, let's talk about the main points: on the following conditions

Forgot a detail in the previous article. What does Range t-k really mean? Range T-k Lock represents a class of lock patterns (avoiding phantom reads) that are used in the SERIALIZABLE isolation level to protect data within the scope from being

Requirements DescriptionIn a production environment, it is often necessary to collect data to locate a problem or to form a baseline.There are many ways to solve the data acquisition in SQL Server, such as trace, Profile, SQLdiag, extended events

SQL Server blocked access to the process ' dbo.sp_set_sqlagent_properties ' of component ' Agent XPs ' because this component was shut down as part of this server's security configuration. System administrators can enable ' Agent XPs ' by using