best sql server books

Original: SQL Server 2012:SQL Server architecture--The life cycle of a query (part 2nd)Planning cache (Plan caches)If SQL Server has found a good way to execute a piece of code, it should be reused as a subsequent request because

SQL Server automatic backup, automatic compression, automatic deletion of old backup, SQL Server backup Compression Preparation tools:SqlServer2008WinRar 1. Set a scheduled backup for SqlServerThis operation is relatively simple. Simply add a maintenance plan according to the wizard. 2. Automatic compression of script

Registered servers window: You can use SSMs to register multiple servers and connect them, so that DBA can manage multiple local or remote servers in one environment. The registered servers window is invisible by default. to display it, click the View menu to select the registered servers option, or press the shortcut key CTRL + ALT + G. Right-click any location in the registered servers window, open the context menu, register a new server throu

2013-09-2009:46:12 2013-09-20 09:46:12 -! SQLServer error: 229, EXECUTE permission denied on object 'SP _ sqlagent_has_server_access ', database 'mdb', owner 'dbo'. (ConnIsLoginSysAdmin) 09:46:12 -! SQLServer error: 229, EXECUTE permission denied on 2013-09-20 09:46:12 -! SQLServer error: 229, EXECUTE permission denied on object 'SP _ sqlagent_has_server_access ', database 'mdb', owner 'dbo'. (ConnIsLoginSysAdmin) 09:46:12 -! SQLServer error: 229, EXECUTE permission denied on object 'SP _ sql

As SQL Server 2008 gets more and more into the spotlight, there's a growing number of voices saying that SQL Server 2008 (Kaitmai) is just a patch pack for SQL Server 2005. That's what I thought, too, because we put too much atten

Tags: cluster SQL Server cluster Windows Server 2012It is necessary to note that the SQL Server failover cluster (SQL Server Failover Cluster) We build is an availability cluster, not a

Today in order to experience the new SQL Server 2005 features, the heart of the local SQL Server 2000 killed, installed a SQL Server 2005, experience a lot of new features, then suddenly think of some of the DTS improvement work i

In the previous chapter, we have introduced how to create an SQL azure database. This chapter describes how to use SQL Server Management Studio (SSMs) to connect to and manage SQL azure databases. Install SQL Server manage studio

SQL Server 6.5 litre SQL SERVER 2000 Prerequisites: I. SQL Server 6.5 is generally installed on Windows NT 4.0 and requires NT to reach SP4 It is better to hit at least sp4 and SP5 in

Common Data Types in SQL Server: SQL Server Data Types To http://www.cnblogs.com/andy_tigger/archive/2011/08/21/2147745.html Bit integerThe bit data type is an integer, and its value can only be 0, 1, or null. This data type is used to store data with only two possible values, such as Yes, No, True, False, On, or Off.

SQL Server concurrent processing, update solution discussion, SQL Server Preface In this section, we will talk about the most common situation of concurrency, that is, update. If no row record exists in concurrency, insert it. At this time, it is very easy to insert duplicate keys, this article describes the seven solu

SQL Server row-to-column parsing, SQL Server For more information, see the code: /* SELECT The above is all the content of this article. I hope this article will help you in your study or work. I also hope to provide more support to the customer's home!

SQL Server enables or disables auto-growth, SQL Server When adding a row to a database table, you need to insert a specific value for the auto-increment column. This function is very useful. For example, the table structure is as follows: Id | text 1 | 2 | B 4 | d The id column is a self-contained column. If we w

Example of recursive calling of stored procedures in SQL Server: SQL Server Stored Procedure Recursion refers to the situation where a code snippet calls itself. The danger lies in how to prevent it from repeatedly calling itself if it calls itself once. That is to say, recursive tests are provided to ensure that exce

SQL Server date function, SQL Server date Current System Date and Time Select getdate () 14:52:27. 123Extract data from date Day (), month (), year () Select getdate ();-14:52:27. 123Select YEAR (getdate ();-2015Select MONTH (getdate ();-6Select day (getdate ();-18 Date Format ConversionCONVERT Select convert (

Common SQL Server statements and SQL Server statements Select * into A -- automatically generate Table A. The structure data of Table A is the same as that of Table B.From BInsert into A -- A must be created in advanceSelect * from B Insert into A (Field 1, Field 2 ,...) Values (Value 1, value 2 ,...) Inse

SQL Server loop statement insert, SQL Server loop statement There is a table tt Description: Q (PK, int, not null) w (nchar (10), not null) e (int, not null) r (int, not null) t (int, not null) y (int, not null) u (int, not null) I (int, not null) o (int, not null) p (int, not null) The circular insert statement