sql shrink database

If you are in charge of a SQL Server-based project or you have just been in touch with SQL Server, you may have to face some database performance problems, this article will provide you with some useful guidance (most of which can also be used for other DBMS ).Here, I am not going to introduce the tips for using SQL Se

To import all the data stored in the SQL Server database to the MySQL database, collect related information on the Internet, and find two methods. Now let's talk about them separately. The first method is to install MySQL ODBC and use the export function of SQL Server to select the MySQL data source for direct data

SQL database Stored Procedure example parsing and SQL stored procedure example What is a stored procedure:Stored procedures can be said to be a record set, it is a code block composed of some T-SQL statements, these T-SQL statement code implements some functionality like a m

--------------------------------- The SQLWHERE clause syntax used by ArcGIS10 to help Query file geographic databases is the same as the syntax used to query coverage, shapefile, and other file-based data sources, but some functions are added, for example, subquery is supported. Therefore, the WHERE clause syntax is different from that of a personal database. A ----------------------------------- The SQL WH

database or cause data loss. If the log reaches the upper limit in step 1, the subsequent database processing will fail and the log can be restored after being cleared. 1. Clear logs Dump transaction database name WITH NO_LOG 2. truncate transaction logs Backup log database name WITH NO_LOG 3. Compress

Use the php statement to import the database *. SQL file to the database. The simplest php statement to put the database *. the code for copying an SQL file to a database is as follows: $ sqlfile_get_contents (text.

queries that reference the distributed partitioned view name to run on any member server. The system operates as if each member server has a copy of the original table, but there is only one member table and one distributed partitioned view on each server. The location of the data is transparent to the application. 11. Rebuild the index DBCC REINDEX, DBCC INDEXDEFRAG, shrink data and log DBCC SHRINKDB,DBCC shrinkfile. Sets the auto-

Remote connection SQL Server 2008, server-side and client configuration Key settings: The first step (SQL2005, SQL2008): Start--> program-->microsoft SQL Server 2008 (or the)--> Configuration Tool-->sql Server Configuration Manager-->sql Server network configuration--> MSSQLServer (this name is the exact instance na

This article uses some of your own experience to tell your hacker friends how to use your database SQL vulnerability to download your database. If you need it, refer to this article. Create a table in the database: The Code is as follows: Copy code Create table 'Article '('Articleid' int (11) no

like '% @ str %'Create an encrypted stored procedure or function WITH the with encryption parameter before theYou can use sp_decrypt to decrypt encrypted stored procedures and functions.10. View user and process information in the databaseSp_whoView information about active users and processes in the SQL Server databaseSp_who 'active'View the locks in the SQL Server databaseSp_lockProcess No. 1--50 is used

Basic Database SQL syntax and basic SQL syntax Reprint please indicate from Zhu jiayuan http://blog.csdn.net/zhgl7688 Basic Database SQL syntax 1. Create a SQL database, Open

This article comprehensively describes the SQL syntax. Whether you are a newbie or a veteran of SQL, you will have a general understanding of SQL. In addition, you will be able to correctly use SQL to obtain information from the database. Although a thorough understanding of

Source: http://www.cnblogs.com/nbpowerboy/p/3380079.htmlThe company has been using SharePoint 2010 for more than three years, and the BPM project also has more than 2 years, before the vendor's deployment of the SharePoint database is on a physical disk, the database files and log files are not separately stored on different physical disks, Recently found that the datab