Share my study of SQLSERVER since the collection of notes

Share my study of SQLSERVER since the collection of notes


Why share?? Because like a lot of people on the Internet that siege division, turned to sell fruit, sell breakfast, one day I will leave the industry

Because I'm not in a big company work for a very low wage, I hope one day to save enough money to leave the profession, then open a bakery (current ideas / dreams)

Because I know a bakery or can be achieved, compared with other dreams and ideas, the difficulty is not too large

Do a baker, can see each food to make their own bread people smile, you said that happiness is not from here.?

Put what they learned to share out, at least you have made little contribution to the SQLSERVER circle, my purpose is such

If I don't share it, these notes will be forever buried in my impression of "notes" software.

Now I have collected notes including SQLSERVER enterprise platform management practice reading notes 337+71=408

That passion many siege division to a certain age, no research techniques, I also afraid of their own one day without effort on SQLSERVER

These notes are in my bubble MSDN forum, work, QQ group, blog, micro-blog, individual research, recorded in the book

---------------------------------------------------Gorgeous split line----------------------------------------------


Tell a story, this story I read on the Internet, true don't know, but I think it should be really

A Daniel Baidu, engaged in the IT industry for a long time, we all respect him very much, he always carries a mobile hard to carry, it gave him the task is done quickly

When one day eat, a recent graduate of new employees asked him, why do you write the code so quickly, but also very good to complete the task? Expert told him: “ secret in my mobile hard disk.”

Because I have so many years of my code is in mobile hard disk, I done greatly small project very much, I put the key code of these projects are stored and ready

When used only in the mobile hard disk, not looking for on the Internet, and write my own code is to know how to use no intention of spending the time to understand the code

You just graduate entry, the accumulation amount of code is not enough, you need to accumulate more code, after you solve the problem do a job with skill and ease.

One day, the mobile hard disk is gone, and then he said to his wife: we went back home ploughing, and then he would resign together with wife back home

Back to the days of course not in Baidu day good, make the renminbi is not so much and very hard, one day I was back to the mobile hard disk,

Because of his fame, when he returned to the Baidu Baidu quickly re hired him, and then he continued his siege students career

From the above story can be seen, notes and accumulation of the code base is the lifeblood of the programmer

-------------------------------------------Gorgeous split line------------------------------------------------


Because Evernote (impression notes) a powerful search function, my notes are not careful classification, such as some heroes: classified as “ &rdquo, “ database; database security, database index ” “”

“Database replication ”, even without these notes and then sub classification is also not much of a problem, because I am in the impression notes only need input keywords and quickly find what I need the notes

Because Evernote does not support sub categories, so I just keep classification.

Here is Song Daxia's classification of blog Garden, personally feel very good, to pay tribute to Song Daxia

As for me is how to search for a note, you can see me this article: Talk about how I learn SQLSERVER

-------------------------------------------- gorgeous split line away


Because the notes are very much, so I will not be released in the essays, lest brushInformal essay, I will publish the article, and the article title in front withNotesTwo words

I'm going to write the title that, if "SQLSERVER enterprise platform management practice" reading notes written:

Note 1- Xu

Note 2- Xu

Xu means: Mr. Xu Haiyu

If ordinary notes written:

Note 1

Note 2

Because of his collection of notes, and individual work may in some cases not encountered, for example, the configuration of SQLSERVER cluster, my notes are not I hope you forgive me

There are some notes are no pictures, some notes not remove comments or finishing, due to capacity issues I think no hindrance to read without special treatment.

For the convenience of all the copy of my notes, I will post it to SQL code, you can put the impression of notes in the replication after (Evernote), the figure below illustrates how did I do

The relationship between function to copy the code blog Park, the number of lines of code, I have feedback to blog, hope garden blog no matter how many lines of code are given a code copy button

So some notes for the number of lines of code are not will not copy the code button, hope you forgive me

---------------------------------------------Gorgeous split line--------------------------------------------

-------------------------------------Reading notes or

Several backup method most commonly used 1- Xu notes

Method for size notes 2- Xu shrink database

