SQL Server

Take the full-text search of SQL database on your computer as an example. If full-text retrieval has been installed when SQL Server is installed, skip this step. If full-text retrieval is not set when SQL Server is installed, you can reinstall it

A friend suggested that I control the connection pool to improve performance, but read the following Article The connection pool is maintained by the system itself, Program There is no need for control. Do you have any comments? Is there any way

This example demonstrates how to use the DTs designer to create a data transmission package. 1. Create a new DTS package first. The method is as follows;  2. Click Create to open the designer. For example, the red and blue green boxes in the

SQL Server 2000 DBCC statements use input parameters and return values. All DBCC statement parameters can accept Unicode and DBCS literal values. Use DBCC result set output Many DBCC commands can generate output in table format (using the with

When I accidentally opened my notebook and saw this sentence, I thought I was so weak that I wanted to write Program Simply transfer the Excel file to the database and process it again. Select F1 As Funccate, system query name As

Currently, it is difficult to find very qualified database developers in the workplace. One of my colleagues once said: "SQL development is a language that is easy to learn but hard to master ." When interviewing the SQL Server database developer, I

Input: declare @a intset @a = 0while @a ' + Convert(varchar, Getdate() , cast(@a as int)) end try begin catch --print cast(@a as varchar) + ': Error' end catch set @a = @a+1end   Output: Convert(varchar,Getdate(),0) -> 06 14 2013 2:53

Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->Bulk insert From '' With ( FieldTerminator = ' ', RowTerminator = '' ) For example, import the data in C: \ aaa.txt (one record per line, and

Method 1: Select * from servername. dbo. tablename Method 2: Select * from OPENDATASOURCE ('Sqlodb ','Data Source = remote ip address; User ID = sa; Password = password'). Database Name. dbo. Table NameWhere condition Select top 100 * from

-- Add a role, grant permissions to the role, and then add the user to the role. -- Create role r_test EXEC sp_addrole 'r _ Test' -- Grant r_test all permissions on the jobs table Grant all on jobs TO r_test -- Grant the role r_test the SELECT

Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->-- Create a Test Database Create database Db GO -- Back up the databaseBackup database Db to disk = 'C: \ db. Bak' WITH FORMATGO -- Create a

In the previous article, I have briefly introduced the basic information of the Project. Today, I started to optimize the system performance. I am a newbie in terms of performance tuning. I don't have much experience and solid foundation, so I hope

The previous optimization notes were too summarized. Some friends suggested that I write the optimization steps and methods in detail, in this comparison, I will explain in detail how to use ANTS Profiler + SQL Server Profiler to find the bottleneck.

1. sort by strokes of the Last Name:Select * From TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as 2. database encryption:Select encrypt ('original password ')Select pwdencrypt ('original password ')Select pwdcompare ('original

Table t_lock: ID is the primary key, and the table has 5 rows of data, 1 ~ 2, 4 ~ 6   Repeatable read: Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->SET TRANSACTION ISOLATION LEVEL REPEATABLE

Think twice about partitions: 1. Although partitioning can bring many benefits, it also increases the management cost and complexity of object implementation. Therefore, before partitioning, You need to carefully consider whether to partition the

I used triggers to do things in a short time, and I reviewed them. I found some information from the Internet and added my memories as follows. I only recorded the information for subsequent queries. Create a trigger: Code highlighting produced by

1. view the database version Select @ version 2. view the operating system parameters of the machine where the database is located Exec master .. xp_msver 3. view database startup parameters Sp_configure 4. view the database startup time Select

This is a case from the Microsoft community's elite project. I gave the solution.  Problem description: Environment Description:Operating System win2003Database SQL SERVER 2000 SP4About GB database data size Specific fault description:Connect to the

-- Create a login user-- Create login login_name from windows with default_database = database | default_language = language;Create login [localhost \ hoojo-pc] from windows with default_database = testHome;-- Create a login user-- Create login