SQL Server

The author has been involved in the development of a set of highway toll system, the main function is to record all the vehicles through the toll station information, including time, model, amount, vehicle picture information, which involves the

Move data or log files 1. Run the following statement. ALTER DATABASE database_name SET OFFLINE; 2. Move the file to a new location 3. For each file you have moved, run the following statement ALTER DATABASE database_name MODIFY FILE (name =

Accidentally update forget to add conditions, simple limit! Trigger for DML frequent operation of poor performance, pay attention to their actual situation! Create Trigger Tr_tbltime On Tbltime For Update,delete As If Original_login (' Wind ',

Memory-related concepts The following are for Windows 32-bit system environments where 64-bit is not described below. User mode and kernel mode (username mode& kernel mode) To prevent user programs from accessing and tampering with critical parts

Script File Download: Http://files.cnblogs.com/lyhabc/instnwnd.rar We open the properties of the Blogtest extended event session created in the previous article Check the predicate of the Sql_statement_starting event and the

Reliability of the database In the relational database system, we need a reliable database, the so-called reliable is to meet the following two kinds of situations to ensure the consistency of the database: Ensure database consistency in case of

My blog has been a long time no written aspects of the record, somehow yesterday has ended the test of software designers, today how to say also need to exercise their writing ability. Otherwise, I am afraid that I will be like the last year, one

This includes installation prompts for pending operations, shrinking the database, compressing the database, transferring the database to new users for existing user rights, checking backup sets, repairing databases, and so on. (i) Suspend

The common declarations in the connection string are:The server declares Data Source, server, and addr.Database declarations Initial catalog and databases.Security statements for Integrated Windows accounts integrated and Trusted_Connection.Use

Tools,database Maintenance Planner in Enterprise Manager, you can set up a regular automatic backup schedule for the database. and run the backup schedule by starting the SQL Server Agent. The specific steps are as follows: 1, open Enterprise

SELECT Table name =case when a.colorder=1 then D.name else "end, Table Description =case When a.colorder=1 then IsNull (F.value, ' ") Else ' end, Field Ordinal =a.colorder, Field name =a.name, Identify =case when ColumnProperty (A.id,a.name, '

1) First variable and then field SET NOCOUNT on; DECLARE @i int, @j intDECLARE @Table Table(Id1 INT,Id2 INT); INSERT @Table (ID1, ID2)SELECT 1, 10UNION AllSELECT 2, 20UNION AllSELECT 3, 30; SELECT @i = 1, @j = 0UPDATE @Table SET Id1 = @i, Id2 =

As we know, the SQL Server transaction log is used primarily to record changes made to the database by all transactions, and if the system fails, it becomes the only source of the latest data. Log operations often have the following applications:

This example is the opposite of the one above example. SQL 1 DECLARE @CWB_NO varchar (50)Set @cwb_no = ' 31301379874 'SELECT A.awb_no,A.bwb_no,A.cwb_no,A.origin,A.dest,A.MODIFY_ON,A.CREATED_ON,A.consignor_customer_code,A.consignor_code,A.consignor_

Sorting hundreds of billions of tables or a join between billions of tables can cause the system to lose its response. 1. I did make a large query that involved a data table with 200 million records, and a group by operation, resulting in large CPU,

This article uses the following techniques: SQL Server This article describes the following: SSDS Data Model Managing entities, containers, and authorities To create a sample WEB application Class serialization and deserialization This column

This article through a detailed analysis of an example to explain the use of seek, scan and other operations and effects, for your reference! Getting Started Guide Let's use a simple example to help you understand how to read a query plan by

There are too many front-end applications with efficient, continuous database support, except SharePoint 2013, since the SQL Server always on mode has been available. From the initial unsupported, to the upgrade to SharePoint Server after SP1

Aliases must be used in SQL queries. When do I need to use the table alias in SQL queries? I encountered the problem of using the table alias when I wrote MySQL today. I 'd like to repeat it here. 1. The table name is very long. Select * from

Installation tutorial of SQL Server vNext CTP 7.3 on CentOS 1.2, SQL Server vNext CTP 1.2 installation Tutorial: This installation process refer to Microsoft official installation documentation: https://docs.microsoft.com/zh-tw/ SQL