SQL Server

How do I downgrade a SQL Server database from a higher version to a lower version?Due to the widespread use of SQLServer2000, many companies also want to use the new SQL Server to directly "detach/Attach" or "Backup/restore" the database to be

Text: Third--Part II--the second article plan to build SQL Server mirroringThis article follows the previous chapter: Introduction to SQL Server mirroringThe source of this article: http://blog.csdn.net/dba_huangzj/article/details/27203053As the

Select Name,salespersonid from Sales.Store where Name between ' G ' and ' J ' and SalesPersonID > 283 ORDER by Sal Espersonid,name DESC/ASCThe use of the between of this statement is still very innovative, this between is the beginning of G and J

There are two types of SQL Server authentication, one is Windows authentication, and the other is SQL Server authenticationWindows Authentication Connection string:string connectionString = "data source=localhost;database= database

Two days ago we learned some of the most basic database-related knowledge, starting today, we have shallow to deep learning database knowledge, for our future work to lay a solid foundation, for you Yimeimei can see clearly I want to express the

Use masterRESTORE DATABASE wss_content from DISK = N ' D:\bak\contentbak.bak 'With REPLACE, NORECOVERY, MOVE ' wss_content ' to N ' D:\bak3\WSS_Content.mdf ', MOVE ' Wss_content_log ' to N ' D:\bak3\WSS_Content_log.ldf 'The move ' WSS_Content ' is

Because of hobbies, decided to start self-learning SQL Server Tutorial today, to record the daily learning situation, so as to spur themselves. Well, the nonsense is not much to say, the following for today to learn the content:SQL Server is a

This article is based on the previous "SQL Server 2012 alwayson--specified data synchronization link, eliminate network jitter caused by the submission delay problem" problem continue to optimize, the specific background please refer to the above;

relational databases, such as SQL Server, use locks to avoid concurrency conflicts when multiple users modify data. When a set of data is locked by a user, other users cannot modify the group's data unless the first user finishes modifying and

WORKAROUND: 1 Login as Administrator 2 Locate the Oracle_home folder (D:\oracle\ora92), right-click, select Properties--Secure, select "Authenticated Users" in the group or user bar, and remove the "read and run" permission from the permissions.

2015-01-26In software development, it often involves the data structure and the import and export of data between different databases (including different versions of different products). There are a lot of problems in the process, especially the

1. DescriptionSQL Server2008 itself has regular automatic backup capabilities, and we only need simple configuration to enable very simple and efficient automatic backup.2. Open the SQL Server Agent serviceTo implement the automatic backup feature,

Although the query speed is a lot of reasons, but if through a certain optimization, you can also make the query problem to a certain extent to be resolved.The reasons for the slow query are many, and the following are common: No index or

Although the query speed is a lot of reasons, but if through a certain optimization, you can also make the query problem to a certain extent to be resolved.The reasons for the slow query are many, and the following are common: No index or

The default in SQL statements is case-insensitive, so the statement:SQL codeSELECT * from recenginebizinfo WHERE recenginebizname = ' QQ 'AndSQL codeSELECT * from recenginebizinfo WHERE recenginebizname = ' QQ 'The results are the same.The script to

Approximate steps:A. Create an auditB. Create an audit to access a database table - to monitor a user's access to a specified database tableC. Test Auditing features - Use login account Allen Accessing database Tables CustomersD. Use T-SQL function

SQL Server DDL triggers (Trigger)-Create a server-level DDL triggerIf you create a server-level DDL trigger, you can track server-level events by changing the previous on database to the on all server, using the same principle as the DDL triggers at

Original: SQL Server Tuning Series Basics (Union operator summary)ObjectiveIn the last two articles, we describe how to view the query plan, and some of the common optimization techniques for join operators, and we summarize how the federated

Original: SQL Server Tuning Series BasicsObjectiveAbout SQL Server Tuning series is a huge content system, not a word two words can be analyzed clearly, this article first in the SQL tuning in the most commonly used query plan to parse, to do a good

　　Opened Blog Park has been a period of time, has not written a blog, one is busy work, second, has been thinking about how to write a blog, the third is the knowledge technology is not home, dare not write fraught ah. At first I was thinking about