SQL Server

3. Configuration steps:Primary Server (A-machine) settings(1) Enable log Shipping ConfigurationRight-click the database for which you want to configure log transport->tasks-> ship Transaction logs...->enable this as a primary database in a log

1. OverviewLOG Shipping The database backup process provided for SQL Server. It can replicate the entire database to another server. In this case, the transaction log is also periodically sent to the backup server for data recovery purposes, which

Temporary tables, table variables, and CTE are commonly used in SQL Server to store temporary table data, and here is a brief introduction to the different and different scenarios in which they are used.CteA CTE is often called a "generic expression"

Please count every 10 minutes for the time period starting from 7 o'clock in the morning every day.Solution Ideas:I have done a month before, that is, every 3 months in groups, in fact, is the same. But maybe, the overall data volume is a problem

Classification:Windows Authentication mode and Mixed modePlatform:WindowsProperties:Authentication ModeThe differences between these two types of authentication modes are:(1) Windows authentication ModeOnly Windows authentication is performed. The

First, build the development environmentThe development environment in this example consists of Eclipse3.2 and MyEclipse, and the following is a simple introduction to the various frameworks and JDBC driver packages that are required in system

Original: SQL Server replication distributes large transactions into small transactionsIn 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

Https://www.cnblogs.com/srsrd/p/6962982.htmlMethod One:Method Two:Use the following statement to find out what statements account for the highest memory and optimize for statements that account for high memorySELECT SS. Sum_execution_count,T.text,Ss.

Original: SQL Server initializes the subscription with a backupWhen you create a transactional replication, if the publication database is large, the snapshot initialization is used for a long time, and if a problem occurs, it may be reinitialized.

Server name. database name. Table Owner (schema name). Table NameServer name (server IP). database name. Table owner. Table name[192.168.99.66]. TEST.dbo.table1[Testdb]. TEST.dbo.table1A:server NameB:database NameC:user NameD:table NameSELECT * FROM

The function passes in a string and returns the data: if it is a kanji character, the first letter of the character is returned, and if it is a non-kanji character, it returns itself.Second, the use of the knowledge Point: The Chinese character

Detaching a database means separating the database from the SQL Server instance, but not deleting the database's file and transaction log files, so that the database can be attached to other instancesUnable to detach the state of the database:1. The

Classification of stored procedures(1) System stored procedureThe name of the system stored procedure usually begins with "sp_"Created, managed, and used by SQL Serverstored in the resource databaseMethods similar to those in the Java language class

(1) The master database is the most important database for the SQL Server system, and it records all system information for the SQL Server system. These system information includes all login information, system setup information, SQL Server

Use over () to calculate the statistics and then filter the result set directlyDECLARE @t table (ProductID int,ProductName varchar (20),ProductType varchar (20),Price int)--Test dataInsert @tSelect 1, ' name1 ', ' P1 ', 3 UNION ALLSelect 2, ' name2 '

SQL Server Failover +alwayson Add database to availability GroupThe configuration of SQL Server Failover +alwayson has been described in detail in the previous articles, and today we mainly introduce the addition of databases to availability groups

The T-SQL statement that deletes the table is:DROP table Drop is discarded, and drop table means that a table is completely erased.There are two ways to delete table data: Delete and truncate.The use of delete is as follows:Delete from [Where

After SQL Server is installed, the server is renamed, causing the names to be inconsistent, using the following methods:This action also applies to modifying the server name.1, query the current server's old server name:SELECT @@servername AS 旧服务器名2,

The software was originally using ADO to access LocalDB, now switched to open source ODBC C + + package Nanodbc,Everything else is ok after debugging, but although the backup DATABASE command returns successfully, the actual backups are unsuccessful.

sp_executesql Introduction and use of Execute I believe everyone uses the cooked, abbreviated to exec, except for the execution of stored procedures, is generally used to perform dynamic SQLThe new system stored procedures introduced in