Note 3- Xu set database automatic growth points to note

Note 4- Xu imitation to restore the adventurework database example stopat disaster

Note 5- Xu check the log file cannot be the reason for the truncation

Note 6- Xu detection orphaned users and recover isolated users to the new server to solve the problem of database mirroring orphaned users

Note 7- Xu SQLSERVER logging mechanisms

The difference between the test results of 8- delete and truecate Xu notes

Note 9- Xu DBCC SHRINKFILE doesn't work because

Note 10- using the continue_after_error restore option to recover Xu restore damaged database backup

3 solutions, notes 11- Xu suspect status

Note 12- Xu startup account permissions problem solving

Note 13- Xu about restoring state

Note 14- Xu distributed transaction some common examples and startup log in a distributed transaction startup information

Note 15- Xu SQL boot process network connection

Note 16- Xu solve the error problem of resource database and model database and tempdb database and MSDB database and master database

The common problems of notes 17- Xu user database and solving methods of case

Note 18- Xu SQLSERVER common errors in interpretation

Note 19- Xu how to run DBCC CHECKDB in very large database.

Note 20- Xu SQL I/O

Note 21- Xu SQL connected with the authentication and the common errors

Note 22- Xu SQL client network configuration

Note 23- Xu database state switching and restoration

Note 24- Xu certification and agency problems

Note 25- Xu TCP/IP protocol connection failure detection

Note 26- Xu SQLSERVER memory allocation and memory problems

The working principle of notes 27- Xu SQLSERVER named pipe

Note 28- Xu FQDN error solutions

Note 29- Windows and SQLSERVER Xu memory use and rational allocation of SQLSERVER memory --P166

Note 30- Xu SQLSERVER memory management mode and interface

Note 31- Xu some SQL memory usage errors in understanding and memory usage analysis

Note 32- Xu memory pressure analysis

Note 33- Xu SQLSERVER I/O problem

Note 34- Xu task scheduling and CPU problem

Note 35- Xu shrink database or file notes

Note 36- Xu general database damage types have the following

Note 37- Xu according to error pages, find the object change the page belongs to the table index or other

Note 38- Xu document reduction steps

Note 39- Xu paragraph reduction step partial options

Note 40- Xu page reduction step

Note 41- Xu blocking and deadlock

Note 42- Xu lock background

Note 43- Xu lock resource model and compatibility

Note 44- Xu transaction isolation level and lock request and release

Note 45- Xu to monitor lock application, hold and release the lock and the number of database tuning relationship

Note 46- Xu a common select, update, insert, delete action to apply the lock

Row versioning based isolation levels note 47- Xu in the database engine

Note 48- Xu blocking problem positioning method

Note 49- Xu close SQLSERVER the default event tracking

The transaction log notes 50- Xu read the database of the growth of trace file

Note 51- Xu parameter sniffing Parameter Sniffing

Statistical information note 52- Xu read statements to run

Note 53- Xu trace deadlock and deadlock free SQL footsteps

Note 54- Xu how to enable DAC dedicated administrator connection function

Note 55- Xu SQLSERVER database migration step

Note 56- Xu common SQL system information and collecting methods of P455 fourteenth: Windows event log, SQL ErrorLog, a performance monitor

Note 57- Xu adjust statement design to improve performance

Note 58- Xu to adjust the database design to optimize the statement function

And solution of 59- positioning problem of Xu notes

Note 60- Xu read execution plan P383

Note 61- Xu compilation and recompilation of P372

The meaning and role of P363 note 62- Xu statistical information

Note 63- Xu 12 chapter SQL tuning P357

Note 64- Xu other resources waiting

Note 65- Xu TempDB on PAGELATCH

Note 66- Xu judgment system resource bottleneck P341 from the waiting state

Note 67- Xu Deadlock Case Analysis P333

And the solution note 68- Xu deadlock positioning

Note 69- Xu program end of unexpected circumstances SQLSERVER may lead to problems

Analysis notes 70- Xu case: connection pool (connection pooling) and SQLSERVER connection pool with obstruction

Release method of data pages of notes 71- Xu delete data

