SQL Server

This article describes a log that is not a transaction log, but an error log for SQL Server logs and agents that divides the error log into SQL Server, SQL Server Agent, Database Mail, and Windows NT, according to the principal. SQL Server uses

Original: SQL Server Backup and Recovery series backup and restore in four capacity modesI. OverviewIn the first section of the SQL Server backup and recovery series, there is knowledge about backup and restore in bulk mode. This article focuses on

The relationships of SQL Server 2008 server logins, roles, database users, roles, and schemas can be represented in one of the following graphs:The use case process is as follows:New Server logon name:Login Role selected:New Database DB1:Then create

Jeesite How to properly connect to a SQL SERVER databaseJeesite IntroductionThanks to the author of the Jeesite Project thinkgem. I'm not going to change this data source without you. The nen big strength,,, the giggle Hee said much.Jeesite is an

ObjectiveLast three articles we describe how to view query plans, as well as some of the commonly used join operators, Union operators optimization techniques.In this paper, we analyze the parallel operation of SQL Server, as a multi-core computer

This article is "Stairway Series:Part of the ladder for SQL Server indexingIndexes are the basis of database design and tell developers to use the database with regard to the designer's intentions. Unfortunately, when performance problems arise,

SSMs can provide the ability to view the plans that are being executed. Live query plan can view the execution of a query, from one query plan action to another query plan operation. Live query plan provides overall query run progress and

Original: 17th-Configuring SQL Server (2)-memory configuration in 32-bit and 64-bit systemsObjective:This article covers memory configurations in 32-bit and 64-bit systems, where DBAs often try to turn on AWE to limit memory in SQL Server 2005/2008.

ObjectiveIn the previous article, we analyzed how the query optimizer works, including: detailed operation steps of the query optimizer, analysis of filter conditions, optimization of index items, and other information.In this article we analyze the

SQL SQL statements and stored procedures for SQL Server execution with FreeTDS under LinuxHttp://www.linuxidc.com/Linux/2012-06/61617.htmFreeTDS relatedHttp://www.knowsky.com/616936.htmlThe shell accepts the value returned by the stored

ObjectiveIn the previous article, we analyzed how the query optimizer works, including: detailed operation steps of the query optimizer, analysis of filter conditions, optimization of index items, and other information.In this article we analyze the

Original: SQL Server Tuning Series basics (Parallel operations Summary)ObjectiveLast three articles we describe how to view query plans, as well as some of the commonly used join operators, Union operators optimization techniques.In this paper, we

As a database administrator the most painful is that when the database is down to need to find a backup, but at this time suddenly found that the backup file is also bad, which means that the data will be lost, this may lose the position, the job is

In the process of installing SQL Server 2012 on a Windows Server 2012 server, an error was reported, an installation failed,During the installation of SQL 2012, the following error occurred: An error occurred while enabling Windows feature NetFx3,

Advantages and Usage ScenariosSQL Server in-memory Columnstore indexes store and manage data by using column-based data stores and column-based query processing. A columnstore index is appropriate for a data warehouse workload that primarily

Shanghai Microport Software Co., Ltd. Xiaoguidongfor readers: Microsoft SQL Server, advanced usersIntroduction to Meta datametadata (metadata) is most commonly defined as "structural data about data", or, more simply, "information about data", which

Completely free Asp.net 2.0 space and support for SQL Server Express, no advertisement, I have applied to activate Http://aspspider.net/bestcomy (pass by a friend please leave a word) We have limited number of servers and new registration will

The most common operations are available for beginners ...... I. Back up the database 1. Open SQL Enterprise Manager and click Microsoft SQL server in the root directory of the console.2. SQL Server group --> double-click to open your server -

ConvertExplicitly converts a data type expression to another data type. Because some requirements often use different date formats, the following can be found inFormat the date in SQL Server. SQL Server supports the data format in the Arabic style

Example of how to use DATEADD and DATEDIFF in SQL, dateadddatediff Generally, you need to obtain the current date and calculate some other dates. For example, your program may need to determine the first or last day of a month. Most of you probably