SQL Server

Perhaps the most common mistake found in the application code is such a query request: instead of using a prepared query or program, instead of requesting data from the database using a nonparametric ad hoc query. Not preparing your query or not

The pivot and Unpivot relational operators are the new features provided by SQL Server 2005, so when you use pivot and UNPIVOT for databases that are upgraded to SQL Server 2005, the compatibility level of the database must be set to 90 (you can use

Null values are encountered by all database developers and administrators. Therefore, to develop successful applications, you must know how to handle these values. This article shares with you some of the techniques and techniques of null-value

Use the SQL Server adjuster (SQL Server Profiler) tool to collect important information about the current activity of the server. The information tracked by this profiler tool, which contains the real load of the database, can be used on a variety

Add the dump device to the location where SQL Server backs up the database. In the SEM the storage equipment is visible, and the information on the device is stored in the Sysdevice table of the primary database. SysAdmin and Diskadmin server

BCP is a command-line tool in SQL Server that is responsible for importing exported data, is based on db-library, and can efficiently import and export large quantities of data in a parallel manner. This article describes how to import export data

One, what is log shipping? The principle is simple, three actions six words: Backup-> replication-> recovery. If a person completes this three action, it can only be called a log porter, and the SQL Server job completes automatically, called Log

The essential reason for a database to block (Blocking) is that the SQL statement holds the lock for too long, too many, and has a large amount of time. Blocking is a side effect of transaction isolation, it is unavoidable, and is a common

DROP TABLE t_test CREATE TABLE t_test ( ID INT IDENTITY PRIMARY key,status BIT ) INSERT into T_test SELECT 0 Go 100000 INSERT to t_test SELECT 1 CREATE INDEX ixf_t_test_status on T_test (STATUS) WHERE Status=1 U Pdate STATISTICS t_test with

SQL Server table data Copy to Excel (method) 1, the new query, using SQL statements to read the table data 2, then, select data, right button, copy (also can be clicked along with the title copy) 3, paste in Excel can be. Second, Excel copy to

Server virtualization has been done more and more mature and universal, whether it is xenserver or esx or Hyper-V, in fact, as I have contacted customers, most people's inertia thinking is that Hyper-V is based on the operating system level, not as

SQL Server Lock: 1.HOLDLOCK: Keep the shared lock on the table until the entire transaction ends, rather than immediately releasing the added lock after the statement has been executed. 2. NOLOCK: Do not add shared and exclusive locks, when this

You can start the installation process for SQL Server 2008 RC0 by selecting the Install option in the SQL Server 2008 RC0 Installation Center and then choosing to install a standalone instance. Setup will first perform some installation

My current project includes a table with 62 million rows and more than 500 columns. Where the data comes from outside of SQL Server, they arrive in a table that identifies the primary key, and all remaining columns are saved in varchar (50).

This article explores the benefits of access and the SQL Server consolidation process and provides links to more in-depth analysis and migration processes ... Microsoft access is a simple, easy-to-use development tool that can write access programs

Directory Prepare for Work 1 Exercise: Using HierarchyID data type 2 Preparatory work Estimated time required to complete this experiment 40 minutes. Goal After completing this experiment, you will be able to: Handling hierarchical ID data

Why should I back up the database? In the real it world, we use the server hardware may be because of the use of too long time, and failure; Windows family servers may be blue-screen or infected, and SQL Server databases may stop running because

A,B bidirectional replication as a model with two replication servers SQL Server replication is divided into three categories: 1. Snapshot replication A to delete all the data from the corresponding table in B at intervals, and then Insert all

Principles of SQL statement optimization: 1, use the index to traverse the table faster The index established by default is not a clustered index, but sometimes it is not optimal. Under a non-clustered index, data is physically stored randomly on

14.2.1 SQL Server logins using SQL Enterprise Manager In SQL Server, perform the following steps through SQL Server Enterprise Manager to manage SQL Server logins: (1) Start SQL Server Enterprise Manager and click the ' + ' flag next to the login