sql shrink database

Tags: LTE tin tac hit Lex supports RAC query statement testingIn our Java development application process, will inevitably encounter the system performance problems, especially in the enterprise application development process, will deal with the database. When we encounter database performance, the most effective is to directly track the execution of each SQL st

into' Student 'VALUES('8','Lee 48','123','male',' +','Jingan, Shanghai city'); INSERT into' Student 'VALUES('9','Zhang 39','111','male',' +','Shiyan, Hubei province'); INSERT into' Student 'VALUES('Ten','Lee 40','123','male',' +','Jingan, Shanghai city'); I. Querying 5~10 data MySQL Paging query: SELECT * FROM student limit 5, 10; Oracle Paging query: SELECT * FROM (select *,rownum rn from student) where RN between 6 and 10; SQL Server Paging q

CYQ. Data V5 text database, which was previously introduced: Play Code First with a text database over the weekend The principle of Data storage is based on json or xml format. It also introduces the technical principle of CYQ. Data V5 Text Database decryption. After implementing basic functions a few days ago, I also wrote the idea of conflicting

Tags: database access Microsoft database application Drive Server(content is organized from the MSDN Azure SQL Database topic section) similar to SQL Server, Azure SQL database accesses

Php:It is usually the beginning of the code you want to check to record a time, the end of the record a time. Take the difference value,the efficiency of database SQLSQL explain (MySQL), enable slow query log to record slow queries. Usually also depends on the database design is reasonable, the demand is reasonable and so on.But this time is generally very fast, in less than a second, so you can not direct

In actual development, we often encounter data conversion needs. We can transfer the data in Excel to SQL, or import the data in the database table into Excel.CodeAs follows:Using System;Using System. Collections. Generic;Using System. ComponentModel;Using System. Data;Using System. Drawing;Using System. Linq;Using System. Text;Using System. Windows. Forms;Using GemBox. ExcelLite;Using System. Data. SqlClie

SQL-database materials used for basic learning, SQL-basic database materials -------------------------- Create MERs table------------------------Create table MERs(Cust_id char (10) not null,Cust_name char (50) not null,Cust_address char (50) NULL,Cust_city char (50) NULL,Cust_state char (5) NULL,Cust_zip char (10) NUL

Quick solutions for full SQL Server database logs. First, provide a complex method to compress logs and database files as follows: 1. clear the log DUMPTRANSACTION database name WITHNO_LOG2. transaction log truncation: the BACKUPLOG database name WITHNO_LOG first provides a

with delete can have a certain effect on the performance of the stored procedure. Because delete takes a full table-by-scan approach, it is a transactional operation that is counted into the SQL Server transaction log. Not only increases the running time, but also writes log files frequently, which causes the log file to be too large and consumes disk space excessively. Therefore, you can use the truncate operation instead of delete,truncate is not c

. database_id = B. database_id where. database_id = DB_ID ()SET @ strSQL ='-- Set the database recovery mode to simpleAlter database ['+ @ strDBName +'] set recovery simple;-- Shrink log filesDbcc shrinkfile (''' + @ strLogName + ''', '+ CONVERT (VARCHAR (20), @ DBLogSise) + ');-- Restore the database to full ModeAlter

1. View the version of the database SELECT @ @version 2. View the machine operating system parameters of the database EXEC master.. xp_msver 3. View Database Startup Parameters sp_configure 4. View Database Startup time Select CONVERT (varchar, login_time,120) from master. sysprocesses where spid=1 To view the

to shrink to XXM in the contraction mode. Here, a minimum number of MB allowed to shrink is displayed. EnterNumber. OK.-- Select data file -- select to shrink to XXM in the contraction mode. Here, a minimum number of MB allowed to shrink is displayed, and you can directly enter thisNumber. OK.You can also use

Tags: SQL Server1, the thing log is divided into small virtual log VLF, it has a number called LSN2, the checkpoint by default every 1 minutes to save memory data, the failure point occurs after the log redo, the thing according to the submission or not roll forward or rollback.3, in the overall main menu bar of the database to select the properties to set the data file and log file storage location, after

, you can stop the SQL Service and start again, as for the above other errors, you can change the content of the errors to restore them. Iii. Database shrinking In general, the contraction of the SQL database does not greatly reduce the size of the database. Its main functio

copy of the original table on each member server, but in fact there is only one member table and one distributed partitioned view per server. The location of the data is transparent to the application. 11. Rebuild index DBCC REINDEX, DBCC INDEXDEFRAG, shrink data and log DBCC SHRINKDB,DBCC shrinkfile. Set up automatic shrink logging. For large databases do not set up automatic