SQL Server

One, authentication:There are two types of SQL Server database connection authentication: Windows authentication and SQL Server AuthenticationWindows authentication: A user connection is validated using the security subsystem of Windows. (personally

Window under Jira+sql Server deployment + Chinese + hack (pro-test 2018.5)Many of the Internet is jira+mysql deployment of articles, because I now have the need to use SQL Server database, so I try to do a bit, referring to many articles on the

In the. NET world, if you want to operate a database, there is no need for ADO. The familiar libraries and APIs are also inseparable from the. NET core. Here's a brief description of how SQL Server is handled differently by

1. The company has more than one virtual machine, because the company provides the machine hard disk is always not big enough ... So I thought of the way to use a mapped network drive for backup recovery work.The main ways to learn are as follows:0.

The problems encountered today are more interesting. First of all, the test database has not been opened for a long time, open today, using the service program testing, the following error message

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

from:http://blog.csdn.net/tjvictor/article/details/4370771XML indexes in SQL Server fall into two categories: primary XML indexes and secondary XML indexes. The secondary XML index is divided into: PATH secondary XML index, VALUE Secondary XML index,

Original: SQL Server could not set the Publisher login for updatable subscriptions sp_link_publicationNo:Create an updatable subscription, create the publication normally, create a subscription at the Subscriber, and the last prompt completes with a

The database used by the customer is older, SQL Server 2008, and two SQL files are exported.With the help of OPS, SQL Server 2008 is installed and configured in the WIN10 system.Open the first file, no problem, build the appropriate database, run

Cause: In most cases, you modified the login password for the server system, which caused the SQL service to fail to start.WORKAROUND: Change the login password of the SQL Server (MSSQL Server) service to the system login password or log on locally

SQL Server Remote Login Server Management and query /* Data operations between databases on different servers */-- create a link to the server exec sp_add+server 'itsv', '', 'sqloledb ', 'remote server name or IP address 'exec

SQL Server does not allow remote connection.◆ 1. The database engine is not started. There are two startup methods: (1) Start-> Program-> Microsoft SQL Server 2005-> SQL Server 2005 peripheral application configurator. On the displayed page, click

 1. Concurrency consistency Common concurrency consistency problems include: Lost modifications, non-repeated reads, dirty reads, and Phantom reads (Phantom reads are often classified as non-repeated reads in some materials ).1.1 lost

SQL Server database, how to add s lock or X lock to data items I. Why should I introduce locks? When multiple users perform concurrent operations on the database, the following data inconsistency occurs: Update lossA and B read and modify the same

Description of Identity Authentication in SQL ServerTime: | read: 228   Microsoft SQL Server can work in one of two security (authentication) modes: Windows Authentication Mode (Windows Authentication)Windows Authentication mode allows you to

10. Create a database data tableDeployment of basic workBasic concepts of data tablesCreate a data table in the archive GroupUse nullAdd the identity attributeCreate a data table using Enterprise ManagerSummaryWhen the database is created (The

 SQL Server Performance Tuning entry (graphic version) Step 1: capture sample data during business peaks(About 2 hours ). The tool used is the profiler that comes with sqlserver, also known as the event probe. For example, after entering, click the

In the previous experiment, I tried to use the connection server and ad hoc query to import the data in Excel to the database in SQL server2005. But as the saying goes, the plan cannot keep up with the change. No, the change is coming. In further

There are many reasons for slow query speed. The following are common causes: 1. No index or no index is used (this is the most common problem of slow query and is a defect in programming) 2. Low I/O throughput, resulting in a bottleneck effect. 3.

SQL server lock mechanism (I)-Overview (lock types and ranges) SQL SERVER lock mechanism (II)-Overview (Lock compatibility and lockable resources)   This article introduces the locking mechanism of SQL SERVER (iii) -- Overview (lock and transaction