SQL Server

1. Enter the Conf folder directory in the Tomcat directory, find Server.xml In Tomcat's Server.xml file, in the tag and tab, negotiate the connection statement, in the following format debug= "5" reloadable= "true" crosscontext= "true"

Begin SQL Server views Posted by Scott on November 28, 2004 An RDBMS uses a view to create a virtual table. The careful use the views can improve the interaction between a. NET application and the underlying data. In this article we'll discuss views

For SQL Server 2000来, it provides two new functions (ident_current,scope_identity) and improves the @ @IDENTITY. When you insert a new record, you can call the function: PRINT ident_current (' table ') ' This will get the new identity value,

Source: Tomorrow go begging ' s Blog The previous time in testing more than 1 million data paging speed, need to insert 1 million records into the database, at that time inserted record I was written in C #, and later found that, in fact, with the

Recently, in order to be able to run other applications in the database server, the database server has been upgraded on a soft and hardware basis without changing the database operating system version. On the software, upgrade the operating system

A stored procedure that provides this type of recovery in SQL Server. A database consists of two files, MDF database files and LDF log files 1.sp_attach_db [@dbname =] ' dbname ', [@filename1 =] ' Filename_n ' Add a database to the system, specify

Recently a friend asked me, he said that he deleted millions of to tens of millions of data in SQL Server is very slow, to help him analyze, some of the following comments, perhaps useful for many people, and also good long did not write a blog,

When you suspect that your computer hardware is the primary reason for the performance impact of SQL Server running, you can monitor the load of the appropriate hardware through SQL Server Performance Monitor to confirm your guesses and identify

There are several tools in SQL Server that allow you to detect, tune, and optimize SQL Server performance. In this article, I'll show you how to use SQL Server's tools to optimize the usage of database indexes, and this article also involves general

Cause analysisIt may be because many servers are not restarted or the database causes the sqlserveragent and mssqlserver services to occupy a large amount of memory. You can simply restart the server.,Use the task plan to regularly execute the

We all know that using the aggregate function count () can calculate the number of rows in the table. To count the number of rows of each table in the database (DBA may have this requirement), use the count () function to generate a dynamic SQL

Official reference: http://msdn.microsoft.com/en-us/library/ms187103.aspxOverviewSQL Server uses log transmission, you can automatically back up transaction logs in the "primary database" on the "primary server" instance to one or more "secondary

The code is as follows:Copy code Use tempdbGoIf object_id ('Table _ left') is not null drop table table_leftIf object_id ('Table _ right') is not null drop table table_rightGoCreate table table_left (groupId nvarchar (5), dataSub1 nvarchar (10),

There are several constraints:Not null: the content used to control fields must NOT be NULL ).UNIQUE: The control field content cannot be repeated. A table can have multiple Unique constraints.Primary key: it is also used to control the content of

Let's look at the vocabulary method first The code is as follows:Copy code CONVERT (data_type (length), data_to_be_converted, style) Example 1 The code is as follows:Copy code Select convert (varchar (30), getdate (), 101) now Result:Now---

Maintenance plan1. Create a maintenance plan, name it 'DB _ bak', and select the 'backup database' task from the toolbar,2. Select the database, Expiration Time, and backup directory on the properties page. Here I select a partition on the network

Wondering where SQL Server 7.0 is better than SQL Server 6.5 or than other enterprise-level database systems? Read SQLServer 7.0 industrial standard Benchmark scores and performance indicators recorded.I. Industrial standardsThe ideal method for

Method 1In general, the contraction of the SQL database does not greatly reduce the size of the database. Its main function is to shrink the log size. This operation should be performed regularly to avoid excessive database logs.1. Set Database mode

In fact, you only need to use the built-in storage process sp_spaceused to obtain table-related information.For example, sp_spaceused 'tablename'The following is a stored procedure for writing convenience. The purpose is to store all the information

If the SQL SERVER running on S fails to be registered on C, the applications that need to access S on C may not be connected to the database.You can try "\" to access S on C first. For example, enter "\ 192.168.0.1D $" in the address bar of C, enter