I. BACKGROUND
Previously wrote an article about: SQL Server cursor Usage: View a database of all table size information (sizes of all tables in a DB), which lists information about all tables of a data, including the number of records in a table,
11. Microsoft SQL server network settingsOverview of Network ServicesSQL Server application interfaceNetwork Connection LibraryNetwork components and SQL server performanceNetwork MonitoringSummaryAfter you install Microsoft SQL Server, you must set
Memory misunderstanding of SQL ServerSQL Server Memory
The read/write speed of the memory is much higher than that of the disk. For the database, it will take full advantage of the memory to cache as much data as possible from the disk to the memory,
master databaseRecords all system-level information for an instance of SQL Server.The master database records all system-level information for the SQL Server system. This includes instance-scoped metadata (such as login accounts), endpoints, linked
MS SQL Server Query optimization methodThere are many reasons for the slow speed of queries, which are common1, no indexes, or no indexes (this is the most common problem with query slowness, is the flaw in programming)2, I/o throughput is small,
Server
The configuration options for SQL Server servers are those that people understand less and are often misused. When a technical support person asks you to adjust an option in some way, and another technical support person asks you to adjust
Server
SQL Server 2000 Log shipping Function-settings (1)
The log shipping feature automatically copies the transaction log file for the database and is saved to another database in the standby server (standby server). Therefore, the availability
This article is the 11th of the SQL Server Security series, please refer to the original text for more information.
SQL Server AuditingSQL Server auditing means that you can monitor events in a database or server instance. The audit log
----------------------------I'm a split line-------------------------------This article is translated from the Microsoft white Paper SQL Server in-memory OLTP Internals Overview: http://technet.microsoft.com/en-us/library/dn720242.aspxTranslators
Original: You do not know the SQL Server database startup process, and can not start the various problems of analysis and resolution skillsAt present, SQL Server database as a good Microsoft RDBMS, its own start-up time is very few problems, we
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.