SQL Server

Referenced from SQL Server internals“As views, these metadata objects is based on an underlying Transact-SQL (T-SQL) defnition. The most straightforward-of-the-defnition of these views are by using the Object_defnition function. (You can also see

Starting with SQL Server Enterprise , you can use SQL Server Audit to set up automatic auditing.In the audit node, you can create one or more audit specifications that can be used for the server audit specification and the database audit

When IDENTITY_INSERT is set to OFF, you cannot insert an explicit value into the identity column in table ' #TT '.I was in SQL Server to write the stored procedure encountered this error, then thought: how the temporary table has a primary key, I

Original: SQL Server Enterprise Platform Management Practice reading notes--sql server shrinking a database for reasons of poor useThe database administrator sometimes needs to control the size of the file, may choose to shrink the file, or some

Navicat for SQL Server is a comprehensive graphical management database that allows you to create, edit, and delete all database objects, such as tables, views, functions, indexes, and triggers, or run SQL queries and scripts, Navicat for SQL The

Brief introductionThe essence of deadlock is a stalemate, which is caused by the contention of multiple subjects for resources. Understanding deadlocks first requires an understanding of the relevant concepts involved in deadlocks.Some basic

The previous connection was normal, not even on these two days. ( no patience to look at the end of the solution directly)The error message is as follows:1. Attempt to read or write protected memory. This usually indicates that other memory is

Source: http://www.cnblogs.com/lyhabc/archive/2012/09/23/2698702.htmlDAC: dedicated Admin ConnectionWhen SQL Server is unable to establish a database connection due to insufficient system resources or other exceptions, you can use the

have experienced SQL2012 database installation, you can skip this step directly into the fifth step: Rs Add-in installationDatabase installation tool: SQLServer2012 SP1Name:sqlserver2012sp1-fullslipstream-chs-x64Key: (One of the available keys for

master databaseRecords all system-level information for an instance of SQL Server.The master database records all system-level information for the SQL Server system. This includes instance-scoped metadata (such as login accounts), endpoints, linked

First, write in frontRecently, the company has upgraded the development environment, the database has prepared a new server, everything is ready to begin data migration, to take the way to the existing database (existing server Windows Server 2003 +

Each individual instance of SQL Server has a Windows process: sqlservr.exe, multiple instances can be installed under one windows, and multiple instances will have multiple sqlservr.exe processes.A SQL instance corresponds to a service in the

[Top] SQL Server more than 2008 error-handling Database recovery Method--Log tail backupCategory: Database management logs Best Practices FAQ Backup Restore misoperation Integrity SQL Server Databases Enterprise Management DBA security 2013-01-10 20:

SQL Server uses date to represent dates, time to represent times, and datetime and datetime2 to represent dates and times.1, the precision of the second refers to the number of decimal places used to represent 1s:The precision of the datetime data

SQL Server Deadlock Summary1. Deadlock PrincipleAccording to the definition in the operating system: A deadlock is a permanent wait state in which each process in a set of processes occupies a resource that is not freed, but is placed in a form that

1. migrate database schema. First, use the reverse engineering function of Sybase powerdesigner to reverse the physical model of the SQL Server database. The specific operation is to select "file" in powerdesigner, "reverse engine", then select

Introduction Understanding the memory management of SQL Server is the basic for SQL Server troubleshooting and performance tuning.ArticleDescribes how SQL server manages memory.   Secondary storage ( Secondary storage ) For computers, the

Summary of Row-to-column conversion problems-1. Row-to-column conversion (various problems in the forum will be sorted out later) --- 1. Simplest row-to-column Conversion/* Question: Suppose there is a student orders table (TB) as follows:Name

The WIN2008 R2 installed on the server does not care about the machine name. After the SQL2008 R2 database is installed, the machine name is changed when the AD domain is configured. Then, when you start configuring database image synchronization,

Ø basic common Query-- SelectSelect * from student;-- All query allSelect all sex from student;-- Duplicate distinct FilteringSelect distinct sex from student;-- Count statisticsSelect count (*) from student;Select count (sex) from student;Select