SQL Server

I. Base and management of the database:Persistence Technology: Memory--FILE----database (most commonly used, popular)1. Database:1. Store massive data (P) Big data, cloud computing2. Security3. Easy to manage and operate (DDL,DML.TCL ...)4. Sharing

Today re-installed the system, but the computer name changed, and then changed the computer name, and then installed the Sqlsever, after the installation is completed, and found that no matter the Windows identity or SQL Server identity can not log

In the same network environment, or under an IP address that can be accessed, we can use the SQL database for remote connection access using the following methods:Create an access connection by calling Master.sys.sp_addlinkedserverEXEC master.sys.sp_

LocalDB (SQLLOCALDB)LocalDB is a lightweight version of Express, which has all the programmability features, but runs in user mode and features a fast 0 configuration installation and fewer prerequisites required. You can use this version if you

GUID (Global unique identifier) Globally unique identifier, which is a 16-byte binary value generated by the identity number on the network card (each network card has a unique identification number) and the unique number of the CPU clock.The format

--Paging data----row_number () is called window-opening function, can be paged operationSelect Row_number () over (order by ID) as Num,*from gb_data----adds a sequential num value to each column to facilitate the use of the first few data.Select row_

When you add a System DSN SQL Server Native Client 11.0 to the test database, you are prompted with the following error:--------------------------Microsoft SQL Server Logon---------------------------Connection failed:SQLState: ' 08001 'SQL Server

Sometimes you need to reserve a specified number of digits for a specific number that contains a decimal point, such as "123.123600".This is implemented as a function in the database as follows: Use [Database name]GO/** * * *

Reprinted from work partner Garrett, Helen "SQL Server performance Counter captures"Capturing Windows performance Counters for SQL serversql Server performance CountersThe following counters is the recommended list to capture baseline performance

You installed the new SQL Server with the Installation Wizard, and finally you clicked the Finish button. Wow Oh ~ ~ ~ Now we can put our server into production! Sorry, that's not true, because your new SQL Server default configuration is wrong.Yes,

Because the Web server was previously deployed under IIS a few sites, and now this project development is PHP, originally Php+mysql+iis should be very simple to search out the internet a lot, but, because the previous web site is used by SQL Server

In a real-world operation, in SQL SERVER 2008, a new user has been created to access several tables that have been made by another user, but cannot be queried, prompting the object name ' Customentry ' to be invalid. ”。 When the schema name is

This article was reproduced from the blog of Birch Tsaihttp://www.cnblogs.com/lyhabc/archive/2013/07/16/3194220.html explain SQL Server transaction log recordsAs you know, under the full recovery model, SQL Server records the operations that are

1. The time format for the DateTime field type is yyyy-mm-dd HH:mm:ss.fff , 3 F, which has a time precision of 1/300 seconds, which is rounded to round to. 000,. 003, or. 007-second increments when used, with an example -All: 15.007 .2, the

SQL Server user-defined Function usage, sqlserverfunction I. FUNCTION:In sqlserver2008, there are 3 custom functions: scalar functions, inline table valued functions, and multi-statement table valued functions. First, summarize the similarities and

Correct use and space occupation of NULL in SQL Server, servernull We often encounter NULL in the use or maintenance of SQL Server. What is NULL? The following is a brief description provided by MSDN (see "Null Values "): A value of NULL

SQL server proxy job execution SSIS package failure solution, sqlssis RT, the execution failed, always prompts "failed to execute as xxxx user", it is difficult to find the reason. Reference http://bbs.csdn.net/topics/300059148 Sql2005 how to run

SQL Server trigger instance details, SQL trigger Microsoft SQL Server™2000 provides two main mechanisms to force business rules and data integrity: Constraints and triggers. A trigger is a special type of stored procedure, which is different from

Method 1:When configuring data synchronization, the databases of the two synchronized machines must be connected by the default instance name. If your default instance has been deleted, you will be prompted when you create and release the

SQL server deadlock 1:A user A accesses table A (locking table A) and then accesses Table BAnother user B accesses Table B (Table B is locked) and then attempts to access TableAt this time, user A has locked Table B because user B has to wait for