SQL Server

10 threads operate at the same time, and frequent problems with inserting the same data occur. Although it is used when inserting data:Insert Inti tablename (Fields ...)Select @t1, @t2, @t3 from TableName where isn't exists (select ID from

Original link: http://www.sqlserver.com.cnWe do the management software, the main core is in the data storage management. So database design is our priority. To enable our management software to be stable, scalable, excellent performance, traceable

delphi Connection string for SQL Server 2011-10-11 16:07First, Delphi connect SQL ServerPut a connection component adoconnection, the other components tadodataset,tadoquery, such as connection point to adoconnection on it.You can double-click the

Starting with the version of SQL Server 2012, the Backup and restore options for the database are changed in the following 2 details.First, configure the database settings in the server (instance)SQL Server 2012 has one more item on the Database

This Monday night, received a database mirroring suspend and synchronizing state to switch back and forth the alarm, see this error, in fact, quite common.Our repair steps are generally as follows:1. ALTER DATABASE * * * SET PARTNER RESUMEIf this

Many times, the performance bottleneck of our server will be when querying the database, so it is very important to cache the database, then there is no way to implement the SQL Server database cache, when the data table is not updated, read from

ObjectiveIn the last two articles, we describe how to view the query plan, and some of the common optimization techniques for join operators, and we summarize how the federated operators are used and how to optimize them.Talk less and go straight to

This month the head office acquired a small company, the small company's database with 32-bit Sql2000, has been used for a long time, the system is relatively stable. In line with the principle of cost-saving, the head office retains the original

Transferred from: http://www.cnblogs.com/MR_ke/archive/2010/08/25/1807856.htmlSQL 2005 Performance TuningSQL Server runs for a period of time, and as data accumulates, SQL runs less efficiently, and in order to use business system normal actions, IT

Add Database login account and grant database owner permissions in SQL Server UseMasterGO--Create a login from sp_addlogin--DEMO: Login account--123456: Login PasswordExecuteSp_addlogin'DEMO','123456'--Switch Database UsedbtestGo--Create a

The 1:c# code is SqlConnection connnew = null; Connnew = new SqlConnection (@ "Data source=" XXX "); Connnew.open (); SqlCommand commnew =

Workarounds for SQL Server Profiler cannot be paused and stoppedAlthough SQL Server Profiler works well, there is an issue where you cannot pause and stop after you start profiler on the local database (locally) (Once you pause or stop for a long

Case Environment:Operating system version: Windows Server R2 StandardDatabase version: SQL SERVER SP2Case Description:The following error message appears when you enter the Reporting Service management interface for a newly installed SQL Server

October 13, 2010 12:46 Source: Ministry of Matsumasa's blog Department Matsumasa Editor: Huminya　　A: Below with AdventureWorks2008 for the sample database to do a brief description , filter out the general database of shared locks, as an example

Do project database file more than 200G, search the method of compressing data log everywhere, but a lot of log file's physical size has not changed, execute the following script can change the physical file size, the formal production environment

I. How SQL Server Profiler is used1. Click Start-Program--microsoft SQL Server 2005--Performance tool--sql Server Profiler, such as:2. Pop up the SQL Server Profiler window, such as:3. In the Work window, click "File---" New trace (N) ... "", Pop Up

My Russian name is "do not toss uncomfortable", so, do not put the partition table A good toss, I am not comfortable.In the previous section, we discussed how to create a partitioned table directly and how to convert a normal table into a

After you have created the partitioned table, you can insert data directly into the partitioned table instead of the physical data table in which the data is placed. In the next article, we insert several data into the created partition table:As can

SQL Server Performance Analysis-deadlock detection database blocking statementsWork in the database often appear in memory, found an articleRefer to Csdn, China Wind (Roy) A deadlock article block: One of the transactions is blocked, other

Uncover new features of SQL Server 2014 (3)-updatable column storage clustered index, Introduction The column storage index actually exists in SQL Server 2012, but SQL Server 2012 only allows the creation of non-clustered column indexes, this means