automate sql script execution

Label:Little stuff, for database backup. Retained. #!/bin/SHkeepdays= -currenttime=`Date "+%y-%m-%d-%h-%m"' Backpath="/sql_bak/"DbName="Smdb" Echo${currenttime}/usr/bin/mysqldump--default-character-set utf8-u xxx--password=xxx--database ${dbname} >${backpath}${dbname}.${currenttime}.sql; /usr/bin/SCP${backpath}${dbname}.${currenttime}.sql [email protected]1.2.3.4: ${backpath}${dbname}.${currenttime}.

Label:Use Alterdatabase to set a smaller filegrowth or set a new size.Workaround: 1 (the root of the problem)--this method has not been validated. Who weak tried to tell. Thank youI'm actually a database file that timed out when it was added. Instead of flat, the specific SQL statement time-out is often assumed. Set the filegrowth to a lower value, OK everything is restored.The setup of FileGrowth is to set the following window for the properties of t

Label: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 Statistics we can view the system situation when executing SQL. The options are Profile,io, time. Introduced as follo

()->db->createcommand ($sql);$command->execute ();}/*** Clean up the system cache every day 7:30*/Public Function Actioncache () {Yii::app ()->cache, flush ();Yii::app ()->dbcache, flush ();Yii::app ()->fcache, flush ();}/*** Clear Upload Temporary files*/Public Function Actiontempfiles () {$dir = Yii::getpathofalias (' site.frontend.www.uploads.temp '). ' /‘;foreach (Glob ($dir. ' *. * ') as $v) {Unlink ($v);}}}3. Using the Linux command, VI crontab

, Share my knowledge to help others understand the "Execution Plan ". If you like it, you can read it slowly or simulate the experiment below on SQL Server. Start To explain "Table scan", "index scan", "index seek", "clustered index scan", and "clustered index seek" in "display Execution Plan", create a new table first, and add some sample data. The

or simulate the experiment below on SQL Server. Start To explain "Table scan", "index scan", "index seek", "clustered index scan", and "clustered index seek" in "display Execution Plan", create a new table first, and add some sample data. The script for creating a new table is as follows: Create Table performanceissue(PRID uniqueidentifier not null,Pr

stored in one file. Then, confirm the generation option and generate it. References: F1 help for generating SQL server script wizardHttp://technet.microsoft.com/zh-cn/library/ms181421.aspx How to: generate a script (SQL Server Management studio)Http://technet.microsoft.com/en-us/library/ms178078.aspx How can I

Label:To test SQL performance:One, by setting statistics to view the system situation when executing SQL. Options: Profile, O, time.SET STATISTICS profile on: Displays the time, in milliseconds, that is required to parse, compile, and execute the query.SET STATISTICS IO on: Reports information about the number of scans per table referenced in the statement, the number of logical reads (pages accessed in the

execution plan View code --Delete all plansDBCCFreeproccache 2.3 Test script (create an employee table and insert 1000 pieces of data to it) View code If Exists ( Select * From SYS. Objects Where Object_id = Object_id (N ' [DBO]. [employee] ' )) Drop Table [ DBO ] . Employee Go -- Personnel table Create Table DBO. employee (ID Int , Name Nvarchar ( 50 )); -

Then, execute the script: Declare@ TDatetime Set@ T= Getdate() Set Nocount On Declare@ IInt,@ CountInt,@ SQLNvarchar(4000) Set@ I=20000 While@ I30000 Begin Set@ SQL= 'Select @ COUNT = count (*) from p_order where else Eno =' + Cast(@ IAs Varchar(10) ) Exec Sp_executesql@ SQL,N'@ Count int output',@ CountOutput Set@ I=@ I+1 End Print D

:-- Delete all plansDBCC FREEPROCCACHE 2.3 Test script (create an employee table and insert 1000 pieces of data to it)Copy codeThe Code is as follows:If exists (SELECT * FROM sys. objects WHERE object_id = OBJECT_ID (n' [dbo]. [Employee] ')Drop table [dbo]. EmployeeGO-- Personnel tableCreate table dbo. Employee(Id int,Name nvarchar (50));-- Insert Test DataDECLARE @ I INT = 0, @ ENDI INT = 1000;WHILE (@ I BEGINSET @ I + = 1;INSERT dbo. Employee (id, n

First, describe the memory used by SQL Server. The memory occupied by SQL Server is mainly composed of three parts: Data Buffer, Procedure Cache, and SQL Server engine program. The cache occupied by SQL Server engine programs is generally relatively small, so the main focus of memory optimization is data cache and

tasks-> Generate SQL scripts-> Save to an SQL file in the OS Then, run the SQL script for creating the job saved just now on the target server. (If the user who created the job or the user who reminded him does not exist, an error will occur; We need to create a WINDOWS user or SQ