-------------------------------- general notes --------------------------------------------

Note 1 ALTER add a column, the column will be immediately UPDATE error, through the EXEC, the UPDATE execution plan generation in execution


Note 3 set execution timeout

Note 4 if you connect to the instance of the SQLSERVER machine the machine's local admin permission, will show a green triangle
Otherwise it will display a white dot

The update statement notes 5 T-SQL technique of case when then end

Usage statistics of intercontinental populations Notes 6 case when

Note 7 case when tables and subqueries

Usage notes 8 COMPUTE BY according to the average value of the total transaction amount of card type statistics for each card type.

Note 9 the over window function to achieve cross function of apply

Application note 10: according to the CROSS APPLY name group name out sales maximum

Note 11 CTE common table expression

Note 12 (datepart) and datename()

Note 13 (DB_ID) and DB_NAME () function

Note 14 the DBCC CHECKIDENT usage, the primary key column to set the seed value increment

DBCC database console command note 15 major maintenance database

The difference between DBCC DROPCLEANBUFFERS and DBCC freeproccache 16 notes.

Note 17 (DBCC IND) is explained in detail with DBCC page ([GPOSDB], 1119,3) is very detailed explanation of 2013-1-20

The difference between exec and sp_exectesql note 18

Methods to find out the reasons of automatic truncation of the transaction log database without notes 19 under Full mode

Note 20 the kill process

Note 21 Latch lock related statements

Note 22 the service broker example

Note 23 (row_number) over stored procedure

The use of dynamic SQL notes 24 pivot +

Note 25 the SQLCMD command prompt tool (formerly OLESQL)

Common global notes 26 the MSSQL system variable 2013-1-10

Note 27 MSSQL lock types

Note 28: mssql update from syntax

Note 29 the MDX query example (Northwind database data warehouse named Northwind)

Note 30 the like statement and the SQL

Note 31 sp_monitor monitor sqlserver

Note 32 the SQL2005 query table structure

Usage notes 33 sp_spaceused query table and database used space

Note 34 SQL code dynamic SQL statement, basic grammar

Note 35 SQL Server 2008 R2 trace flag summary

Note 36 the SQL server access control problems of different role in different a different username

The difference between SQL Server05 level with 37 notes under vertical pool

Note 38 the Sql Server query parameters where in and like.

Note 39 SQL Server batch set password

Note 40 the SQL code in the Server security: DDL trigger and trigger event log database level and server level event

Notes 41 SQL database snapshots and experimental procedures SQL2005 2013-1-31

Note 42 automatically generated SQL2005 script writing SQL scripts to EXECUTE

Note 43 automatically generated SQL2005 script right - "to execute the stored procedure

Note 44 the SQL2005 connection string

Note 45 SQL2005 database mirroring steps

Note 46 SQL2005 database suspect or solution missing log files

Note 47 the SQL2005 maintenance plan task

Note 48 the sqlcmd command examples

Note 49 SQL2005 Using Database Mail steps

Note 50 the SQLSERVER how to add and delete constraints add constraint constraint

Note 51 SQLSERVER 9003 error solutions only applies to SQL2000

Note 52 SQLSERVER2005 lists all users all the database instance.

The installation information notes 53 SQLSERVER storage location

Note 54, SQLServer and Access, Excel data transmission simple summary

Note 55 the SQLSERVER encryption storage process

Note 56 SqlServer 2005 transaction log shipping configuration

Note 57 SQLServer time date

Note 58 the SQLSERVER database tables of various synchronization techniques to reduce the amount of time synchronization and data in SQLServer

Note 59 SQL Server XML to table

The CEILING function and FLOOR function in the SQLSERVER notes 60

Tracking markup notes in 61 SQLSERVER

62 SQL format conversion time notes

Note 63 SQL pause statement waitfor delay

Date and time functions notes in 64 SQL

Note 65 data types in SQL2005

Note 66 SQL resource type RID KEY PAG EXT TAB DB FIL

How to handle Nvarchar digital sequencing problem in SQl notes 67

Note 68 the SSIS package called SQL Job you can query the Job execution history to determine the run time package

