SQL Server

1. New Linked server In Figure 1, select "Linked Server" and right click "New Linked Server", as shown in Figure 2, to configure the relevant parameters. 2, configure the relevant parameters In the General option, fill in the link server name,

Problem background: When you work with a SQL Server 2005 relational database on a day-to-day basis, there are times when the database, such as the SharePoint site metabase name Sharepoint_config, is not functioning as if the database stopped the

This article describes how the go language accesses a SQL Server database through ODBC. Share to everyone for your reference. Specifically as follows: Here you need to use the GO-ODBC library, the Open source address is: HTTPS://GITHUB.COM/WEIGJ/GO-

IIS log format By default is TXT, check up very inconvenient, I really lazy look, find some information on the internet to look at, It is more convenient to query the log in SQL Server. 1 Establish an IIS database, add the Inetadmin user, specify

Direct access to database by JDBC driverAdvantages: 100% Java, Fast and Cross-platformDisadvantage: Access to different databases requires the download of a dedicated JDBC driver (1) Download the corresponding database version of the JDBC driver

There are a lot of tutorials about SQL optimization on the web, but it's messy. Recently have time to tidy up a bit, write to share with you, where there are errors and deficiencies, but also please correct the supplementary. Considerations for

The following are two ways to configure the SQL Server database recovery model. Set recovery mode with T-SQLYou can modify the recovery mode of the database by using the "ALTER database" command plus the "SET RECOVERY" statement. For example, the

This article through the illustrated way to show you the SQL Server database table records only keep the N-day text tutorial, concrete method steps please see below: First step: Set up the SQL Server Agent service to start automatically: Start-->

You can create a procedure for permanent use, or for temporary use in a session (local temporary procedures), or for temporary use in all sessions (global temporary procedures). You can also create stored procedures that run automatically when

SQL Server tempdb allocation Competition is a problem for DBAs, and almost all DBAs now know how to build several more files to solve Mitigate the problem. But deep competition is still inevitable. Here's to you. The characteristics of downstream

--Create, delete temporary tables --The first way create TABLE #tmp (name varchar (255), id int)- -The second way select COUNT (id) as Storynum, sum (convert (Numeric (10,2), Case if IsNumeric (code) =1 then code else 0 end)) As

Like what: SELECT * FROM table1 where name= ' Zhangsan ' and TID > 10000 and implementation: SELECT * FROM table1 where TID > 10000 and name= ' Zhangsan ' Some people do not know the execution efficiency of the above two statements is the same,

With the growth of time, the company's database will be more and more, query speed will be more and more slow. Open the database to see hundreds of thousands of of data, the query is inevitable not waste time. To improve SQL query effectiveness,

SQL Server 2005 has a read-only error attaching the database file, when attached, the system prompts the MDF file as read-only, but opens the file properties, this property is not read-only. How to solve it? This article we have introduced this

SQL Server is a relational database management system, the application is very extensive, in the process of SQL Server database operations will inevitably occur mistakenly deleted or other reasons caused by log damage, and because of the importance

The optimization scheme of SQL Server Multi-table query is the main content of this article, we give the optimization scheme and specific optimization examples, then let us take a look at this part of the content. 1. Execution path This feature of

In this article we have summarized several solutions to common problems in installing SQL Server databases for beginners to learn, so let's take a look. FAQ One: When you install SQL Server 2000, "a previous program created a pending file

The suspect_pages table is in the msdb database and is introduced in SQL Server 2005. Suspect_pages for maintaining information about suspicious pages The database administrator is responsible for managing the tables (mainly by deleting the old

How to view disk I/O operation information The SET STATISTICS IO on command is a message that enables SQL Server to display information about the amount of disk activity generated by Transact-SQL statements. We can be very useful when analyzing

A friend has a rebuild index job execution generally stops and asks me if I can see which index has been rebuild. It was thought that Sys.index or sys.objects would store similar information and the results were not found.On the Internet, SQL Server