SQL Server

Pre-Preparation:Use master;CREATE table Loginlog (LoginName nvarchar (+), Logintime datetime);CREATE PROCEDURE Sp_recordloginlog #注意没有参数的情况下不可以有 "()"AsBeginInsert into Loginlog (loginname,logintime) VALUES (System_user,getdate ());EndGo--------------

1.Database-level shared locks to prevent others from deleting this database.2.The intent shared lock on the table to prevent others from modifying the definition of the table.3.Add intent to share the lock on the page.4.A shared lock is added to

SQL Server Import ExportSQL Server Import ExportTools/Materials Import and export data using Microsoft SQL Server Management Studio. Importing and exporting data directly using Microsoft SQL Server Management Studio loses primary keys,

First, if xp_cmdshell is not enabled, perform the following enable:EXEC ' Show advanced Options ' 1 ; RECONFIGURE; EXEC ' xp_cmdshell ' 1 ; RECONFIGURE;1. Create a map:exec ' net use \\192.168.9.140\Share 123456/user:192.168.9.140\administrator '2.

-----------------------------Full-text indexing using a small sample------Use SQL2000 and SQL2005 respectively------------------------Usage Scenarios: Complex query text data stored in data columns--EnvironmentUse PooflyGoCREATE TABLE HELLO (ID INT

Recently in the database on the random number, really touch I want to die heart all have, before all through the rand () function of PHP to deal with a range of random numbers, but recently in the processing of large amounts of data processing

1 SELECTRECORD.[record_id]2, RECORD.[workflow_info_id]3, RECORD.[Form_code]4, RECORD.[apply_date]5, RECORD.[apply_emp_id]6, RECORD.[Apply_emp_number]7, RECORD.[apply_emp_name_en]8, RECORD.[APPLY_EMP_NAME_CN]9, RECORD.[Apply_emp_email]Ten,

Fixed server role DescriptionThe sysadmin can perform any activity in SQL Server.ServerAdmin can set server-wide configuration options to shut down the server.Setupadmin can manage linked servers and startup processes.Securityadmin can manage logins

Method 1,Sys.dm_exec_qurey_stats returns aggregate performance statistics for cached query plans in SQL Server. each query statement in the cache plan corresponds to a row in that view .                                   &N Bsp             and the

1. each execution of the SQL statement generates an execution plan and is cached because the execution plan is generated with time overhead, so reusing the execution plan can improve performance and save buffer space. We can use

IF object_id (' tempdb.. #t ') is not a NULL DROP TABLE #tGOCREATE table #t (ID int identity,dt varchar (10))GoDECLARE @starttime datetime, @endtime datetimeSet @starttime = ' 2010-5-01 'Set @endtime = ' 2010-5-31 'Select number from Master.

BusinessPrimary key:Index:Lock:=========================================A page is divided intoPage HeaderPage body--store rowEnd of pageThe page has a fixed size, but the data is not necessarily full, it is possible to fragment, that is, row-by-page=

MSSQL database is divided into natural connection, inner connection, outer connection1, natural connection and inner connection are basically the same. The difference is that the natural connection "=" on both sides of the column property values

When does the line version start?When we find that there are a lot of read/write blocking in the system, it is time to turn on the line version. Important: Write blocking scenario line version technology can not solveOpen mode:--set to single user

Because the things that I want to summarize are messy, it's a problem.1. When restoring a database, no tail-log backup is selected, an exception occurs:This is because for databases that use the full recovery model or the bulk-logged recovery model,

Method 1, rebuild the clustered index.Method 2, rebuild the heap table.--------------------------------------------------------------------------------------------------------------- --------------------------------------------------Principle

-- currently encountering this problem occurs when the server is switched on. The old server backed up database is restored to the new server, and you will encounter this problem -The following scenario:- - Find the orphaned user list EXECUTE'

1. Get the database backup file, how to get, [can see here]~2. Add a. bak suffix to the backup file, for example:3. Open SQL, you can create a new empty database, or use the original database, right-click >> Tasks >> Restore >> Database4. The

Method 1,Set the file growth to a fixed size. such as FileGrowth = 100MB;--------------------------------------------------------------------------------------------------------------- -------------------------------------------Data file growth

SQL Server aggregates historical backup information to compare database growth, SQL Server Most of the time, when we plan the space for the SQL Server database or ask for storage space, we need to estimate the size of the database space to be