Note 69 the stuff function

Note 70 stuff conversion

Note 71 T-SQL senior — SQL Server index of debris and fill factor index rebuild reorganizing an index set the fill factor

The difference between notes 72 TSQL answer set @T = 'select @T =' '

Usage notes 73 XML in SQL

Note 74 test SQL statement function statement

Note 75 testing index, update index statistics empty cache

Note 76 insertion test data, using the Rand [Monitoring] random number of pure 2012-11-20 can not monitor

Note 77 the insert row cardinality data even line

Notes 78 see the CPU number and user number scheduler and the maximum number of worker threads, check whether worker runs out

Notes 79 see SQL Buffer Pool DBCC MEMORYSTATUS

Note 80, check the SQL error log and database transaction log

Notes 81 see SQL index usage

Notes 82 see SQL currently configured the distributor and publisher

Notes 83 to view the currently logged in user in SQL, and each database user sysusers syslogins

Notes 84 to view a system view, stored procedure, the use of system tables and fields

Note 85 the extended stored procedure

Note 86 the goal backup backup set and all kinds of backup, restore script

Note 87 view system currently logged on user database roles and user login hash encrypted password

Note 88 view system views, tables, fields, the SQL statement that the system views

Page notes 89 view system in space and the index page ID number judgment aggregation nonclustered heap or LOB

The lock case notes 90 query information in MSSQL, use the view function stored procedure etc.

Note 91 query name the same int3 minimum recording, processing method of duplicate values in the

All objects in a database notes 92 queries in SQLServer2005 include triggers view table storage process constraints

Note 93 query SQLSERVER memory counter memory usage

Note 94 query SQL user instance name

Note 95 SQL query execution plan

What are the contents of the report notes 96 queries on the report server

And update statistics index information notes 97 query table

Note 98 query and display of the query plan ctrl+l shortcut keys

Note 99 query a table of objectid objectname OBJECT_NAME (objectid) OBJECT_ID (table name '') the table to determine whether there is

Note 100 query system session from SQL2005 to SPID less than 50 are not system session

The SQL statement notes 101 query blocking and deadlock

Methods 102 notes to completely remove Hengshan users

Note 103 the creation operator and the update of the assignment warning level

Note 104 steps to create a partitioned table

Notes 105 to create temporary stored procedure, view, function, temporary temporary temporary trigger

Notes 106 to create the database and generate the database description and each table and field description extended attributes for sp_addextendedproperty 2012-11-29

Note 107 pure monitoring data is inserted into the gun

Note 108 from the A table guide data into the B table in A table will have no data SWITCH TO

Note 109 from a text document or EDITPLUS copy code into SSMS to note

Note 110 print out what is a SQL_VARIANT data type

Note 111 single table test results into 100W records and blog Park index

Recording data file notes 112 single table million level must be GB level

Note 113 when many of the connection to your database, report this error “ has exceeded the lock timeout period &rdquo request directly to the surface; in the stored procedure in your Master database to perform what you can

Notes 114 to obtain the residual space of current database SQLSERVER 2005 database data in the file where the disk(2)

The remaining space insert into the current database notes 115 to obtain the SQLSERVER 2005 database data in the file where the disk #FreeSpace(1)

Note 116 dynamic management views and functions in the framework of sys, and use DM as the prefix

Note 117, according to message_id query the content of the message sys.messages

Note 118 according to the stored procedure into different @Uname query different table

Maximum concurrent notes 119 according to the article below the old practice of using connection number is about 100

Note 120 changes to the MSSQL database physical file name Sql statements written

Note 121, change the table name, function, the schema of the stored procedure name

Note 122 updates a table statistics 2012-12-25

Note 123 common table expression CTE recursive calls to 2012-11-15 in Liaoning Province

Note 124 of table partition technology of load balancing

Note 125 close the data page protection mechanism for IO database, the page_verify database settings options for none SQL Server simple mode, how to restore the deleted heap table records

Note 126 on RAID10 and RAID5 database server selection

The stored procedure notes 127 Guangxi air force authorities oil station update (modified)

