SQL Server

In program development, we often have to do is to access the database. Sometimes you invoke stored procedures and DTS, and here's an example to illustrate how to implement The first part invokes the stored procedure (with the parameter and get the

Will soon start to do the computer room fee system, want to understand the function of the system must first understand the predecessors of the database. After getting the original database Charge_sys.mdf and charge_sys.ldf, you can't wait to attach

Myth #29: You can defragment the heap after you drop the heap by a clustered index NOOOOOOOOOOOOO!!! To heap a clustered index and drop it seems to me to be the top 2 in addition to shrinking the database. If you see fragments on the heap through

In the official blog of Microsoft Asia-Pacific Database Support Group, you will find that many articles use the Procmon.exe tool. Today I would also introduce this tool How big is the experiment based on this article, SQL Server, per log write? "

Since the replication of the thought can be a safe sleep, who do not know that the problem ensued The problem is to lose the packet , do not know the situation of the reader can first look at me before the "SQL Server monitoring replication and use

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

First, the preface ASP (Active server Pages) is a server-side scripting environment that is supported by Microsoft's IIS3.0 version. It can be used to create dynamic Web pages or build powerful Web applications. ASP pages are files that include

Microsoft's SQL Server is one of the most commonly used database management systems in small networks today. The application of this kind of network database is also increasing, the normal operation of this kind of network database application

Display information for all tables or views in a database in a SQL ServerThe difference between SQL Server 2000 and 2005 is in the Red Word sectionThe following statement takes all table information and replaces the green bold word "U" as "V" for

In our article on the SQL Server Security series, our goal is to provide you with the tools and confidence you need to securely install your SQL Server, so that your valuable data is protected from unintentional or intentional sabotage or theft. In

In the use of the process, we often encounter a very large database log, here are two ways to deal with ... Method One In general, the contraction of the SQL database does not greatly reduce the size of the database, its primary role is to shrink

Problem Database backup and maintenance windows for large databases are always blocked, especially when we need a full database backup to initialize a database mirror or transaction log shipping session. When we browsed the new features of SQL

In fact, these two types of the largest research point is the difference in the index. Now I write down one of my discoveries when I use SQL Server2008. (Note: This discussion does not establish any full-text indexing) Usually we think like '%

One. " SQL Server does not exist or access is denied " This is the most complex, the cause of the error is more, need to check the aspect also more. Generally speaking, there are several possibilities: 1,sql server name or IP address is spelled

Windows functions in SQL Server 2005 (window function) are not related to Microsoft Windows; Instead, they create data windows. Window functions help you quickly look at different levels of aggregation, which make it easy to recover cumulative

When we develop business software, we often encounter the question of how to prevent users from repeatedly logging on to our system. Especially for the bank or the financial department, but also to restrict the user as its work number of multiple

Same point: Truncate and delete with no WHERE clause, and drop deletes data in the table Different points: 1. Truncate and delete Delete only the data do not delete the structure of the table (definition) The DROP statement deletes the table's

Based on good database design, efficient use of indexes is the basis for SQL Server to achieve high performance, SQL Server employs a cost-based optimization model, which queries each submitted table, determines whether to use the index or the index.

Based on good database design, efficient use of indexes is the basis for SQL Server to achieve high performance, SQL Server employs a cost-based optimization model, which queries each submitted table, determines whether to use the index or the index.

1. Go to heavy distinct , group bySelect distinct from table nameSelect from Group by Userid,username2. Go to space replace LTrim RTrim replace (Name, " , " ) Select LTrim (' test ') -- remove left blank Selectrtrim (' test ')