SQL Server

As you normally know, SQL Server is well integrated with Microsoft Exchange Server, and there are detailed instructions for configuring this in SQL Server online Help, no longer repeating. However, the question we are more concerned with is: How do

When we want a query to take advantage of an index, we typically add an index hint to the query, like this Copy Code code as follows: SELECT Id,name from TB with (index (Ix_xttrace_bal)) where bal In a production environment, the

Many people do not know how SQL statements are executed in SQL Server, fearing that their written SQL statements will be misunderstood by SQL Server. Like what: SELECT * FROM table1 where name= ' Zhangsan ' and TID > 10000 and implementation:

Generally do not recommend to do 4th, 62 steps, 4th step unsafe, it is possible to damage the database or loss of data. 6th step if the log reaches the upper limit, subsequent database processing will fail, and the log will not be restored until it

SQL Server contains several different types of pages to meet the needs of your data store. Regardless of the type of page, their storage structure is the same. Each data file contains a significant number of 8KB pages, each page has 8192bytes

In addition to hard drives and tapes, you can now use SQL Server's native backup feature to back up your SQL Server database to Windows azureblob storage service. In this release, you can use T-SQL and SMO backups to Windows Azureblob storage. This

SQL Server is a relational database management system it was originally developed by Microsoft Sybase and ashton-tate three companies to launch the first OS/2 version in 1988 after Windows NT launched Microsoft and Sybase On the development of SQL

DECLARE @OutputType varchar (20)DECLARE @debug char (1)Declare @ForceRefresh char (1)Declare @xp_cmdshell_available char (1) Set @OutputType = ' LIST 'Set @Debug = ' Y 'Set @ForceRefresh = ' Y 'Set @xp_cmdshell_available = ' Y ' BeginSET NOCOUNT

This article is a transcript of the programmer's SQL code, which will explain the string functions of SQL Server. In fact, the database, like the Program language library, will integrate many APIs that can be used. These APIs, if you are familiar

Environment: SQL Server 2008 R2 Problem: The update or insert of the view or function ' XXX ' failed because it contains a derived domain or a constant field to resolve To create a view command: Create View D_s_g (Sno,avg_grade) as select

Obtain the version number of MS SQL Execute master.. Sp_msgetversion Get Hard Drive File information Parameter Description: Directory name, directory depth, whether to display files execute master..xp_dirtree 'c:' execute master..xp_dirtree 'c:',

I heard that Ms SQL 2005 with the report function, so I tested a bit, but also relatively easy to use, so I recorded a stored procedure to write a report example. Since there is no voice in the test process, I am here to explain. The stored

DatabaseThe use of the process due to procedural problems sometimes encounter duplicate data, duplication of data caused the database part of the settings can not be set correctly ...Method Onedeclare @max integer,@id integerdeclare cur_rows cursor

Policy Management is a new feature in SQL Server 2008 that manages the various properties of database instances, databases, and database objects. Policy management under the SSMs Object Explorer database instance under the Administration node, as

Blocking definition Blocking occurs when the first connection from the application controls the lock and the second connection requires a conflicting lock type. The result is to force the second connection to wait while blocking on the first

This article summarizes the way SQL Server connects across servers. 1, OpenDataSource Open the database example directly with this statement in SQL: OPENDATASOURCE( 'SQLOLEDB','Data Source=TQDBSV001 ;User ID=fish;Password=2312').RackDB.dbo.CS

Q: I recently found that many of the entries in the sysindexes Index table were not created by myself. Listening to colleagues say that they are not real indexes, but rather statistics created automatically by the SQL Server query optimizer. How do

The background of a story I'm talking about is this, using SQL SERVER 2000 as the foreground database in a certain POS project, IBM's DB2 do a background database. The environment for the foreground database is such that the operating system is

Brief introduction I recently participated in a project to migrate a Sybase database to Microsoft SQL Server 2000, and my experience with this project will help the Sybase database administrator migrate the Sybase database to the SQL Server 2000

SQL Server Technical Articles Author: Graeme Malcolm (Content Supervisor) Technical review: Dragan Tomic and Michael Rys Project Editor: Joanne Hodgins Release Date: August 2008 Applicable products: SQL Server 2008 Summary: Microsoft®sql