The stored procedure notes 128 Guangxi air force authorities oil station update

Note 129, with two tables, the same field numerical large part

To compare notes 130 several loop insertion method

Note 131 the calculation date difference DateDiff

Note 132, the database is in SINGLE_USER mode, in order to obtain exclusive access

Note 133 the database system on a new server recovery, including the system database, enterprise class platform management practice of P66 page restore command line

Notes 134 to unlock the SA user, SQL error 18486

Note 135 the clustering key choice / test, on the query efficiency and debris tolerance selection

Note 136 the clustered index and a comparison between the 3 tables of non clustered index heap table space use

Note 137 wax reporting service6

Results the notes 138 Zhang Search stored procedure execution

The GET stored procedure notes 139 Zhang explained 2012-5-10

The row_number over GET stored procedure notes 140 Zhang implementation result set is not the same as with Zhang(2012-5-11)

GET stored procedure notes 141 I can run in SSMS(2012-5-10)

The Crossjoin stored procedure notes 142 Zhang and table variables

Note 143 the SQL SERVER script database for the preparation of DROP CREATE EXECUTE

Notes 144 to connect to the SQL2005 note

Note 145 temporary tables and table variable comparison table variables to define a field previously, temporary tables do not, even from other don't know field type to form into the number of the temporary table is very convenient

The database field notes 146 Zhang Bai use

The Get stored procedure notes 147 Lao Zhang

The search stored procedure notes 148 Zhang like statement

Note 149 judge SqlServer database, tables, stored procedures, functions, the existence and SQL SERVER version

The SQL statement notes 150 to judge the product version

Notes 151 to judge whether the user is the role of sysadmin login

The existence of notes 152 judgment computer SQL Server Express instance enterprise instance developer instance does not need in the service list search already installed sqlserver instances

Note 153 judgment data of int varchar decimal and other data types

Note 154 mandatory the use of a plan

Note 155 the field table in the SQL database and table shows that

Note 156 full-text index sample SQL (pratice database test)

Notes 157 make the partition table recovery not to partition state SWITCH TO

Note 158 If only the data file, and no transaction log files, then additional database can use ATTACH_REBUILD_LOG 2012-2-19

Note 159 how to use the SQL database set to single user mode

Note 160 delete duplicate records no size relations, processing method of duplicate values in the

Note 161 set the database is offline, online

Note 162 set implicit transaction and explicit transaction IMPLICIT_TRANSACTIONS

Note 163 generation 600 circulation data

Notes 164 to generate a random number (rand) and newid (msrepl_tran_version checksum) publish subscribe.

5 methods of Rand notes 165 random number generation() random

Note 166 time difference conversion

Note 167 the CLR stored procedure

Note 168 white people logged on to the database or change password log demand 2013-2-6

Statistical information note 169, use the @updateusage parameter to update sp_spaceused

Note 170 the use of DBCC IND ([GPOSDB], systempara, -1) to find the data pages using data sheet number and information

Defined error notes 171 using system view sys.messages view system

Note 172 the use of function found in a database and database ID DB_ID() DB_NAME()

Note 173 the use of vernier bulk delete Sql Server objects

The isolation level switch, and introduces the application note 174 affairs

Two methods of note 175 to collect SQLSERVER performance log

Note 176 shrink database log file

Note 177 database mirroring and transaction logs are through the transaction log copying technology to achieve the production server and backup server data synchronization

Note 178 database migration after installation sql2008 server name caused solution name is not consistent

Note 179 database naming rules Zhang

Note 180 add locking hints that rowlock updlock index index(ix_username)

Note 181 add constraint failures

Switch data transfer in different table 182 notes with a library of to

Note 183 failed to find the'master..Xpcmdshell'. stored procedure or is unable to load the DLLxpsql70.Dll reference solution

Dynamic storage process SQL forum notes written in the in (184) how arguments are passed to the problem

Note 185 the system stored procedures sp_MSforeachtable and sp_MSforeachdb, for each database traversal of a database each table and traversing the DBMS under management (database all table record number)

Note 186 to table test1 increase salary this field

