SQL Server

What is a sort rule (collation) About SQL Server collation, it is estimated that everyone is not unfamiliar, when creating a database we often have to choose a collation (conllation), generally we will notice that there are many kinds of rules for

Date and time functions in SQL Server 1. Current system date, time Select GETDATE () 2. DateAdd returns a new datetime value on the basis of adding a period of time to the specified date For example: Add 2 days to date Select DATEADD (day,2, ' 20

Server Maintenance plans that are automatically performed on a regular basis: Rebuilds the index with the new fill (duty) factor to reorganize the data on the data and index pages. This ensures that database pages contain equally distributed data

SQL Server stored procedures can be Transact-SQL (T-SQL) statements, or. NET Framework's common language runtime (CLR), which is designed to facilitate database queries. They accept input parameters, return output parameters, can be executed in the

As SQL Server DBA, we often complain that Microsoft's own tools are not good, but can be used to open the box is very rare. The following three separate GUI tools are included in SQL Server 2012 for use by SQL Server DBAs and developers. 1. SQL

SQL Server Edition Enterprise Edition Thunderbolt Version numbercn_sql_server_2012_enterprise_edition_x86_x64_dvd_813295Serial numberMICROSOFT SQL SERVER ENTERPRISE COREFh666-y346v-7xfq3-v69jm-rhw28MICROSOFT SQL SERVER Business

Original: Chapter 1 securing Your Server and Network (1): Select SQL Server Run accountSource: http://blog.csdn.net/dba_huangzj/article/details/37924127, Special catalogue: http://blog.csdn.net/dba_huangzj/article/ details/37906349No person shall,

Usage of ROWCOUNT:The function of rowcount is to restrict the subsequent SQL to stop processing after returning the specified number of rows, such as the following example,SET ROWCOUNT 10SELECT * FROM Table ASuch a query will only return the first 10

Problem:The server was stopped directly, after restarting, found SQLSERVER2008R2 Boot Manager error:"Unable to read a list of previously registered servers on this system"Click Continue, enter after:Workaround :Click the error message panel, confirm,

Normal spacesBefore and after spaces, use LTrim and RTrim, for example: LTrim (RTrim (Name))Middle space, replace with replace function, for example: replace (Name, ' ', ')If it is an ordinary space, it is easy to replace, but sometimes encounter

Analyze and compare execution time plan reads1. View execution time and CPUSET STATISTICS Time Onselect * from Bus_devhistorydataset statistics time offYou can see it in the message after execution.2. View the operation of the query for I/OSET

IntroductionThe essence of deadlock is a stalemate, which is caused by the contention of multiple subjects for resources. Understanding deadlocks first requires an understanding of the relevant concepts involved in deadlocks.some basic knowledgeA

(ii) SQL statement fuzzy query NULL processing aggregate functionMy own study notes, reproduced please indicate the source, thank you!---sauerkrautSQL: Structured Query Language (structured Query Language), a standard language for relational

SQL Server Query optimization methodThe reasons for the slow query are many, the following are common1, no index or no index (this is the most common problem of slow query, is the defect of program design)2, I/O throughput is small, forming a

New XSQL Schema compare-version 5Compare the schemas of the SQL Server databases, review differences, generate synchronization script and execute It-xsql Schema Compare makes database change management easy.XSQL Schema Compare supports SQL Server, 20

Perspective transformationsPivot data is a process of rotating data from the state of a row into a column state. Each perspective transformation involves grouping, extending, and aggregating three logical processing stages, each of which has related

This article is reproduced articles, the description is very good, has not been verified.I've recently encountered a deadlock problem that seems strange and interesting to analyze. This deadlock seems to be hard to understand. In the analysis

Read Catalogue Objective Technical preparation ObjectiveIn the previous article, we analyzed how the query optimizer works, including: detailed operation steps of the query optimizer, analysis of filter conditions, optimization of

Original: PowerDesigner 16.5 tips for reverse engineering from SQL Server 2012: Unable to List tables issuesShenzhen team to develop a system in the North China side to push customers, in a patch, due to changes in the data dictionary, but the

SQL Server 2016 official version installation and configuration process graphic details, 2016 installation and configuration This article summarizes the installation process of SQL 2016 official edition To Help You Install SQL 2016 smoothly. The