SQL Server

The original database name is AA, the physical file name is called Aa.mdf and aa_log.ldf; you need to modify the database name to BB, the physical file name is called Bb.mdf and Bb_log.ldf; procedure (take the sqlserver2005 operation as an example):

ObjectivePrevious articles we introduced how to view the query plan, the introduction of common operators, the way of parallel operations, interested can click to view.This article will analyze in SQL Server, how to use the first indexed items for

ObjectiveIn the previous article we described how to view the parallel running of a query plan.In this article we then analyze the parallel operations of SQL Server.Gossip less, directly into the topic of this article.Technical preparationAs in the

1 PackageOrg.warnier.zhang.jdbc;2 3 Importjava.sql.Connection;4 ImportJava.sql.DriverManager;5 ImportJava.sql.ResultSet;6 ImportJava.sql.ResultSetMetaData;7 Importjava.sql.SQLException;8 Importjava.sql.Statement;9 Ten Public classSqlservertest {

Original: SQL Server Tuning Series Basics (Summary of common operators)ObjectiveIn the previous article we looked at how to view the query plan, this article will introduce the analysis techniques in the query plan we looked at, as well as several

SQL Server Whitepaper5 Tips for a Smooth SSIS Upgrade to SQL ServerAlwaysOn AG OS UpgradeBuilding a high availability and disaster Recovery solution using AlwaysOn availability GroupsBuilding_a_ha_and_dr_solution_using_alwayson_sql_fcis_and_ags v1

List all table Structures first:--title report--table collected water fee: hx_t_received--field charge Department Id:hx_fdepartmentid 1, Charge department Name: Hx_fdepartmentname should collect water charges information id:hx_ freceivableid--Charge

The SQL Server database is installed with 4 default system databases: Master, model, msdb, tempdb.SELECT [name] , database_id , suser_sname as[owner] , Create_date , User_access_desc , State_descfrom sys.databases WHERE4;MasterThe

First of all, I am just a programmer, not a professional DBA, the following article is written from a problem solving process, rather than the beginning to give you a correct result, if there is something wrong in the text, please correct the

SQL Server Ring Buffer--deep understanding of ring buffer CONNECTIVITYFirst we start with the XML returned from the connected ring buffer data.SELECT CAST (record as XML) as Record_datafrom sys.dm_os_ring_bufferswhere ring_buffer_type= ' ring_buffer_

SQL Server Ring buffer--ring_buffer_exception trace ExceptionDynamic management view Sys.dm_os_ring_buffers makes it easier to locate problems in real time. The ring buffer contains a large number of events that occur on the server. Currently, I am

SQL Server Ring buffer--Ring_buffer_memory_broker diagnosing internal memory pressureMemory BrokerThe responsibility of memory broker is to allocate memory between large memory consumers based on their requirements. Memory Broker is a sqlos

Looking at the operation log in SQL Server has always been a hassle, because Microsoft has not provided direct system tools to view the log content, although it is possible to get the non-parsed encoding of the log through the unofficial hidden

To learn SQL Server to install it first, but many friends in the process of installation, always encounter such a problem, and finally lead to installation failure, the most hateful is the prompt "installation completed but failed", too hateful! I

Whether in sqlcmd or in C # logic, or directly in SQL Server, a personal summary can be which comes for either of these ways: 1,ssis;2,oledb Drive engine. SSIS really works, and now it's not going to be discussed here. Most of them use the second

Original: Deletes all indexes of the specified table, including primary key index, unique index, and normal index, for SQL Server 2005,--Delete all indexes in the specified table--usage: DECLARE @tableName varchar--set @tableName = ' table name

How SQL Server 2008 Copy database:Method One: Use the Copy Database Wizard in Microsoft SQL Server Management Studio to assist with completion. (very easy to fail)Method Two: Adopt the way of Backup/restore (recommended)A. Backing up a database to

Original: SQL Server index and table Architecture (nonclustered index)Nonclustered indexesOverviewfor nonclustered indexes, the information involved is a bit more than the clustered index, because the entire length of the page is much more involved

Introduction The partition table is the feature introduced in the version after SQL SERVER2005. This feature allows a logical table to be physically divided into many parts. For the previous version of SQL SERVER2005, the so-called partitioned

C # synchronizes data in a SQL Server database 1. Write a SQL processing class first:Using system;using system.collections.generic;using system.data;using system.data.sqlclient;using System.Text; Namespace Pinkdatabasesync{class