SQL Server

Excerpt from: http://www.cnblogs.com/hoojo/archive/2011/07/19/2110862.htmlA stored procedure in Transact-SQL, very similar to a method in the Java language, can be called repeatedly. After the stored procedure executes once, the statement can be

Recent project project needs, to deploy the project on the WINDOWS2008R2 server, but the client side of the server is not installed on servers, all to solve their own, so I found a 2008 version, installation, installation process did not encounter

--Using SQL Server to calculate Fibonacci lawsDECLARE @number intDECLARE @A intDECLARE @B intDECLARE @c intSet @a=1Set @b=2Set @Number =3Select @[email Protected][email protected]while (@Number BeginSet @[email Protected][email protected]if (@

1. IntroductionIn the list query due to the amount of data, one-time detection will be very slow, even if once detected, and can not be displayed to the client, so to the data in batches to query out, each page shows a certain amount of data, which

Today is the 16th day of my internship. I am myself primarily learning about SQL Server database-related access when developing a system based on the MVC framework. The steps are as follows:The first step is to create a class in the Models folder

1. Create a new table and insert 1010000 data:CREATE TABLE test (ID int identity (), name varchar ()) Goinsert into Testvalues (Replicate (' a ', +)); Go 1010000create Index idx_test_id on test (ID)2. Open a new session (a), run the following

The test that appears in the following SQL Server and MySQL is a table (except for special instructions)1. View the script created by the tableSQL Server:Mysql:Show create TABLE test;2. View table structureSQL ServerSp_columns test;OrSp_help

Just changed SQL Server2008Soon, the feeling of running speed, editing tips are more than the 05 version of the promotion, but in the maintenance test system encountered a 05 of the problem: 05 in the "Open Table" can edit all data rows, 08 to "Open

Introduction to files and filegroupsIn SQL Server, there is no difference between how a database is stored on a hard disk and how ordinary files are stored in Windows, just a few files. SQL Server manages files by managing logical filegroups.　　SQL

Today is Sunday, just have free time to sort out these days of work in the business of the problems encountered.Sometimes we have a need to pass in the background a ilist generic collection data, which is the instance collection of a class, and then

are you still tapping the code to generate the SQL statement? Are you still having a problem with the SQL statements that were sloppy? Are you still tangled in the idea of how to express complex SQL statements? If your answer is yes, then you're

In the minimized log operations resolution, the app 's article has friends that reflect the slow generation of test data. Here's a simple app to share with you to speed up data import in the form of batch submissions during data generation.This

1 function DescriptionThis plan uses the log transfer mode, the core database (main database) synchronizes regularly to the disaster Recovery database (secondary server) and the backup library (secondary server, easy to use other systems, reduce the

We all know that SQL Server has two types of logon authentication, SQL Server authentication and Windows authentication, but SQL Server defaults to how Windows logon authentication works, how do we enable SQL How does the server and Windows hybrid

1, find the System.Data.dll file, the default address is in C:\Program files\unity\editor\data\mono\lib\mono\unity, which depends on the path you installed.2. Copy the file to the asset folder in your workspace3. Add references in your editor, I use

SQL Server PRIMARY key notation:--Column levelCreate TableDept (dept_noint Primary Key, Dept_name nvarchar (20) not NULL)--table-levelCreate TableDept (dept_noint not NULL, Dept_name nvarchar (20) not NULL,Primary Key(Dept_no)) --ModificationCreate

Recently in the tuning of a customer to find a very interesting phenomenon, for a complex query (involving 12 tables) to establish the necessary indexes, the statement used by the IO dropped sharply, but the execution time does not drop the reverse

1. Verify consistencySELECT @ @SERVERNAMESELECT serverproperty (' machinename ')After modifying the Windows host name, the display is inconsistent when viewed with the above command and needs to be repaired.2. Use the following script to perform and

If you encounter a situation where the SQL Server service causes memory to continue to expand the final system panic, please follow the methods below.Principle: The dynamic memory allocation mechanism introduced by SQL Server 2000 generally does not

SQL SEVER database re-indexing method, sqlsever re-Indexing I. query ideas 1. To determine the slow query speed of the database, you can use the following statement to list the average time, total time, CPU time, and other information of the query