sql shrink database

Mysql Database SQL Optimization-subquery optimization and mysql Database SQL Optimization1. What are subqueries and table join queries:Subquery: The select statement is used in the select or where clause of the primary SQL statement; select. name, (select B. name from B wher

PHP connection to SQL Server database, the database is known as bs3000+_001_2011 this with the + number of the database, can not choose to enter the database??

''@ procedure_name'' View the data object name containing a string @ str Select distinct object_name (id) from syscomments where text like ''% @ str %'' Create an encrypted stored procedure or function WITH the with encryption parameter before the You can use sp_decrypt to decrypt encrypted stored procedures and functions. 10. View user and process information in the database Sp_who View information about active users and processes in the

Starting this week to ease work pressure. Start using Database maintenance plans (SQL Server Maintenance plan Wizard) to maintain the database, since it has not previously been used, in the personal use of the free version (Express) does not have this function, so now learn a good , here's a summary. The Maintenance Plan Wizard can be used to help you set up core

Operations between two tables in the T-SQL database, t-SQL database operations -- Modify data in a table based on another table Update Admin_FCOutDt set oLastId = T. contractID from (select crm_contract.contractTopic, crm_contract.contractID from Admin_FCOutDtleft join crm_contract on rows = crm_contract.contractTopi

Simple SQL statements for database learning and Database SQL statements 1. Database Structure 1.1 Database Different databases are called Catalog (Database in some DBMS ). After using m

Persons_backupfrom PersonsSQL SELECT into instance-with a WHERE clauseWe can also add a WHERE clause.The following example creates a table named "Persons_backup" with two columns by extracting information from the "Persons" table of people residing in "Beijing":SELECTLastname,firstname INTO persons_backupfrom Persons WHERE city= ' Beijing 'SQL SELECT into instance-connected tableIt is also possible to select data from more than one table.The followin

Follow the steps to avoid damaging your database if you do not follow the previous steps. Generally do not recommend to do 4th, 62 steps, 4th step unsafe, it is possible to damage the database or loss of data. 6th step if the log reaches the upper limit, subsequent database processing will fail, and the log will not be restored until it is cleaned. 1. Empty log D

server| Solution | data | database The first is to provide a complex method for compressing logs and database files as follows: 1. Empty logDUMP TRANSACTION Library name with NO_LOG2. Truncate the transaction log:BACKUP LOG database name with NO_LOG3. Shrink the database fil

SQLServer how to use the T-SQL command to query a database in which tables, convenient table operations, need friends can refer to the next SQLServer how to use the T-SQL command to query a database in which tables, convenient table operations, need friends can refer to the next 1. query all tables in

Problems encountered when using website management tools for Logon pages Problems:Go to ASP. NET configuration in the "website" menu of Visual Studio 2005 and click "security". The following error message is displayed: "A problem may occur in the selected data storage zone because the server name or creden are invalid or the permissions are insufficient. It may also be caused by the absence of the role manager function. Click the following button to redirect to the page where you can select a

1. view the database statusDirectory view: Select name, state_desc from SYS. databases where name = 'stusystem'Function: Select databasepropertyex ('stusystem ', 'status ')Stored Procedure: sp_helpdb stusystem2. Modify the database2-1 modify Database NameAlter database database_name modify name = new_nameExec sp_renamedb 'studentsystem', 'stusystem'2-2 expand the

1. sort by strokes of the Last Name: Select * From tablename order by customername collate chinese_prc_stroke_ci_as 2. database encryption:Select encrypt ('original password ')Select pwdencrypt ('original password ')Select pwdcompare ('original password', 'encrypted password') = 1 -- same; otherwise, different encrypt ('original password ')Select pwdencrypt ('original password ')Select pwdcompare ('original password', 'encrypted password') = 1 -- sam

Windows Azure Platform Family of articles Catalog　　　In my previous article, I have described how to enable Azure SQL database to support Chinese:　　SQL Azure (vii) T-SQL executed in SQL Azure databaseThe key steps are:1. Use the default character set: SQL_Latin1_General_CP1_C

---finish.Manual shrink: Database---right-click Task shrinking--Database/file--OK. Vi. generating and executing SQL scripts Generate SQL Script for database: Database--write script->cre