The stored procedure with notes 187 white(rowlock)StoredProcedure [dbo].[CT_SynchronizeClearGray]

Note 188 application examples of database repair repair database DBCC CHECKDB

The stored procedure notes 189 to modify the registry

Note 190 sqlserver temporary table Vs table variables introduced cycle into 100 records of the SELECT TOP ( 100 )

Note 191, some commonly used system table

Note 192 oil sales statistics of SQL statement parsing statements

Note 193 for enabling or disabling the vardecimal script

Note 194 re interpretation of single quoted strings of Lao Zhang a stored procedure that single quotes ’ you can escape

Note 195 running under CMD sqlmonitor using replication monitor to see the synchronization error information

Note 196 in two different tables do connected with 3 types of join

Note 197 in document group create index

Note 198 long is paging procedure and paging SQL code

Notes 199 to find a list of duplicate data with repeated number

Note 200 custom lock implementation

Note 201 identify duplicate TSQL remove duplicate rows

Note 202 note if you continue in the completion of the transaction execution of subsequent commands needed to end the statements in a transaction (commit transaction or rollback transaction) add GO statements

Note 203 sqlserver injected and safety study

The stored procedure notes 204 to modify the registry

Note 205 SSMS running under SQLCMD

Note 206 sales inquiries, inventory query summary statement without group by

Notes 207 to create a linked server and query data

Note 208 use linked servers connected to the remote MSSQL server function, only tables and views, than directly connect to the database engine function a lot less

Note 209 test tempdb test script to insert a query table data

Note 210 query data file page information

Note 211 monitors the tempdb script

Note 212 the use of BULK INSERT into the large amounts of data

Note 213 the inner join problem

Want to use in to determine the scope of notes in 214 sqlserver, but can only enter a string parameter, how to remove the string and then dynamic spell in () the contents inside.

Note 215 stuff conversion

Note 216 do not create table test can import the data, table will automatically help you establish a good 2012-12-18 in the database

Total sales note 217 recursive each employee's total sales = their sales + subordinate staff

A table of the total number of pages per page number given calculation note 218 @PageSize @PageIndex @TotalRecords @TableTotalPage 2012-11-22

Notes 219 to the column without pivot, only one row conversion after processing 2012-11-15

Note 220 using select top page_id =0 page is the first page

Note 221 each row former 3 rows of second columns added more average

Note 222 selection table all the columns of data in a column

Note 223 conversion of nvarchar field 11.11 with a decimal point is int then insert another table

Note 224 the SQL2005 cluster hardware requirements and software requirements

Note 225 the following example update statistics for each table in the AdventureWorks database

Table trigger notes in 226 SQLSERVER

Note 227 full-text search, add a field to the field stores all the other fields and 2013-3-15

Collation notes in the 228 SQLSERVER server database table column ""

Note 229 @@IDENTITY global variables 2013-3-20

Note 230 the comparison of CHARINDEX and PATINDEX storage process into multiple parameters separated by commas with PATINDEX 2013-3-20

Note 231 table with field XML data types and then modify the 2013-4-4

Note 232 additional database for server XXX failed error operating system 2013-4-8

Note 233 address database 5172 error error 5173

Note 234 do not restart the SQL service, disconnect the SQLSERVER access 2013-4-9

Note 235 single user mode to start SQLSERVER 2013-4-9

Note 236 SQL Server why use so much memory 2013-4-13

Group by, having, order by, Distinct notices 2013-4-14 notes 237 SqlServer

Note 238 will not ranked as the select field 2013-4-15

Notes 239 Hainan Haikou beer factory database backup script

Note 240 configuration “ for the optimization of &rdquo instant load; for ad-hoc type statement cache optimization for SQL2008 or above

Note 241, system function and system distinction function 2013-4-18

Note 242 the SQLSERVER table increment column view 2013-4-18

Note 243 in SQLSERVER EXCEPT and INTERSECT 2013-4-18 operators

Note 244, set the SQLSERVER Max degree of parallelism 2013-4-18 parameters

Note 245 configuration SQLSERVER publish / subscribe strategy 2013-4-18

