SQL Server

Databases often need to be migrated in projects. The management studio script generation tool only obtains the schema of the database. (Fortunately, there are many third-party tools on the Internet. I would like to recommend one to you: the SQL

The SQL Server compact development team has just released a white paper comparing express and compact versions. In fact, this White Paper does not focus on the comparison between the two versions, but reviews the local data storage needs. As a data

Some time ago, I saw some friends in the garden discussing the paging select problem of SQL Server. I felt that some friends may not be clear about some aspects of SQL Server (version 2000 or later, here, we will share some special processing

To delete all rows in a table, the truncate TABLE statement is a fast and non-logged method. The truncate table function is the same as the delete statement without the WHERE clause. However, truncate table is faster and uses fewer system resources

Select 'insert into t_functions (syscode, funcode, funright, parentcode, funindex, funfile, funtype, picturepath, remark) values (', ''' + Syscode + ''', ', ''' + funcode + ''',', ''' + funcode + ''',', ''' + funname + ''', ', ''' + isnull

Preface: This articleArticleI need you to have a certain understanding of the index and SQL data storage methods. The title of the two words is only because this article requires my T-SQL advanced series of articles some content as the basis.

SQL Server's use of Indexes Filter is often used to filter out some records when writing SQL statements) 1 WhereAmount>4000 AndAmount6000 The above statement is the filtering condition. Of course, this does not mean the SQL server where

SQL Server Data Page Structure In the forum, I often asked how sqlserver stores basic table data. Since I don't want to check msdn, I 'd like to talk about it here. The basic table data is stored on the data page. The data stored by sqlserver is

SQL Server System Optimization-optimizing indexes through execution plans (1) A few days ago, when I moved away from Shanghai to Wenzhou, the customer's processing system was slow.Normal down 7 timesThere are a large number of online staff, and the

[CCID news] If SQL server does not frequently access tempdb, tempdb will not affect the database. On the contrary, if the access is frequent, loading will increase, the performance of tempdb will have an important impact on the entire database. it

Source: http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p1.aspx Turn: http://blog.csdn.net/xiao_hn     To analyze the performance of a query, you can view the execution plan of the query in one of the best ways. The

I checked my bookmarks on the Internet tonight. The use of non-clustered indexes uses bookmarks to find bookmark Lookup Clustered index does not use bookmarks for search My understanding: Clustered index: place the content in the book into the

I am ashamed to say that I have been working for almost four years. I was not aware of the importance of parameterized query until I was visited by the DBA a few days ago to optimize a complicated SQL statement with a high CPU usage. I believe

Recently it seems to be busy. I suddenly found that I have been writing a blog for a long time... Continued the previous article on creating a reasonable index for SQL Server query performance optimization (previous article) Database indexes are

The columns and stored procedure parameters of Microsoft SQL Server 2000 data tables are of the type, but I found that many parameter types can be "mixed" when writing stored procedures, for example, the following stored procedure: /**/ /*Name:

This articleArticleThis section describes how to access a local database from a device. You can use sqlceresultset to access the database faster and more effectively.   Database Access is performed by using data sources. dataset and

SQL Server compact 3.5 beta2 and synchronization services for ADO. NET are included in Visual Studio 2008 beta2 released last week. They will be installed on your computer along with Visual Studio 2008 beta2. However, due to the progress, Visual

RDAImplementationSQL CEAndSQL ServerInter-Data Access PPC ProgramAnd Desktop PC Currently, there are two programming methods for communication, 1 , Utilization Socket Programming and desktop program communication; 2 , Utilization RDA

Original article address:Http://database.51cto.com/art/200512/12923.htm Creating a web application requires paging. This problem is very common in database processing. The typical data paging method is the ADO record set paging method, that is,

Document directory Step 1: Step 2: Step 3: Step 4 Step 5 Step 6 References Principles and experiments of SQL Kerberos Install SQL Server native client and sqlcmd separatelyPreface In the previous blog on the principles and experiment of SQL