SQL Server

Source: http://blog.csdn.net/dba_huangzj/article/details/37924127, Special 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 used for

As an MCT (Microsoft Certified Instructor), it is incumbent on me to popularize SQL Server technology.Based on years of teaching experience, we intend to publish a series of books through the 51CTO platform.SQL Server 2014 installation and

SQL Server to troubleshoot high CPU usageThis noon, a friend asked me to help him look at the database, the operating system is WINDOWS2008R2, the database is SQL2008R2 64-bit64G memory, 16-core CPUHardware configuration is still relatively high, he

SQL ServerExtended Event (Extended Events)--monitoring deadlock script implementation using extended event tracking--Create a new event session (it is better to Create a new session and not modify the system ' s built-in session "System_h Ealth "):

13.2.5 Deploying log shipping with T-SQL commandsSQL Server also provides the means to deploy log shipping as a T-SQL command. In the previous section, after you complete step (6) or (8), you can save the generated command script. The results of

What is a trace flag? For DBAs, mastering trace flag is one of the prerequisites for becoming a SQL Server whiz, and in most cases, trace flag is just a pifo of a sword walk, not necessary, but in many cases, using these tags will give you better

Here's how:One, enable remote connections for SQL Server 20051. Click Start, select Programs, choose Microsoft SQL Server 2005, configure tools, and then click SQL Server Surface Area configuration.2. On the SQL Server Surface Area Configuration

Anatomy of SQL Server article 11th automated testing of multiple versions of SQL Server (translated)http://improve.dk/automated-testing-of-orcamdf-against-multiple-sql-server-versions/Since I released Orcamdf Studio, I have realized the differences

SQL Server View we often use the following to introduce you to the advantages and disadvantages of using SQL Server view, you want to have more knowledge of your SQL Server view.You must understand the pros and cons of the view before you design it,

Perform the Full-text search query operation for SQL Server 2014 today: SELECT * FROM table where contains (summary, ' Smith ')Report the following error:MSG 30046, Level A, State 1, line 1SQL Server encountered error 0x8007042d while communicating

SQL Server Related BooksSQLSERVER2012 Implementation and Management GuideSQL Server 2008 Learning notes: Daily maintenance, in-depth management, performance optimizationSQL Server R2 Data Mining and business intelligence fundamentals and Advanced

Today to do a special business processing, with the JDBC connection SQL Server database load driver, reported the following error:Java.sql.SQLException: [Microsoft][sqlserver Driver for Jdbc]error establishing socket.at

As a result of previous needs, the replication schema change was forbidden, and a field was added to the publication and not synced to the subscription, and now a field with the same name was added to the subscription, so how do you make the two

Common SQL time Format the default date field for the Chinese version of SQL Server datetime format is yyyy-mm-DD Thh:mm:ss.mmm For example:Selectgetdate ()2004- the- A One: .:08.177This is used to transfer data between databases or to be

The reasons for the slow query are many, and the following are common:1. No index or index is not used;2, I/O throughput is small, forming a bottleneck effect;3, insufficient memory;4, the network speed is slow;5, the amount of data queried is too

Select GETDATE () as ' current date ',Datename (Year,getdate ()) as ' year ',Datename (Month,getdate ()) as ' month ',Datename (Day,getdate ()) as ' Day ',Datename (Dw,getdate ()) as ' Week ',Datename (Week,getdate ()) as ' Week number ',Datename

PS: Title is a bit long ...When you upgrade SQL Server R2 to SQL Server 2014, you encounter the following rule validation errors: Rs_validdatabaseversion Check that the version of the report server database can be used by a

SQL statement to query the SQL Server name and IP address, SQL Server Get Server Name: SELECT SERVERPROPERTY('MachineName')select @@SERVERNAMEselect HOST_NAME() To obtain the IP address, run the ipconfig command in xp_cmdshell: -- Enable

The most common solution for SQL Server data import and export is to import and export data. Currently, ASP and PHP are mainly used for website construction. The databases used in these two languages are SQL Server and mysql, respectively. These two

Execute SQL Server database backup and SQL database backup using Windows batch processing commands Create mybackup. bat and enter the following content to directly run the script to start automatic database backup. You can also add the script to the