PHP

Tempdbinitialsize and dbccshrinkfile when using sqlserver, you may encounter the following situation: the initial size of the tempdb data file is 3 mb. With the use of tempdb, tempdb files gradually become very large (for example, 30 GB), resulting

I. compression index MyISAM uses prefix compression to reduce the index size. By default, only strings are compressed, but integers can also be compressed through settings. Compression can use less space, at the cost that some operations may be

Metadata locks in SQLSERVER the metadata locks on the Internet are really very small. Metadata locks usually appear in the DDL statements to list the resources that can be locked by the database engine. Metadata locks in SQLSERVER the metadata

An online business needs to store and analyze log information in the management background. One day, I suddenly found that there was no analysis data from the previous day in the background. First, I think it is a java program problem, so I view the

The Mail System postfix + extmail + mysql based on virtual accounts has the following features: 1. support web Access 2. free account registration 3. supports network disks and personalized settings. 4. virtual account The Mail System postfix +

For BI projects, the technical implementation of Data Warehouse mainly involves data integration. The source data may come from different business databases (such as SqlServer, ORACLE, Mysql, and EXCEL ), the data flow component of SSIS can easily

The file leveldb is implemented based on the standalone BigTable, but the file organization method varies according to the following. Each database is implemented by a collection of files stored in the folder. There are many different types of files:

1. Create a file named "computer.csv" for the storage server name. 2. Create a PowerShell script. Read the name of the server created in step 1, query EventLog information, and store it in the CSV file. The Code is as follows: 3. Save the script 1.

The difference between SQL-based table data deletion and truncatedeletedrop is that the following content is reproduced: learning to use 1. truncate, delete without where clause, and drop will delete table data. 2. drop and truncate are all DDL

Problem and Description: -- 1. student table Student (S #, Sname, Sage, Ssex) -- S # Student ID, Sname Student name, Sage year of birth, Ssex Student gender -- 2. course curriculum Course (C #, Cname, T #) -- C # -- Course No., Cname Course name, T #

SSTable is a crucial part of Bigtable. It is also true for LevelDb. Understanding the SSTable Implementation Details of LevelDb also helps you understand some implementation details in Bigtable. This section describes the static layout structure of

The role of KeyHashValue in SQLSERVER (ii) I discussed the role of KeyHashValue with Gao wenjia kids shoes at noon yesterday. Finally, I still did not discuss the result. Fu Wenwei, German Brother, did an experiment last night, I would like to thank

Pubsub is a message communication mode. It mainly aims to decouple the coupling between the message publisher and the message subscriber, which is similar to the observer mode in the design mode. Pubsub not only addresses publisher and Pub/sub is a

For more information, see leonarding.blog.51cto.com Oraclecommenton annotation information methodology. Introduction: You may frequently write comments in DBA daily work. However, you may want to write and use Oracle commands. For more information,

MySQL Database Hot Standby ------ master-master backup configuration experiment environment: Master 1 Database 192.168.1.1centos6.5x86 _ 64 + MySQL5.5.35 master 2 database 192.168.1.2WindowsXPx64 + MySQL5.5.13 I. Installation count MySQL Database

Since SQL Server started the public account, the new homepage is updated. Today, SQL Server started the public account and added the homepage function. Although it is still a subscription number, the layout has been greatly modified, I hope you can

Table Partitioning for sqlserver The amount of data in the most recent project exceeds tens of millions, and a common single table query is also slow, which is intolerable for customers to wait for a long time. So I tried every means to optimize the

1. Description 1. Background 1). The user adopts the DBA permission. the DBA permission has the permission to access all user data in the database, which is not safe. 2). The tablespace does not correspond to the user and cannot be directly

Sometimes, the distribution database (DistributionDatabase) will grow very large, so how to solve it? Please refer to the solution of ChrisSkorlinski and MicrosoftSQLServerEscalationServices. Original article address:

SQLSERVER to obtain database file information MSSQLSERVER to obtain the current database file and other information, applicable to multiple versions: SELECTdbf. file_idASFileID, dbf. nameAS [FileName], s. filenameASFileLocation, CAST (dbf.