SQL Server

Brief introductionThere are three types of SQL Server custom functions: Scalar functions (scalar function), inline table-valued functions (inline function), multi-statement table-valued functions (multi-statement function)Scalar functions: Scalar

If you are not yet installing a Microsoft SQL Server database that you can connect to, download the last-line installation first. Please refer to the installation for SQL Server Guide on MSDN. Description of the licensing mode ...SQL Server allows 2

1. Environment ConfigurationServer 1:sqlmirror01ip:192.168.10.176Server 2:sqlmirror02ip:192.168.10.177Operating system: Windows R2Install the. Net Framework 3.5/4.0Turn off the server firewall or set up a whitelistDatabase version: SQL Server 20142.

Original: SQL Server high-availability log shippingI. Log shipping OverviewSQL Server uses log shipping, which automatically sends a transaction log backup of the primary server to one or more secondary databases.An optional monitoring server that

1. Adding referencesUsing System.Data;Using System.Data.SqlData;2, established in the database connection, it is recommended to make it a method, convenient multiple use.String SqlConnection = "Data Source =" Note 1 ";d atabase = Annotation 2;uid ="

$database = ' foxdeploy '$server = '. ' $table = ' dbo.powershell_test ' ImportForEach-object {invoke-Sqlcmd ' $ Database$server ' "insert INTO $table VALUES (' $ ($_. COLUMN1) ', ' $ ($_. COLUMN2)" }Reference:

At some point, more than one tempdb file has been created, and the server core number has been exceeded, and the tempdb file is deleted so that it remains the same as the number of CPU cores. However, when the deletion, found unable to delete,

Add Network card Heartbeat lineTarget: Two SQL Servers need to add network card heartbeat line for SQL Server internal data transfer Computer name IP information Heartbeat line Hsr1 192.

Double-click the download good Sqlfull_x86_chs.exe file, and mouse click OK to releaseExtract complete, click OK button;Then find the setup.exein the extracted file and double-click to run;If your computer does not have the. NET framework installed,

1. The concept of a transactionA thing is a mechanism, a sequence of operations that contains a set of operations commands for a database that either executes entirely or does not execute. So the thing is a set of inseparable things logical unit,

ISNULL (Check_expression, Replacement_value)The check_expression and Replacement_value data types must be the same, and if Check_expression is NULL, Replacement_value is returned if Check_expression is not NULL, the check_expression is

use of SQL Server ProfilerOpen the System main Menu--sqlserver several---performance tools--->>sql server Profiler; you got it? Brother Wait for you, give you a picture of open him, let you see.Then the file--new trace--Displays the Tracking

Brief introductionFor select query statements, in general, in order to make T-SQL code more concise and sustainable, the introduction of additional result sets in one query is decomposed through views, not subqueries, but the view is in the database

Create PROCEDURE [dbo]. [Sptasks_assigned_update] ( @ID uniqueidentifier OUTPUT, @MODIFIED_USER_ID uniqueidentifier = NULL, @ASSIGNED_USER_ID uniqueidentifier = NULL ) as DECLARE @ASSIGNED_USER_NAME NVARCHAR (+);

1. Overview of database FailuresThe data for the SQL Server database cannot be read.2. Fault AnalysisThe SQL Server database file could not be read because the underlying file record was truncated to 0, unable to find the beginning of the document,

1. Install the MySQL ODBC driver on the SQL Server server;Drive: http://dev.mysql.com/downloads/connector/odbc/2. After installation, in the management tool-ODBC data Source-System dsn-Add-Select MYSQL ODBC 5.3 Unicode driver-completeWill jump out

Index, I believe everyone knows that it is adding a directory to the data in the table so that we can quickly retrieve the data we want, but what is this directory? How is SQL Server managed? To understand this, we need to understand the concept of

Most SQL Server tables require an index to increase the speed of data access, and if there is no index, SQL Server will be able to scan every record in the table to find the requested data. Indexes can be divided into clustered and non-clustered

1. SectionA section (extent) is a basic storage unit used to allocate space for tables and indexes. It consists of 8 contiguous 64KB data pages.The main points of the concept of allocating space based on segments rather than actual use of space:

If you receive the following error message, check that the user you are giving confluenceuser has all the required database permissions when you use the localhost connection.Could not successfully test your database:: Server connection failure