SQL Server

Original: Understanding of SQL Server Execution planTo understand the execution plan, you have to understand it, the various nouns. Since I don't know much about it. This article is intended as a write-only, do not understand the understand before

Recently found hanging on the Web server somehow restarted, that server is now primarily the start of the IIS service, SQL SERVER service.Telnet The system response was found to be very slow. A noticeable sense of stagnation, open Task Manager, CPU

The wait state is an important means of isolating SQL Server performance issues, starting at the instance level. You can probably see if SQL Server is in a tight state of resources for some time in the past. It depends on whether you have an

Ø Index1. What is an indexAn index is a list of data in a data table and a corresponding storage location that can be used to increase the speed of finding data in a table or view.2. Index classificationThe indexes in the database are divided into

After installing Vs2013 natively, the SQLSERVER2012 database is installed and the database is not queried during vs developmentWhen you click Refresh, you can't see the native SQL ServerInitially check the firewall settings and find that adding

The database Distribution Agent is no longer enabled because the distribution database is performing a long transaction that reaches the system's scheduled 72 hours, causing the subscription to expire and the following error is indicated:Error

SQL sometimes encountersThe lock request time-out period has been exceeded. (Microsoft SQL Server, error: 1222)This error, after refreshing, right-click on a table or library, found that the table is all disappeared or not query.This is because the

SQL SERVER 2005 used to typically use sp_renamedb stored procedures.EXEC sp_renamedb ' olddb ', ' newdb 'Or: The database is separated first, and then attached can also be renamed.SQL SERVER 2005 also supports the storage country process for

//Note: Here are some of the more frequently used SQL statement syntax to query and use later SQL statements consist of commands, clauses, operators, and statistical functions.I. Order1. Data definition commands:Create: Create a new data table,

1. Installing XAMPP2. Download PHP sqlsrv ExtensionsMicrosoft Drivers 3.2 for PHP for SQL ServerOfficial:http://www.microsoft.com/en-us/download/details.aspx?id=20098After the download is actually a self-extracting file, extracted from each version

In the space review of my 2014, from life, technology, family and other parties to face their own summary analysis, but also give themselves an account. Also want to write a special blog on the 2014 rookie of the Technical Road memoirs, but because

In SQL Server, for example, there are 33 types of data for SQL Server, which are summarized in categories: Exact numbers Unicode string Approximate numbers Binary string Date and time

A lock is a mechanism that prevents a process that is performing an action on an object from conflicting with another that has been performed on that object. That is, if someone else is manipulating an object, you cannot manipulate it on that object.

The transaction is all about atomicity. The concept of atomicity means that some things can be viewed as a unit. From a database perspective, it refers to the smallest combination of one or more statements that should be executed all or none of them.

When you are a DBA, many people will complain to you: "This program data loading and snail, you see the server is not a problem?" "There are many reasons for this problem. May be the application server problems, network problems, program

SQL Server determine whether a table or database exists in theSQL Server determine if the database exists:Law (i):SELECT * from master.dbo.sysdatabases where name= ' database name 'Law (ii):If DB_ID (' database name ') is NotnullDrop Database

1 SELECT DateDiff(YY,'2010-06-1 10:10',GETDATE())--calculate how many years2 SELECT DateDiff(Q,'2011-01-1 10:10',GETDATE())--Calculate how many quarters 3 months a quarter3 SELECT DateDiff(MM,'2011-06-1 10:10',GETDATE())--calculate how many months4

In SQL Server replication, when you perform 1 large transactions in the publication database, such as 100,000 or more data at a time. When the operational data is completed at the publication database, the Log Reader Agent scans the transaction log

I. Concept and classification of indexesThe concept of indexing everyone knows that we also use common clustered indexes, nonclustered indexes in our daily development. However, in addition to these two, SQL Server also provides other indexes, such

If there are uncommitted tasks in the repository, the related table will always be in a deadlock state and will affect other processes (unless used with (NOLOCK) in the enquiry).Because of the isolation of the task, the other session can not simply