SQL Server

First, the problem descriptionThe current DB instance has been joined to a domain environment and is also a replica of an AlwaysOn cluster, and has now exited the previous domain to join a new domain, and the configured database starts the service

1. System Version InformationSystem:windows flagship Service Pack1Kettle version:6.1.0.1-196JDK version:1.8.0_722. Connect to the databaseThis instance uses global variables when connecting to the database.2.1 Create a new transformation: After

In SQL Server, there are times when you need to give some logins (users) permission to view all or part of the objects (stored procedures, functions, views, tables) that define permissions to save. If a partial stored procedure, function, view is

In the design of the database, often do not take into account the problem of table partitioning, often in the burden of the data table load is getting heavier, will take into account the partitioning method, at this time, it is related to how to

The so-called world events, a long time will be together, a long time will be divided, for the partition table is the same. Before we described how to delete (merge) a partition in a partitioned table, let's look at how to add a partition to a

First, the partition table introduction:The primary purpose of using partitioned tables is to improve the scalability and manageability of large tables and tables with various access patterns.Partitioning can divide the data into smaller, more

What is a table partitionIn general, when we create a database table, the table data is stored in a file.However, if it is a partitioned table, the table data will be divided into different files according to the rules you specify, splitting a large

Project on-line, before the preparation of the acceptance of a serious problem: many SELECT statements as a deadlock of the sacrifice, most of the report cannot be opened. It's a big problem. All reports are inaccessible, and our report is placed on

1. Check if IntelliSense (intellisence) is enabled in the settings, which can be set in "Tools" → "Options"2. If it is not valid, you can create a new Query window query, enter the first few letters of the keyword to see if there is a hint (or use

The SQL Server version is R2.SQL statement (source) for querying database index fragmentation conditions:SELECT object_name (Ind. OBJECT_ID) as TableName, ind.name as IndexName, Indexstats.index_type_desc as Indextype, Indexstats.avg_fragmentation_

SQL Server 2012 provides a special "File table", also known as "FileTable". FileTable is a dedicated user table that contains predefined schemas for storing FILESTREAM data, as well as file and directory hierarchy information, and file attributes.

I gave you an introduction to WinDbg in the previous article and how you can attach to SQL Server. Today's article, we go ahead and I'll show you the steps required to debug a SQL Server query using WinDbg. Sounds interesting? Here we go!Suppose you

%: matches 0 or more arbitrary characters; _: matches any single character; []: Matches a range; [^]: excludes a range;-: hyphenSymbol meaningLike ' 5[%] ' 5%Like ' [_]n ' _nLike ' [A-CDF] ' A, B, C, D, or FLike ' [-ACDF] '-, A, C, D, or FLike ' [[]

How do I connect to a database using connection objects?For the different. NET data provider, ADO. NET uses different connection objects to connect to the database. These connection objects shield us from specific implementation details and provide

in SQL Server by default, the start of each week starts from Sunday , if the default is Monday?Here are three ways to solve this problem:changing the new DimDate directly through SET datefirst VALUE, and then associating it with the Date Key each

Microsoft SQL Server2008 Review improvesA Architecture of the Microsoft SQL Server systemThe 1.Microsoft SQL Server2008 consists of 4 main parts, namely 4 services:Database engine, Analysis Services, Reporting Services, Integration Services. Such as:

Problems caused by concurrent transactions       issues                               description                                     results           &NBSP td>                           fix          

SQL Server logs and agent error days generally after the instance restarts itself, assuming that the instance has not been restarted for a long time, it will probably accumulate too many logs, inconvenient to view.To view the error log size:--View

SQL Server transaction backup and restoration instance code (mandatory), SQL Server transaction Let's just talk about the code. Create database mydbuse mydbgocreate table account (id varchar (16), name varchar (16), balance float) goselect * from

SQL Server concurrent processing, update solution discussion, SQL Server Preface In this section, we will talk about the most common situation of concurrency, that is, update. If no row record exists in concurrency, insert it. At this time, it is