SQL Server

This series of articles from Sqlservercentral, please refer to the original text for details. SQL Server Agent is the job scheduling and alerting service for SQL Server, which can greatly simplify the workload of the DBA if used properly.The

Text: Third--Part II--the fourth article configuring SQL Server Mirroring--Non-domain environmentIn this paper, the non-domain environment to build a mirror demonstration, for the domain environment, can be referenced above: http://blog.csdn.net/dba_

The recent use of SQL Server in project-on-line usage has found that frequent updates and frequent queries cause deadlocks in high concurrency situations. Usually we know that if two transactions are inserting or modifying data on a table at the

SQL ServerAudit (Audit)--audit access to database objects Task 1: Create a login account and grant the appropriate permissions Step 1 : Open SSMs, enter the following statement, create a login account Ultrasql, grant access to Person.person and

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

Anatomy of SQL Server article 11th automated testing of multiple versions of SQL Server (translated)http://improve.dk/automated-testing-of-orcamdf-against-multiple-sql-server-versions/Since I released Orcamdf Studio, I have realized the differences

When the normal restore error:Microsoft SQL-DMO（ODBC sqlstate:42000）---------------------------When trying to enlarge a physical file,MODIFY FILE experienced operating system error  112 ( There is not enough disk space.) Failed to create one or

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,

Foreword: This article is to blog http://www.dbnewsfeed.com/2012/09/08/5-performance-killers-when-working-with-linked-servers/ Translation, if the translation is not good or bad place, please point out, we study progress together. Respect the

In this article I would like to summarize the following SQL Server 2014 introduces a variety of amazing performance improvements!!Cache Pool Extension (buffer pools Extensions)The idea of a cache pool extension is simple: Store page files on very

In this article, we'll look at what new features SQL Server 2014 adds to resource governor in the future. Resource governor (Resource Governor) is a feature that appears starting with SQL Server 2008. It is a feature used to manage SQL Server

The problems encountered in the work, in order to maintain the projects that others do, need to know the unfamiliar project database, often the data storage table naming can not be named to guess the meaning of the table, it seems more laborious,

We are going to discuss with you today is the SQL Server temporary table of the utility, if you are not very familiar with the SQL Server temporary table, the following article is a detailed description of its related content, hope will bring you

Naming conventions is a commonplace issue, and good naming conventions play an important role in the development of team programs, in the location and processing of bugs, and in the continuation of projects. First, list the current problems: 1.

Planning Cache (plan caches)If SQL Server has found a good way to execute a piece of code, it should be reused as a subsequent request because Generating execution plans is time-consuming and resource-intensive, There is a point in doing so. If the

Problem: You can run a job in SQL Server Management studio, but it fails to run with a T-SQL, and vice versa.   Analysis: In most cases, context security issues occur during execution. When executed in SSMs, The T-SQL statement is run under the

Ms SQL Server2014 link to ms SQL Server 2000 solutions and troubleshooting, server2014ms In development and enterprise applications, several versions of SQL Server are linked to each other. For distributed reading and storage, sp_addmediaserver must

Partitioning and backup of SQL Server data backup files, SQL Server Data Backup When backing up a complete database, we may sometimes encounter an extreme situation where only 5 GB of space is left for the three drive letters C, D, and E on the

SQL SERVER uses REPLACE to REPLACE a value in a field in a column with another value. sqlreplace SQL SERVER replaces a value in a field with another value.Update table name set column name = REPLACE (column name, 'A', 'bb ') SQL SERVER "the Data

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