SQL Server

SQL Server Remote Login Server Management and query /* Data operations between databases on different servers */-- create a link to the server exec sp_add+server 'itsv', '', 'sqloledb ', 'remote server name or IP address 'exec

We can use set statistics Io and set statistics time to analyze the performance of T-SQL statements. The method is as follows: In the SQL Server Query analyzer, run: Set statistics profile onset statistics Io onset statistics time ongo --

Windows Server 2008 R2 en enterprise 64bitSQL Server 2008 R2 en enterprise 64bit Symptom: the performance counters related to SQL Server are not displayed in Performance Monitor. Solution: Rebuilding the counters:CD c: \ windows \

Introduction This seriesArticleIn the previous article, I gave an overview of what replication is. This article describes several common replication modes based on the organization and replication types of the Publishing Server, distribution server,

Categories: Database Problems Keywords: Date Correlation: Author: Unknown Source: xpilot's blog Reference: [0] Http://goaler.xicp.net/TrackBack.asp? Logid = 508 Text: [Large, medium, and small] [recommend this log to a Friend]

First, we should know that the database is always in a specific State. Next, let's take a look at three common statuses of the database: 1. Offline: we can see the database in Microsoft SQL Server Management, however, the database name is suffixed

Original http://database.51cto.com/art/201108/283240.htm SQL ServerAvailableLinked serverFunction to connect to other databases to perform operations between different databases. This topic describes how to use SQL Server to connect to a server.DB2

Some people often complain on forums, saying:SQL ServerToo much memory. Here I will give a brief introduction to memory-related tuning knowledge based on experience. First, describeSQL ServerWhich parts of memory is used.SQL ServerThe memory

Step 1: query using SQL statementsSelect @ versionThe query result is as follows:Microsoft SQL Server 2000-8.00.2039 (Intel x86)May 3 2005 23:18:38Copyright (c) 1988-2003 Microsoft CorporationPersonal Edition on Windows NT 5.1 (build 2600: Service

From: http://crm.xingfa.com/HelpDesk/Archiver.asp? Threadid = 8587 thanks to the author     2010-09-29 8:00:53 Let's take a simple look at how the SQL Server Index works. We will not talk about the index concepts.   Clustered index:

I hope to make a comprehensive summary of my recent work needs.SQL ServerPrecautions for database performance optimization: I searched the internet and found manyArticleSome of them list hundreds of entries, but you can see that there are a lot of

I. Preface: after a period of storage process development, I wrote some summary and experiences for development and shared them with you. I hope they will be helpful to you, it is mainly for Sybase and SQL Server databases, but other databases

The database publishing wizard enables the deployment of SQL Server 2005 databases (both schema and data) into a shared hosting environment on either a SQL Server 2000 or 2005 server. The tool supports two modes of deployment: It generates a

Note: SQL Server 2005 and later versions are supported. This version is estimated to be not supported (working environment ). To work, you need to add a new column to the existing SQL Server table and add a description. The stored procedure is as

With the joint efforts of the editorial team of MS-SQL server magazine and many netizens who care about the magazine,The "csdn Community Electronic Magazine -- MS-SQL server Magazine" was published successfully, now officially released! Let's

10. Create a database data tableDeployment of basic workBasic concepts of data tablesCreate a data table in the archive GroupUse nullAdd the identity attributeCreate a data table using Enterprise ManagerSummaryWhen the database is created (The

 SQL Server Performance Tuning entry (graphic version) Step 1: capture sample data during business peaks(About 2 hours ). The tool used is the profiler that comes with sqlserver, also known as the event probe. For example, after entering, click the

SQL Server 2000 sp2 12 Command overflow attack implementation Author: flashskyHome: http://www.xfocus.netDate: 2002-11-01 Note: Please indicate the author and security focus for reprinting.For the first study on overflow, please correct me. I have

Today, I suddenly want to take a closer look at awe, so I checked it on Microsoft's website and put it here by the way.Address Window Extensions (AWE) Allow 32-bit operating systems to access a large amount of memory. Awe is provided by the

To enable devices that have subscribed to databases to better contact each other Distributor,You must add a domain user to the database so that the device can access the publishing database with the user's permissions. OpenSQL ServerResource