sql server dba topics

Here, I am not going to introduce the tips for using SQL Server, nor can I provide a solution to cure all diseases. What I do is to sum up some experience-about how to form a good design. These experiences have come from the lessons I have learned over the past few years and I have seen many design errors repeated over and over again. 1. Understand your tools Don't underestimate this.Article. You may

prevent backup loss caused by hardware damage. [4] You can back up data locally on the database server and transmit the backup files to the backup server in some ways. Are you wearing the backup immediately after the backup is complete? In fact, you can consider using T-SQL statements to write the backup transfer script. [5] After the backup file is transferred

. spid148 **dump thread–spid = 148, PSS = 0x000000044dc17bd0, EC = 0x000000044DC17BE0spid148 ***stack Dump being sent Tod:\microsoft SQL server\mssql.1\mssql\log\ SQLDump0001.txt spid148 * Latch Timeout spid148 * Input Buffer bytes– spid148 * NBSP;NBSP;NBSP;DBCC CHECKDB with ALL_ERRORMSGS External dump process returned no errors. I has only pasted the relevant portion from the errorlog for bre

Srv_trg_restrictnewlogins On the All SERVER For Create_login As PRINT ' No Login creations without DBA involvement. ' ROLLBACK Go --------/*************** --------trying to create a login account --------3w@live.cn --------*******************/ CREATE LOGIN Johny with PASSWORD = ' 123456 ' Go --------/*************** --------Delete demo triggers --------3w@live.cn ---

Tags: uname shrink experience option Set Base storage strong default AddDatabase is the warehouse of data, used to store data, and storage data need medium, now storage medium, most commonly used is hard disk, local tyrants a bit of server use solid State Drive (SSD), Special purpose server uses memory. The most commonly used storage file for a database is a data file and a log file, which is used to store

Tags: str insert third party response view from pop create definitionOverview: As a DBA, it is often necessary to update the official database with the SQL script provided by the developer, but a more reasonable development process, when the script is submitted to the DBA, there may already be hundreds of SQL files, an

execution of the first executor may also cause DBA headaches. From this example, we can see that the query optimizer wants to select an efficient execution plan as much as possible, while the execution plan cache wants to reuse the cache as much as possible. These two mechanisms may conflict in some situations. In the next article, we will continue to look at the conflicts between the execution plan cache and the query analyzer, as well as the common

stores intermediate data and results during a query. 3.OLTP and OLAP OLTP is the main application of the traditional relational database, mainly basic, daily transaction processing, such as bank transaction. OLAP is the main application of Data Warehouse system, supports complex analysis operations, focuses on decision support, and provides intuitive and understandable query results. 4. The database object types mainly include: database diagrams, tables, views, synonyms, programmability, Servic

Server Objectiveperformance, how to maximize the performance of the database is the problem that every DBA needs to face, in a small amount of data running fly, and in a large number of data is slow as a snail, such things have you ever met it? How to improve the concurrency access performance of the database better? Yes, "lock", the key to solving the problem. Preliminary knowledgeLock mode, most content e

Delete column is very ingenious, minimizing the impact on table availability, regardless of the data, delete, only processing the data dictionary class related content, to identify that the column has been deleted, But actually did not go to each page to delete the data, but the space occupied by these columns is logically modified to not exist, allowing later write overwrite. As a small DBA, I personally think that the storage structure of the row

[Source: it is also transferred. The original author is not verified.] 1. Understand your toolsDon't underestimate this. This is the most important one I have mentioned in this article. Maybe you also see a lot of SQL Server programmers don't master all of the T-SQL commands and those useful tools that SQL

Label:Original: SQL Server Automation Operations series-Monitoring Performance metrics script (Power Shell)Requirements DescriptionGenerally in the production environment, sometimes need to automatically detect the status of the indicator value, if there is an exception, need early warning, such as e-mail notification, this article is introduced if the power shell to achieve status value monitoringRange of

Tags: data primary key cat get database server div shrink trigger hrefOriginal: SQL Server schema MigrationThe recent server architecture migration, the original server schema to the new server, the new

Tags: connection number recovery tle Get blog production environment production RAR serverOriginal: SQL Server database MirroringTags: SQL server/mssql server/Database/dba/MirroringOverviewThis chapter covers the installation of d

classifier function is not well tested, the system may not respond to new logon operations, and you may need to use a dedicated administrator connection (DAC) to gain access to SQL Server. If you have not yet configured the DAC, you can restart the server in single-user mode. When running in single-user mode, the connection is not constrained by the resource Gov

UIDA unique index provides SQL Server with information that ensures that a column has absolutely no duplicate values, and when Query Analyzer finds a record through a unique index, it exits immediately without continuing to look up the indexTable index number not exceeding 6There are no more than 6 table indexes (this rule was developed by Ctrip's DBA after a tr

Unknown originOverview:As a DBA, it is often necessary to update the official database with the SQL script provided by the developer, but a more reasonable development process, when the script is submitted to the DBA, there may already be hundreds of SQL files, and there is a sequence of execution, such as the company

High Availability of SQL ServerEvery time we talk about the high availability of SQL Server, many DBAs, especially SQL Server DBAs, feel a pain: Because we all think that SQL Server can

Post by: Mladen prajdi IK: immediate deadlock configurations without changing existing code In myPrevious postAbout immediate deadlock events in SQL Server 2005 I 've shown a way to use a try catch block to get the deadlock error. The con of this method, although it uses best practice for error handling in SQL Server