SQL Server

A data dictionary is a collection of related descriptions of data and objects in a data model that helps programmers and users look up data and objects when they create applications and reports. When you use the data model, it is ideal to create a

The recent discovery of the performance of common query stored procedures for existing frameworks is slow, and the following code is carefully studied: Alter PROCEDURE [dbo]. [Areaselect] @PageSize int=0, @CurrentPage Int=1, @Identifier

I like to think of the tools bundled with SQL Server as inverted pyramid, the tools for diagnosing and checking general problems at the top, looking for and diagnosing specific areas of problems at the bottom. In addition to providing a convenient

See this article is sure that you put the SQL is not loaded into the C disk, hehe don't be afraid to look below When installing, be aware that you need to install the common components in C disk and then install SQL Server Management Studio Express

CooSel2.0 Createsql V1.05 Archive contains ASP and Exe two versions ASP version does not support direct import to SQL Server, only script writing is supported Exe versions can be imported directly to SQL Server Function: Generate upsizing SQL

SQL 2008 log Files account for 23G of hard disk space, and the transaction log has been truncated (Truncate), the actual log content is small, 1G is not, want to release the extra space occupied by the log files. However, no matter how you shrink

Three common error analysis in SQL Server connections One, "SQL Server does not exist or access is denied" This is the most complex, the cause of the error is more, need to check the aspect also more. Generally speaking, there are several

Determines whether a variable is null: IF (@VaribleName is NULL) Select a record for which the field value is null: WHERE column_name is NULL ISNULL () function: ISNULL (@VaribleName, ' defaultvalue ') ISNULL (column_name, ' Default Value ')

This problem is especially important for a slightly larger project, and if there are hundreds of stored procedures in the database, Can not find a one, even if they understand the business and the system, the time is long, it is inevitable to

You now need to access another two databases (NZ and AU) from another server (B) in the database (Master) on a single server (a). AU and NZ are part of the site's real-time data, and the current replication scheme for one step is basically

server| Data | database | user RIGHTS | statement sp_helprotect Returns a report that contains information about the user rights or statement permissions of an object in the current database. Grammar sp_helprotect [[@name =] ' object_statement '] [,

This article describes how batches are cached and reused in SQL Server 2005, and provides the best practice for maximizing the reuse of cached plans. In addition, some scenarios for recompiling batches are described, and best practices are given for

Set the dataset to updatable Visual FoxPro Cursor Type The English name of the cursor is cursor, and the idiom used in Visual FoxPro is temporary (temp table), but I think it's customary to call it the cursor. Because Visual FoxPro's cursor is

Customize a backup script based on your environment! Description How to use: Exec master.dbo.fullbackup1 ' s:\backup ', ' Suzhou ', ' full ' 0. Backup type can only be full, diff or log, database name cannot be empty 1. Record each backup by

The configuration options for SQL Server servers are those that people understand less and are often misused. When a technical support person asks you to adjust an option in some way, and another technical support person asks you to adjust the same

The SQL Server Client Configuration tool is used to configure client tools (other than the DOS operating system-based client tools) so that they can successfully communicate with SQL Server. This program should run after the client tool is loaded.

A Introduced Some "super users" with access to data have learned professional Transact-SQL. The convenience of the Report Builder in SQL Server 2005 Report Services (SSRS) extends to the creation of powerful Transact-SQL queries, making it easier

This paper gives the basic concept of SQL Server Data Warehouse, and uses the example construction process to analyze, for everyone's reference! Basic concepts: 1. Cubes: Cubes are the primary object of online analytical processing (OLAP) and are

Set up alertsIn the general items, make the following settings New Alert Set Alert name Select Database Select severity The following settings can be made in response items Select an operator to mail notifications

Unlike disk-based table, memory-optimized tables reside in memory and are implemented using the Hekaton in-memory database engine. When the query is queried, the data rows are read from memory, and updates are written directly to memory when they