SQL Server

Two days ago, I made a very serious mistake. When I was observing the SQL Server database time, due to the adjustment of the service, I accidentally restarted the SQL Server service. Maybe everyone felt this was okay, however, for an online DB that

In daily SQL Server development, identity columns of the Identity type are often used as the auto-increment numbers of a table structure. For exampleArticleNumber, record number, and so on. The reference of the Self-increasing ID column greatly

Since SQL server2005, a new data type XML type is provided, which allows you to directly store data in a data table in the format of an XML file. In combination with the use of LINQ to SQL in ASP. NET, we can easily store XML files in the SQL Server

This afternoon I recorded a SQL Server compact application.ProgramThe Quick Start video helps friends in the garden open the door for SQL Server compact development. Technical Level: 100Prerequisites: Visual Studio 2005, SQL Server 2005 mobile

For the sqlserverexpress database connection configuration, I have seen it several times before. I have seen it again in an open-source software this morning. I feel it is necessary to have a clear understanding of it, example: "Data Source =. \

Failure where SQL Server cannot be started-[Error 1069 service cannot be started due to login failure] -- Has the operating system password been changed? -- Solve the problem that SQL cannot be started due to changing the operating system password:

Original address in http://7622.com/list/58278.htm Sometimes you may not be able to open the favorite address in the future, so I will add the original article to my favorites. Create a table: Create Table [testtable] ([ID] [int] identity (1, 1)

Importance of clustered index and how to select clustered Index In the title of the previous section, I wrote: The general paging display stored process for small data volumes and massive data. This is because when we apply this stored procedure

In sqlserver, a simple combination of sp_spaceused and sp_msforeachtable stored procedures can easily calculate the size of the user data table, including the total number of records and space usage, which is very practical, both sqlserver2k and

By Joshy George Introduction It is a sample C # (vs2005) application for automatic SQL Server backup utility using SQLSERVERAGENT. ihave used SQL-DMO DLL. this article will show you how to create a automatic backup in SQL Server 2000. This

Error 5173 in SQL Server database Yesterday, my colleague gave you a problematic database and asked me to fix it because the customer needed this database. This database only has one MDF file and one LDF file, When I attach a database, an error

Log4net: use SQL Server to log your application events By Emanuele 2/23/2008 2:26:00 In the previous article on the log4net configuration, I explain how to configure log4net with the file appender.In this article I explain how to configure

We often use a variety of date formats for some purpose. Of course, we can use string operations to construct various date formats, but why are there any ready-made functions? The default datetime format of the Chinese version of SQL Server is

Create Table # Data (name Varchar ( 100 ), Row Varchar ( 100 ), Reserved Varchar ( 100 ), Data Varchar ( 100 ), Index_size Varchar ( 100 ), UnusedVarchar ( 100 )) Declare @ Name Varchar ( 100 ) Declare Cur Cursor For Select Name

ForSQL ServerThe management of backup files is very exquisite, especially when the disk space is notLarge orDBIt is really difficult for administrators with too many servers. At the same time, it is also important, because if the disk is cleared

The SQL Server service is not set to automatic on your development machine, because it occupies too much memory and affects the startup time. Every time I use SQL Server, I have to go to the control panel of windows to open the service, which

You can customize the transaction isolation level based on your SQL Server, which will meet your requirements or improve performance. For example, for SQL Server with simple logic, you can use the read uncommitted mode to reduce deadlocks, reduce

Use Database Replication Technology to synchronize data updates Concept of Replication Replication is a technology that copies a set of data from one data source to multiple data sources. It is an effective way to publish a set of data to multiple

Search for the article content from the Internet and sort it out.(1) Char, varchar, text and nchar, nvarchar, ntextChar and varchar are both between 1 and 8000 characters in length. The difference is that char is a fixed-length character data while

In SQL Server, apart from manual deletion of tables with more than a dozen records, deleting duplicate records usually involves writing a piece of code and performing a row-by-row check using the cursor method, delete duplicate records. Because this