SQL Server

Some may ask, How do I clear the list of Connected Server names in SQL Server? After the experiment, we found the solution:DeleteX: \ Documents and Settings \ XXX \ Application Data \ Microsoft SQL Server \ 100 \ tools \ shell \ sqlstudio.

  Normally SQL When the number of data items in a query statement is small, the speed will be slower, because it takes a lot of time to transmit a large amount of data over the network. If you query data by PAGE, only useful data is returned.

RelatedArticleNavigation SQL server2005 Transact-SQL new weapon learning Summary-Summary Index of flex and fms3 articles Flexair open-source edition-global free multi-person video chat room, free network remote multi-person Video

Event: I encountered a very strange problem: I opened a table in a database in the sqlserver Enterprise Manager, modified the record, and shut down the table, and the prompt "transactions cannot be started in streamline mode" is displayed ", data

You can use the file_name function to return the logical File Name of the specified file ID. As follows: In the following example, the file name (master database file) with file_id 1 is returned ). Use Master Select   File_name ( 1

The database was supposed to be completed this evening, but it was found that there was an error connecting other computers in the LAN with vs2005. At the beginning, the response may be a firewall problem, the firewall is shut down. Later, I spent a

-- SQL Server 200 Select a. Name as field name, case when exists(Select 1From sysobjectsWhere xtype = 'pk' and parent_obj = A. ID and name in(Select nameFrom sysindexesWhere indid in(Select indidFrom sysindexkeysWhere id = A. ID and colid = A.

SQL Server 2000 You can add field descriptions in the Enterprise Manager, or use the followingCode: Exec Sp_addextendedproperty ' Ms_description ' , ' Some description ' , ' User ' ,DBO, ' Table ' ,Table_name, '

-- Method 0: dynamic SQLDeclare @ s varchar (100), @ SQL varchar (1000)Set @ s = '1, 2, 3, 4, 5, 6, 7, 8, 9, 10'Set @ SQL = 'select Col = ''' + Replace (@ s, ',', ''' Union all select ''') + ''''Print @ SQLExec (@ SQL)   If exists (select * From

Before setting and using database replication in SQL Server 2000, check whether the following SQL Server servers meet the requirements: 1. Does the MSSQLserver and Sqlserveragent services start and run as domain users (. \ administrator users can

USE pubsGODECLARE @ name varchar (40)DECLARE @ SQL VARCHAR (4000)DECLARE authors_cursor CURSORSELECT Name as table Name FROM SYSOBJECTSWhere xtype = 'U' OPEN authors_cursor Fetch next from authors_cursorINTO @ NAMESET @ SQL = 'select' + @ NAME + ''

If the ldf file of the database is lost or damaged, the Database loading fails. Check SQL Server Management> SQL Server Logs to see that ldf loading fails.   1. view the database status Select * from sys. databases The state_desc of the

Recently, an old system switched to SQL Server 2005 database and changed from 2000 to 2005. By default, an error occurs during startup: Incorrect syntax near 'index'. If this is intended as a part of a table hint, a with keyword and parenthesis are

The Real-time Data Validity determination rule of INSQL requires a flexible definition. I use the standard SQL expression to define the rule in the string mode, and parse and output the result through the stored procedure to determine the result.

Save: private void btnSave_Click (object sender, System. EventArgs e) { FileStream stream = null; SqlConnection conn = null; SqlCommand cmd = null; Try { RichTextBox1.SaveFile ("temp. rtf "); Stream = new FileStream ("temp. rtf", FileMode. Open,

(1) ● There are many reasons for slow query speed. The following are common causes: 1. No index or no index is used (this is the most common problem of slow query and is a defect in programming)2. Low I/O throughput, resulting in a bottleneck effect.

When I read an article about SQL puzzles-36: dual responsibility, I downloaded the second version of SQL puzzles. By default, the group by processing between SQL server and mysql is different. In SQL server, the field in the select list is either a

In the previous article, we used several methods to identify the bottleneck and find the bottleneck. Next, let's review it: LoadRunner stress test + Windows counter. This method is mainly used to find out which server has the approximate

Two more commonly used SQL statements related to SQL Server fields -- downmoon: 1. Fields in all user tables can be listed: -- List all user table fields Select syscolumns. name colname, sysobjects. name tabname ,* From sysobjects, syscolumns

Previously, when using Reporting Service, we did not know its specific paging rules. I only know that when I think that each page of a report is too long, I want to extend the report body so that the report can display more data on each page. Of