SQL Server

I copy a database from my classmates, it can be used in his, but when I attach to my own SQL Server, the database appears read-only, I have seen the database source files in the same folder as normal! Please expert advice! Thank you==================

The first step is to create a new linked server in the server object, the linked server, and enter the IP address of the server to be linked.In the second step, security enters the user name and password for the connection data.Third, verify that

Original source: http://blog.csdn.net/dba_huangzj/article/details/38227187, featured catalogue:http://blog.csdn.net/dba_huangzj/article/details/37906349 No person shall, without the consent of the author, be published in the form of "original" or

DECLARE @dingdanid int DECLARE @fanhuizhi intSet @dingdanid = 1EXEC detects the order outbound eligibility @dingdanid, @fanhuizhi output (be careful not to forget output otherwise the return value is null)Select @fanhuizhiCREATE PROC dbo. Detect

--Create a partition function (default is left boundary)CREATE PARTITION FUNCTION PARTFUNC1 (INT)As RANGEFor VALUES (1000,2000,3000,4000,5000);--Create a partition schemeCREATE PARTITION SCHEME PARTSCHEME1As PARTITION PARTFUNC1All to

Learn ADO, inevitably to deal with the database, for beginners, if not tidy up the entire process, then there may be a lot of problems, the following simple introduction of the database operation process. 1. We finally operate on a data table,

Examples of scanning methods in SQL Server execution planOriginal address: http://www.cnblogs.com/zihunqingxin/p/3201155.html1. How to use the execution planSelect the statement you want to execute, click Ctrl+l to execute2. ExampleStudent table, id,

1. Start installing MySQL 5.6, the beginning of the egg acheDownload MySQL 5.6.If you and I do not plan to learn more about MySQL, be sure to download the MSI format installation files, download Zip archive is a nightmare start, I have been a

When PHP connects sqlserver2005, the data read is 12:00AM, that is, the format of the date is mm DD YY Hh:mmamHow to turn it into a 24-hour system, and the format shown is YY-MM-DD HH:MM:SSOpen the php.ini configuration fileLocate the following code;

exec sp_databases; --View Databaseexec sp_tables; --View TableEXEC sp_columns categories;--view columnsEXEC sp_helpindex categories;--View indexEXEC sp_helpconstraint categories;--constraintsexec sp_stored_procedures;exec sp_helptext '

Limit query rows and Leleti high-performanceThis rule is very simple, and here is no detail.Use Search to parameterize (sargable conditions) to improve performanceSargable by the search ARGument Able shorthand, literally means that the searching can

View the number of data rows for each table= i.id 'U'2ORDER by O.name; Calculate the space occupied by each row of records in the database--select *From Employees as E; CREATE TABLE #tablespaceinfo (nameinfo VARCHAR ( -), Rowsinfo BIGINT,

--Early this monthSelect DATEADD (Mm,datediff (Mm,0,getdate ()), 0)--month EndSelect DATEADD (Dd,-1,dateadd (Month,1+datediff (Month,0,getdate ()), 0))--Set the first day of the week to MondaySET Datefirst 1DECLARE @cur_week1 varchar (10)--the first

1. Open the registry, find [hkey_local_machine\software\microsoft\windowsnt\currentversion\perflib\0804], open counter and help respectively650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/38/EA/wKioL1O0zWfAWK3vAAJMbdC2EGM387.jpg "style="

Database processing high concurrency two ways of vertical and horizontal differentiationvertically differentiate [distributed database]: separate database by module.Disadvantage: The design of each module of the system needs to be higher, cohesion

The leaf page of a clustered index stores the table's data. As a result, table rows are physically sorted by clustered index columns, because table data can only have one physical order, so a table can have only a single clustered index.When we

Set STATISTICS PROFILE onSET STATISTICS IO onSet STATISTICS TIME onGoGoSet STATISTICS profile offSET STATISTICS IO offSet STATISTICS time offIn the following message, you will see:SQL Server parse and compile time:CPU time = 0 milliseconds, elapsed

Original address: http://blog.itpub.net/35489/viewspace-616459/In SQL Server, where the transaction log is often large, in addition to setting the database to auto shrink, you can use the following SQL command to quickly clear the transaction log in

Get current date use convert to convert to the datetime format we need. Select CONVERT (varchar), getdate (), () 20040912------------------------------------------------------------Select CONVERT (varchar), getdate (), 102) 2004.09.12-------

Select*from sys.sysprocesseswhereSpid> -and blocked>0--can view blocking SELECT SPID=p.spid, DBName =convert (CHAR ( -), D.name), ProgramName =program_name, LoginName =convert (CHAR ( -), L.name), HostName =convert (CHAR ( -), hostname), status=