SQL Server

Perfmon is Windows System Performance Monitor. Used to monitor CPU usage, memory usage, hard disk read and write speed, network speed, and more.Processor/%privileged timeThreshold: A bottleneck is indicated if the value continues to be greater than 7

In a database with a large number of transactions, tables and indexes are fragmented over time. Therefore, to improve performance, you should periodically check the fragmentation of tables and indexes, and defragment them with a lot of fragmentation.

Reasonable configuration of SQL Server memoryOriginal address: https://www.cnblogs.com/lyhabc/archive/2012/09/28/2707857.htmlSQL Server is a program that likes memory resources, and his ideal state is to put all the data and structures that may be

In the new access to the database of daily backup, encountered a number of problems, here to share these solutions to the novice, to minimize the time to see this article, good gossip has ended below to get to the point:A. There is a problem with

This article describes how to implement SQL Server database capacity monitoring with PowerShell scriptsGossip is not much to say, straight into the subjectI. Establishment of the tableCreate a table for each server that records the capacity of the

First explain a concept, what the statistics are:It is simply a description of the distribution of some field data, so that SQL Server probably knows the expected size of the data to guide a database object that generates a reasonable execution

A lock is a mechanism that prevents a process that is performing an action on an object from conflicting with another that has been performed on that object. That is, if someone else is manipulating an object, you cannot manipulate it on that object.

SQL Type C # Type BITBOOLTINYINTBYTESMALLINTSHORTINTINTBIGINTLONGREALFLOATFLOATDOUBLEMONEYDECIMALDATETIMEDATETIMECHARSTRINGVARCHARSTRINGN Charstringnvarcharstringtextstringntextstringimagebyte[]binarybyte[]uniqueidentifierguid//sqldbtype conversion

Recently in the development of a project about the database, I want to use SQLite, but the SQLite designer is not particularly friendly, and then it is said that the VS has an integrated SQLite designer, but I use the VS2017 Pro-test and no user

Transaction log files transaction log file is a file that is used to record database updates, with an extension of LDF.In SQL Server 7.0 and SQL Server 2000, the transaction log files are automatically expanded if the autogrow feature is set.In

SQL Server Configuration Manager (for short, Configuration Manager) contains the SQL Server service, SQL Server network configuration, and SQL Native client configuration 3 Tools for database administrators to do server start stop and monitoring,

Index this block from the storage structure, there are 2 categories, clustered index and nonclustered index, and non-clustered index in the heap table or in the clustered Index table will affect its key value, this block can be detailed view of the

This index cannot be designed from the design view of the data (or it may not be found!). ）[SQL]View PlainCopy CREATE INDEX ix_contractdetail_quantity On Contractdetail (Costid, substatus, Note) INCLUDE (Quantity); And the only

Uninstall the SQL SERVER2008R2 component in the system's Control Panel Add/Remove Programs first, uninstall the Microsoft SQL SERVER2008R2 component (as per the process provided), refresh the control panel after uninstallation, "Microsoft SQL Server2

How does SQL Server 2000 skip Cd-key during the installation process? Solutions from the cloud network are as follows:1. Run "regedit" to open the registry.2. Locate the registry branch HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session

Collection of methods for restoring orphaned users in a SQL Server databaseAlthough SQL Server is now moving more and more, its own approach is becoming more advanced.However, there are many orphaned users in our SQL Server relocation, Microsoft

In some large web sites or applications, a single SQL Server server may have difficulty supporting very large access pressures. A lot of people at this time, the first thing to think about is a solution to the performance problem-load balancing.

The person who writes the program often needs to analyze whether the SQL statement that has been written has been optimized, and how fast the server responds, this time it needs to use the statistics state value of SQL to view it. by setting

The internal function fn_PhysLocFormatter in SQL server has parsing error details, Preface Some netizens pointed out that the internal function of fn_PhysLocFormatter in SQL Server 2012 has an error in parsing the location of the Data row record.

SQL Server adds the syntax of multiple fields to the table. SQL Server Fields Add field syntax Alter table table_name add column_name + field type + Constraints Add multiple fields to a table: Use nature1_oalter table XunHu add MaleCount varchar