SQL Server

1: In SQL statements, there are two classes of temporary tables, local (local) and global temporary tables, local temporary tables are only visible in their sessions (transactions), and global temporary tables can be used by any program in the

Sqlserver2005 occurs when a subscription is copied:　　"Microsoft SQL Server cannot access these components because replication components are not installed on this instance of SQL Server, see SQL Servers ..."Workaround: 　　 Due to the need to

Original: SQL Server DBA work detailsIn a Microsoft SQL Server 2008 system, the database administrator, or DBA, is the most important role in the administration. The DBA's goal is to ensure that the Microsoft SQL Server 2008 system runs properly and

Original: SQL Server 2012 alwayson--Specifies a data synchronization link to eliminate commit latency issues caused by network jitterEvent Cause: Recent research and development reaction, a database from 08 to 12 environment, the occurrence of write

Comparison of several scenarios for high availability in SQL Server 2012, where AlwaysOn advantage is compared to several scenarios for SQL Server 2012 high availability and disaster recovery, replication, clustering, mirroring, what are the

Installing the sqlsrv ExtensionFirst SQL Server 2014 installation does not say what the link information set itselfPHP Version: 5.5.12Sqlsrv Drive Microsoft offers 3.0 and 3.1 version 3.0 corresponding to PHP 5.4 3.1 corresponding to 5.5PS:WIN7

Recently often see the word "parameter sniffing", read a few articles, so I try to do a test to deepen the impression! Go to the official website to download the database: AdventureWorks2012 Direct Test it! Find a few familiar tables to associate

ObjectiveIn the previous articles, we introduced a series of basic descriptions of operators and the optimization methods and techniques for each operator. This includes a series of our common operators, including how to view execution plans, how

The original SQL Server database of the system was converted to a MySQL database because of the need for work, so it has been consulted for two days. At first, I tried to export the SQL file from SQL Server and then import it into the MySQL database,

SQL Server Profiler-performance tuningPerformance has enough reason to become a hot topic. Today's business is fiercely competitive, and if users think that an application is too slow, they will immediately turn to another vendor. To meet the user's

DateTime field type corresponds to a time format of yyyy-mm-dd HH:mm:ss.fff , 3 F, accurate to 1 ms (MS), example -- £ º15.433 .The DateTime2 field type corresponds to a time format of yyyy-mm-dd HH:mm:ss.fffffff , 7 F, accurate to 0.1

This article is the second in a series of articles in case you haven't read the first article. The previous article address is as follows:On transaction log in SQL Server (i)----the physical and logical architecture of transaction

1. Query all database names in the database:SELECT Name from Master. sysdatabases ORDER by Name2. Query all the table names in a database:SELECT name from SysObjects Where xtype= ' U ' ORDER by Name3. Query table structure information: 1 SELECT

Today I would like to talk about a special topic in SQL Server--Instant file initialization (Instant initialization). For your instance of SQL Server, if you enable Instant file initialization, you will get a huge performance boost under certain

Procedures for all types of replication Process Description Sp_addscriptexec Publishes a Microsoft SQL Server script (. sql file) to all subscribers to the publication.

This article is the sixth of the SQL Server Agent series, please refer to the original text for more information. As mentioned in the previous series, SQL Server Agent jobs are composed of a series of job steps, each of which is executed by a

The join table operator operates on two input tables. There are three basic types of joins: Cross joins, Inner joins, and outer joins. The difference between the three types of joins is that they take different logical query processing steps, each

In database operations, there are times when we encounter the need to implement "row-to-column", for example, a table for a weekly income statement for a store: VARCHAR (Ten) DECIMAL)Let's insert some simulation data first:INSERT

In the original: View SQL Server Internal Data page Widget Internals ViewerView widget for SQL Server Internal Data page Internals ViewerIt feels like the internals viewer is a very good name to see inside.This gadget is the one I saw in the garden

SQL to determine whether a string contains numbers and letters. Determine whether a letter is contained select PATINDEX('%[A-Za-z]%', ‘ads23432')=0 (If a letter exists, result> 1) Determines whether a number exists. PATINDEX('%[0-9]%',