Note 246 in SQLServer, supports a variety of automatic generation of the serial number of the mechanism of master yellow 2013-4-18

Notes 247 see MSSQL database users each table space of size sp_MSForEachTable 2013-4-18

Note 248, Excel and SQL Server data transconductance of 2013-4-18

Note 249 the SQLSERVER custom function of the realization of split function in 2013-4-25

Note 250 for cold, hot, warm standby

Notes 251 to upgrade to GPOS1.0 1.1 data transfer scheme

Note 252 the SQLSERVER2012 column storage index

Note 253 ranks of the conversion using the sum function of the statistical and according to the names of service personnel to sort 2013-4-29

Note 254 recursive query region in addition to the use of CTE can use the cursor to change the table structure design 2013-4-29

Note 255 SQLSERVER using the SELECT * INTO data replication or just copy the structure of 2013-4-29

Note 256 query transaction number is repeated, repeated charge

Note 257 tried, composite primary key is not repeated, news 2627, level 14, state 1, line first

Note 258 two wait status DMV view 2013-4-29

Note 259, drag the field to modify the fields in the table sequence

Note 260 SQLSERVER change existing data columns in the table column name to add columns to change the data type length increases the identity column to primary key columns to delete 2013-4-30

Note 261 all Windows operating system version of the maximum number of memory in X86 X64 under 2013-5-3

Note 262 SQLSERVER publish subscribe, changes in the structure of the table, will automatically sync the past. But if the new table, does not automatically added to the publication of concentrated 2013-5-4

Note 263 in SQLSERVER2005 architecture

Note 264 the SQLSERVER server role can not create custom 2013-5-5

Note 265 execution plan cache related SQL 2013-5-5 statement

Note 266 apps in the SQLSERVER2005 role 2013-5-5

Notes 267 to recover the database suspect sp_resetstatus 2013-5-9

Note 268 how to view the SQL table ghostrecord 2013-5-9 phantom records

Permission notes 269 SQLSERVER inheritance in 2013-5-11

Note 270 SQLSERVER in the simple recovery model, the bulk logged recovery model comparison and modification of the recovery model SQL statement 2013-5-13

Notes 271 to view the logical device name and backup using logic devices have been created during reduction benefits and statement BACKUP DATABASE [GPOSDB] TO Sales_Fullbak

Note 272, unable to create the SSIS runtime object. Please verify that DTS.dll is available and whether the registered 2013-5-15

Note 273 the SQLSERVER in the implementation of differential backup 2013-5-16

Note 274 the SQLSERVER transaction log backup role 2013-5-16

Note 275 start sqlserver how much memory 2013-5-21

Notes 276 see missing index need to see what the view 2013-5-21

Notes 277 to view the current database isolation level and the current session set option 2013-5-23

An extended stored procedure sqlserver_ unpublished notes 278 (DBA statements) 2013-5-23

Note 279 view records from class SQL 2013-5-24 statement

Product release number, notes 280 SQLSERVER2008

Note 281 the BCP command

Note 282 a copy only backup 2013-6-7

Note 283 the cursor to realize the dynamic SQL 2013-6-8

Note 284, set the SQL2005 transaction logs do not have to look at the word file, see the screenshot with the SQL script to the 2013-4-30

Note 285 SQLSERVER CXPACKET for 2013-6-11

Note 286 the recovery of the database access encrypted backup file MEDIAPASSWORD and PASSWORD 2013-6-11

Anomaly investigation notes 287 database system DMV 2013-5-23

Note 288 investigation CPU occupies a high 2013-6-12

Notes 289 see also uncommitted transaction SQL 2013-6-13 statement

The event number and the corresponding event notes 290 SQL Trace.

Note 291, Song Daxia wrote the tracking tag 2013-4-30

Note 292 DBCC TRACESTATUS display trace flag state 2013-6-13

Notes 293 to view a table if there are ghost records 2013-6-14

Notes 294 to view the current SQLSERVER tracking session 2013-6-14

Note 295 SQL Server 2008 R2 follow signs for 2011-08-27

