sql server 2012 administration tutorial

you go to the desktop, you cancmdprompt, through theEcho%logonserver%"To see where the current user isDClog in to the domain. As shown, the current userUser1is throughDC2logged in. (If you can't rememberDCmay be referred to by the precedingDNSCheck the host name for the records in the server)650) this.width=650; "src=" http://s1.51cto.com/wyfs02/M02/8A/45/wKioL1gsU2Cz_eClAAAQkkvcDAk753.jpg "title=" 8-17. JPG "alt=" wkiol1gsu2cz_eclaaaqkkvcdak753.jpg

; "Src=" Http://s2.51cto.com/wyfs02/M01/8A/1B/wKioL1gnClDBxrDZAABeMkpk43U307.jpg-wh_500x0-wm_3 -wmp_4-s_2660492647.jpg "title=" 5-13.jpg "alt=" Wkiol1gncldbxrdzaabemkpk43u307.jpg-wh_50 "/>STEP2 : Select multiple users at the same time, and follow the path of the configuration file, the home folder is modified ( \\IP\ Share name \%username% )650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/8A/1B/wKioL1gnCnaS6P2_AAENCewYU4Q758.jpg-wh_500x0-wm_3 -wmp_4-s_2894568232.jpg "title=" 5-14.jpg "

Tags: sql Server; read-only; specific tablesCreate a read-only account and only read certain tables.Now let's share the steps of the operation.The premise of this operation is that the database is relatively large, there are many data tables, you need to select their own read-only data tables.The operation of the new account should not be unfamiliar, to everyone is not discussed.In the left User Mapping tab

although the result of our previous query was orderly, the new table generated after the run was not sorted by Subprenum and the order was chaotic.It was discovered that this was due to the limitations of SQL Server itself and that if there was a special need to require the data in the staging table to be ordered, the problem could be solved by "creating a clustered Index". For details, please refer to the

']/value '). Value (' (value) [1] ', ' NVARCHAR (100) ')--get sql_textset @sql_text = @xmlData. Query ('//action[@name = ' Sql_text ']/ Value '). Value (' (value) [1] ', ' NVARCHAR (MAX) ')--start inserting data insert #MyData (database_id, Sql_text, username, client_hostname , Client_app_name, Cpu_time) VALUES (@database_id,--Database_id-int @sql_text,--Sql_text-nvarchar (max) @use Rname, @client_hostname, @client_app_name, @cpu_time) end TRY BEGIN catch END catch FETCH NEXT from Mycur into @

Tags: database log repository truncate recovery data alter DIV modeMEDIA Database nameALTER DATABASE media set RECOVERY easy with no_wait ALTER DATABASE Media set RECOVERY simple--simplified mode DBCC SHR Inkfile (N ' Media_log ', one, truncateonly) --11 is size 11M ALTER DATABASE MEDIA SET RECOVERY full with NO_WAIT alter DATABASE MEDIA SET RECOVERY Full--Revert to complete mode Ext.: http://blog.csdn.net/hehe520347/article/details/48497229How to truncate logs for

--Cross join produces a Cartesian value (x*y) SELECT * from Student crosses Join dbo. ClassInfo--Another way of writing select * from Student, ClassInfo--INNER join (Inner can omit) select *from Student JOIN dbo. ClassInfo on dbo. Student.class = dbo. classinfo.id;--Inner Join SELECT *from Student Inner join dbo. ClassInfo on dbo. Student.class = dbo. Classinfo.id; --on condition, usually the primary foreign key, but not limited to the primary foreign key--on condition, which allows multiple, a

(Col1int, Col2Char(5), Col3Char(3), Col4Char(2)) with(data_compression=ROW)--Create a Table assigning Page CompressionCreate Tablegreatforpagecompression (Col1int, Col2Char(5), Col3Char(3), Col4Char(2)) with(data_compression=PAGE)/*Keep in mind ALTER TABLE and alter INDEX can is used to implement compression when those obects already exist.*/3. Availability of databases/*Change various database option and refresh the MGMT*/--2.1 Setup:add A Table and a couple of rows. UseTinyDB;GOCreate Table

"style=" float: none; "title=" 119.png "alt=" Wkiol1v1onxtv0e4aai20kvznnm166.jpg "/>650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6E/2C/wKioL1V1oQOxwfiMAAHXNWVAE6Q849.jpg "style=" float: none; "title=" 120.png "alt=" Wkiol1v1oqoxwfimaahxnwvae6q849.jpg "/>650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6E/30/wKiom1V1n2DRd_rkAAKYLTCFdEQ747.jpg "style=" float: none; "title=" 121.png "alt=" Wkiom1v1n2drd_rkaakyltcfdeq747.jpg "/>650) this.width=650; "src=" http://s3.51cto.com

-s_4230358370.jpg "title=" 9-11.jpg "alt=" Wkiom1gtp7ihmxl7aabq_hapcvs480.jpg-wh_50 "/>continue to use this account to detect whether the computer can be shut down by command Win 7 . 650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/8A/54/wKioL1gtp8vDy2twAABLrA5Ighg220.jpg-wh_500x0-wm_3 -wmp_4-s_581541008.jpg "title=" 9-12.jpg "alt=" Wkiol1gtp8vdy2twaablra5ighg220.jpg-wh_50 "/>( 2 ) use not in the OU Login to an account within Win 7650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/

of computers, users and other account information, the difference is that the computer or user accounts, as long as the DC is automatically published to the AD , you do not need to publish manually like a shared folder. 650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M01/8B/78/wKiom1hOnkPCJBokAACSWXKHtic414.jpg-wh_500x0-wm_3 -wmp_4-s_1138537440.jpg "title=" 1120.jpg "alt=" Wkiom1honkpcjbokaacswxkhtic414.jpg-wh_50 "/>This article from "Network Snail" blog, declined reprint!Windows

Tags: Linux SQL Server PHPConnecting to a SQL Server 2012 databaseHttp://www.freetds.org/userguide/choosingtdsprotocol.htmDownload and install ftp://ftp.freetds.org/pub/freetds/stable/freetds-1.00.20.tar.gz./configure--prefix=/usr/local/freetds--with-tdsver=7.4--enable-msdbl

Label:Recently discovered Web sites are inaccessible because the database server disk has no more space left. The log file was found to be 70%, and shrinking the log file failed.The reason for the online lookup is that no backup cannot shrink the log file.A temporary solution:Back up the transaction log, and then shrink the log file. (You can also shrink a log file after a full database backup)A long-term solution:Make a maintenance plan, back up the

Key ConceptsConfiguration data compression can be implemented in both SSMS and T-SQL statements.Table and Index compressionFor row storage tables and indexes, using data compression can help reduce the size of the database. In addition to saving space, data compression can also help improve the performance of I/O-intensive workloads because the data is stored in fewer pages and queries require fewer pages to read from disk. However, when exchanging da

Original: SQL Server 2012 exception Issue (ii)--performance issues caused by installation mediaProblem Description: Production environment A database is upgraded from SQL Server R2 to SQL Serv