SQL Server

In the use of SQL, we occasionally encounter a situation, that is, the need to change the form of data storage, such as a database of a table (Info) has a field educational (education), previously stored in the JSON array, now because of changes in

SQL 2008 log Files account for 23G of hard disk space, and the transaction log has been truncated (Truncate), the actual log content is small, 1G is not, want to release the extra space occupied by the log files. However, no matter how you shrink

In this article, I'll explain a lot about inserting data in SQL Server in the future. To create a database and table to test, the primary key in the table is a GUID, and no indexes are created in the table in order for the data to be inserted

This morning turned on discovery, open SQL Server 2008 SQL Server Management Studio, enter the sa password found, unable to log into the database? Prompts for the following error: "A network-related or instance-specific error occurred while

In development and enterprise applications, several versions of SQL Server are linked to each other. Distributed reading and storage, we need to implement sp_addlinkedserver. SQL Server, SQL Server 2008, SQL Server 2012 and SQL Server 2014: But

Today, my classmate asked me a question, I think it is very interesting, now recorded down to discuss. The problem is: in a table, there is a field that is allowed to be empty, and null can be repeated, but a value that is not NULL needs to be

server| Speed | optimization MS SQL Server Query optimization method (1) There are many reasons for the slow query speed, common as follows: 1, no index or no index (this is the most common problem of query slow, is the defect of program design)2, I/

The monitoring of database servers can be broadly divided into two categories:(1) Status monitoring: Is the database server running in a healthy way?(2) Performance monitoring: Healthy operation at the same time, there is no performance problems?

SQL Server generally refers to the Microsoft SQL Server relational database management systemMicrosoft SQL Server is a comprehensive database platform that provides enterprise-class data management with integrated Business Intelligence (BI)

After careful study, it is still a bit complicated to find the explicit transaction (display transaction) inside SQL Server. Here are some summaries:Commit TRANSACTION commits all nested transaction modifications. However, if the nested transaction

When the beta version of the project is synchronized (deployed) to the official version, the structure of the two databases compared with the synchronization, if the database is not modified when modifying those tables, it is difficult to

In the database server, memory is one of the most important resources for the database to provide services to the outside,Not just SQL Server, including other databases, such as Oracle,mysql, is a kind of memory-like application.In a SQL Server

Turn http://www.cnblogs.com/YZDONET/archive/2012/08/17/2644711.htmlOverviewLast week, Tim shared with us the management configuration of SQL Server 2008 Reporting Services and how to create reports. SQL Server2008 Reporting Service is a complete

I created the Inner JOIN 9 table, which takes a long time (more than five minutes) anyway. So, my folk song changed inner join to the left join the left join performance is better, for the first time despite what I know. Then I changed, and the

SQL Server theoretically has 32,767 logical connections, and SQL Server is self-leveling the connection pool based on the system.First, the number of users of the operating system: that is, at the same time through the network connected to the

When we do some application sites, we may encounter a situation where the whole project is composed of multiple sites, and we want to implement a user login from one site, jump to other sites do not need to repeat the login, that is, to achieve

The SQL Server database has three file types, data files, secondary data files, and log files, where the log files contain all the log information used to recover the database, SQL Server always writes the log file LDF first, and data changes are

In the Access Project (that is, the. ADP file) linked to an SQL Server database, the access function that you frequently use is usually not supported. But most of the time, you can use a Transact-SQL (T-SQL) function supported by SQL Server. One

I recently conducted a small integration application test, which is suitable for users who do not want to view the relevant reports on the website but want to view the reports by email at regular intervals.Relatively static reports(No user

DSS workload During the test, the DSS workload includes 22 query statements of the report type consisting of complex select statements. These queries are strictly run on the server in batches. All queries contain one or moreFor multi-table join,