Note 296 the DBCC command Daquan

Note 297 a ghost translation two

Note 298 a translation of a ghost

Note 299 gets into the stored procedure parameter, including the parameter value --2013-6-18

2013-6-18 analysis notes 300 Song Yunjian SQLSERVER wait

Log notes 301 trigger record a field data changes include the insertion of insert modified update remove delete operation 2013-6-18

Note 302 view system, create history and steps of all executed by the SQL agent job execution results[sysjobhistory] [sysjobstepslogs] 2013-6-18

Note 303, modify the table structure, how to refresh the associated view 2013-6-19

Note 304 the use of data import and Export Wizard, import excel tables to sqlserver 2013-6-22

Notes 305 to create user defined error alert 2013-6-22

Note 306 the same database case upgrading from GPOS1.0 to GPOS1.1 2013-6-22

Note 307, use the BCP command to the data in the database to generate DAT files, DAT files only a table of data 2013-6-22

Notes 308 to upgrade GPOS1.0 to GPOS1.1 database upgrade script 2013-7-4

Note 309 Windows2003 SQL2005 to solve the problem of 2013-7-4 Administrator password is not know

Note 310 the SQLSERVER database for a large application solutions summary of load balance technology of 2013-7-5

Note 311 and memory error, error number: 17803, 701, 802, 8645, 8651, 8657, 8902

Note 312 the RESTORE DATABASE standby option 2013-7-7

Note 313 remote synchronous database, with transactional replication, is it right? Two machines must be in the same domain?

Note 314 performance monitoring level step 2013-7-8

Note 315 return pipe name

Some of the key counter notes 316 view system including the memory cache of 2013-7-11

Note 317 the 2013-7-11 performance counters

Notes 318 to repair the database suspect

Note 319 the use of stored procedure calls the WebService 2013-7-12

The encryption function notes in 320 SQLSERVER 2013-7-11

Note 321 using Ring Buffer in SQL Server 2008 connection troubleshooting 2013-7-13

The 322 part of the TSQL statement notes with statistical functions (such as DBCC statements, global function, system stored procedures) operation can also help users understand and monitor SQLSERVER 2013-7-14

Note 323 Sqlserver2005 in full text retrieval

Notes 324 to view the data pages in the head DIFF, display the current state of the database system is not the page data page state 2013-7-17

The transaction log backup notes 325 read records in fn_dump_dblog 2013-7-17


Note 327 trigger updates when a field of the A table a field update trigger B table update 2013-7-20

Note 328 export data to EXCEL2003 Zou Jian in the database to create a stored procedure 2013-7-20

Note 329 ranks of the conversion of 2013-7-21

Note 330 using Oni Shi backup to restore the database to a point in time 2013-7-23

Note 331 SQLSERVER new default tracking, using system stored procedure 2013-7-24

Notes 332 to close the SQLSERVER default trace can not use the sp_trace_setstatus 2013-7-24

Notes 333 to open or close the C2 audit tracking need to restart the SQLSERVER service

Note 334 SELECT * FROM [dbo].[BankUser] OPTION (MAXRECURSION 128) sets the number of times CTE recursive prevent death cycle 2013-7-25

Note 335 the SQLSERVER maintenance plan is saved in where? The registry or a file to install directory folder or the system database? 2013-7-27

Note 336 the update how to judge whether a column again, and then performs the appropriate actions of 2013-7-27

Note 337 the SQL expression of flexibility in the use of 2013-8-3

Improvement of SQL2012 memory management notes 338

Note 339, SQL Server 2008 how to compress the log (log) file? 2013-8-10

------------------------------------------- gorgeous split line trading friendly environment

If you have found the link does not link to the article with the title is not the same, must tell me oh o(∩_∩)o

To add one last word: these notes for reference o(∩_∩)o


Now I put the Evernote notes are derived, as long as everyone into the Notes document can be a


Download address:

General notes

The SQLSERVER enterprise platform management practice notes


2013-9-10 added

Now note added to365A

You can download the latest note files and then imported to the Evernote.

Posted by Ellie at November 25, 2013 - 9:07 AM