SQL Server

(1) The jobs in the MS SQL Agent are saved in the msdb database, and the job list can be queried by the following SQL statementselect * from msdb.dbo.sysjobs(2) MS SQL Agent job history is also saved in the msdb database, and the job history list

How to improve the speed of backup?In fact, this problem and how to make the system run faster is the same, to want the system to run faster, nothing else is: optimize the system, or even better and more powerful servers, especially more CPU, larger

Transferred from: http://www.cnblogs.com/micheng11/archive/2008/07/08/1237905.htmlThere are two ways to assign values to variables that are already defined in SQL Server, SET and SELECT, respectively.The differences between these two approaches are

Original link: http://www.cnblogs.com/fygh/p/3288701.htmlFrom the initial release of SQL Server DBA Eve asked for more than a year, you have some of the issues discussed more intense, to answer these questions need more solid SQL ServerBasic and

SQL2008 's Shrink logBecause SQL2008 is optimized for file and log management, the following statements can be run in SQL2005 but have been canceled in SQL2008:(SQL2005)Backuplog Dnname with No_logGoDumptransaction Dnname with No_logGoUse DnnameDBCC

Toss SQL SERVER 2012, get a morning to modify the database name, mainly need to modify the name of Db.mdf and Db_log.ldf, finally solved. Write it down here, and change it later, and don't forget it.Assuming the original database name is DB, the

https://www.cnblogs.com/dengshaojun/p/3955826.html SQL Server processing of concurrency-optimistic and pessimistic locksIf two threads modify the same record in the database at the same time, it causes the latter record to overwrite the previous one,

--method 0: Dynamic SQL method declare @s varchar ( -), @sql varchar ( +)Set@s='1,2,3,4,5,6,7,8,9,10'Set@sql ='Select Col=" "+ Replace (@s,','," "UNION ALL Select" ")+" '"PRINT @sqlexec (@sql)--Method 1: Cyclic interception methodifExists (Select*

Original: SQL Server 2016 row-level permission controlBackgroundIf we have key data stored in a table, such as the staff table contains employee, department and salary information. Only allow users to access information from their respective

/*Chinese Pinyin First letter*/Create function fun_getpy (@str nvarchar (4000))Returns nvarchar (4000)AsBeginDECLARE @word nchar (1), @PY nvarchar (4000)Set @PY = ' 'While Len (@str) >0BeginSet @word =left (@str, 1)--If non-kanji characters, return

1. SQL Server information collectionSQLDIAGUsing the interfaceC:\users\administrator>sqldiag2018/01/02 08:13:26.10 SQLDIAG Collector version2018/01/02 08:13:28.19 SQLDIAGIMPORTANT: Please wait until ' see ' Collection started ' before attempting

ObjectiveIn the last two articles, we describe how to view the query plan, and some of the common optimization techniques for join operators, and we summarize how the federated operators are used and how to optimize them.Talk less and go straight to

A recent deployment of a system, in the data security considerations, so the corresponding database server scheduled backup, and data synchronization to the backup service. Before in another project also did the corresponding operation, but the

This is the third article from 0 to build SQL Server AlwaysOn, this article really started to build AlwaysOn, the first two is to build AlwaysOn to prepareOperation Steps:1. Install SQL server2012 ( Note: Be sure to install. NET fromwork 3.5 and log

SQLthe licensing approach is somewhat complex and is explained below:1. version: Standard Version and Enterprise Edition, software features are not different, but the standard version has the following limitations :a) memory Max 64Gb) 4

1. Talk about the difference between clustered index, nonclustered index, hash index and their merits and demerits, include covering index's function, relative to the advantage of composite index;2. What is the structure of the log file, what is the

SQL Server Introduction Order: First level, Introduction to Indexesby David Durant, 2014/11/05 (first PUBLISHED:2011/02/17)Original address:Stairway to SQL Server Indexes:level 1, Introduction to IndexesThis article is part of the SQL Server cable

Take all months:DECLARE @begin datetime, @end datetime set @begin = ' 2015-2-6 ' Set @end = ' 2015-12-2 ' declare @months int set @months =datediff ( Month, @begin, @end) Select CONVERT (varchar (7), DATEADD (Month,number, @begin), as month from

First, the definitionChar: fixed length, storing ANSI characters, insufficient complement English half-width space.NCHAR: fixed length, storing Unicode characters, insufficient complement to English half-width spaceVARCHAR: variable length, storing

Due to the requirements of the data Warehouse and data mining courses and the integration of many data analysis tools in the SQL Server database, there are many advantages to the Data Warehouse deployment, OTAP data analysis and so on. Simply write