SQL Server

SQL Server BackupRecovery modeThe SQL Server Data recovery model is divided into three types: The full recovery model, the bulk-logged recovery model, and the simple recovery model.Full Recovery modelThe default recovery model, which fully records

How to find your worst-performing SQL Server queryI've often been asked this question repeatedly: "I have a poorly performing SQL Server." How do I find the worst performance query? “。 So in today's article there are some information and wizards

IndexWhat is an index?An index is a data structure on a disk that is based on a table or view. Using an index can make data acquisition faster and higher in universities, and also affect some other performance, such as inserting or updating.There

I'm a lazy man, I just want to do as little as possible. I don't want to be too much when I'm working. Yes, you're right, it looks bad, and as a DBA it's not qualified. But in today's article, I want to show you how you can communicate your work and

First, SQL Backup of the database :1. Open Start menu → program →microsoft SQL Server 2008→SQL server Management studio→ database: dsideal_school_db is the database of students we need to back upFigure (1)2, select the database to be backed up

First, preface:As a fresh graduate and ready to interview the net Siege Lion, before in the library that this book is very basic, this time to go home to buy their own to review, by the way to do reading notes.Second, the code download:Official:

Simple IntroductionIn SQL Server, data is stored on a per-page basis. When you add a clustered index to a table, SQL Server looks for the data according to the clustered index column as keyword.Therefore, the impact on the performance of the

SQL Server comes with a mail-sending feature that makes it easy to send information from a database to relevant people. If the warning information can be sent to the management personnel in conjunction with the monitoring event, the report can be

Original address: http://blog.sina.com.cn/s/blog_95cfa64601018obo.html1. SELECT convert(varchar, getdate(), 100) -- mon dd yyyy hh:mmAM (or PM)  -- Oct 2 2008 11:01AM SELECT convert(varchar, getdate(), 101) -- mm/dd/yyyy - 10/02/2008 SELECT

problem: when modifying the database table, can not choose to save, prompt: Saving changes is not permitted, such as 1, if you choose Cancle, will be revoked save, if you choose Save Text file, will save a txt files, But not SQL script, personally

The following shows how to implement MySQL data table update real-time trigger SQL Server inside the corresponding table to add and delete operations, first, increase the original MySQL table trigger, including the following three:Inserting data:

When it comes to Columnstore index, we have to mention the compression technology of SQL Server. Columnstore is the use of SQL Server compression technology. Columnstore is divided into two different compression types, Columnstore and

I. Non-clustered index maintenanceThe row locator value for a nonclustered index keeps the same clustered index value, even after the clustered index column is physically relocated.To optimize this maintenance overhead, SQL Server adds a pointer to

Mathematical Functions　　1, Calculate absolute value ABSThe ABS function calculates an absolute value (except for the bit data type) for a numeric expression result, which returns an integer.Syntax structure:ABS (numeric expression)Return value: Data

Many people don't know how SQL statements are executed in SQL Server, and they worry that the SQL statements they write will be misunderstood by SQL Server. Like what: Name=> 10000 and execution: Name='

A table expression is a named query expression that represents a valid relational table. You can use a table expression in a data-processing statement just like any other table. SQL Server supports 4 types of table expressions: Derived tables

The SET function is primarily intended to show the SQL execution query plan, CPU, and hard disk usage. 1. Set STATISTICS time on: When SET STATISTICS Times is on, the temporal statistics of the statement are displayed. When OFF, time statistics

in SQL Server built-in stored procedures, If a parameter is required to handle a mutable collectionThe original stored procedure, @objectIds as a variable parameter, such as 110,98,99ALTER PROC [dbo]. [Proc_totalscore]@categoryKey int,@objectIds

SQL Server database field type descriptionThere are currently x field types in SQL Server database, broadly divided into 9 categories, namely string type, binary character string data type, Unincode string data, integer type, exact data type,

SQL Server uses table values as input parameter examples in stored procedures. If we want to pass the table as an input parameter to the SQL Server Stored Procedure before 2008, we may need a lot of logic processing to pass the table data as a