SQL Server

In a Microsoft SQL Server 2008 system, the database administrator, or DBA, is the most important role in the administration. The DBA's goal is to ensure that the Microsoft SQL Server 2008 system runs properly and efficiently. The DBA's work is also

Use masterGOIF object_id (' sp_hexadecimal ') is not NULLDROP PROCEDURE Sp_hexadecimalGOCREATE PROCEDURE Sp_hexadecimal@binvalue varbinary (256),@hexvalue varchar (514) OUTPUTAsDECLARE @charvalue varchar (514)DECLARE @i intDECLARE @length intDECLARE

Recently encountered "the line was not found at the Subscriber when applying the replicated command" problem, the error is as follows:The official advice is to resynchronize and initialize the subscription, which, of course, is an option, but for

A job backup, not a backup database, is a backup job.My method is to export the job as a file backup, because when your server maintenance more time many of your homework is very problematic, very troublesome.It's best to be able to work with

SQL Server 2008 is a set of database management systems developed by Microsoft Corporation. is one of the most popular databases in the current large database. Stable performance, powerful, is a large-scale enterprise-oriented database solution.

SQL Server preparation prior to SCCM deploymentAs we said earlier, the deployment of SCCM requires support for SQL Server databases. Because we are a real-time, SCCM blog post, we deploy our database products separately on the server. If your

workaround for SQL Server 2014 failed to open user default database Logon failure error 4064Did a stupid thing in the evening, deleted the administrator account of the default database, followed by a header error.The solution is as follows:First

Use this statement frequently to view poorly-performing SQL statements:SELECTCreation_time N'Statement Compilation Time', Last_execution_time N'Last Execution Time', Total_physical_reads N'total number of physical reads',

One, nonsense:As the size of the database becomes larger, the database tables are hundreds of thousands, and if you need to do operations on database table names and field names, a single good statement is done, but if you want to do all the table

Objective:There is a database for historical archive (for short, historical library), after a certain amount of time accumulated, data files have reached more than 700 GB, and later decided that some data can not be retained, this part of the data

First, backgroundA friend of the previous time group asked a question: "Add an increment sequence to the query, such as: 0x00000001, that is, each is a 36-digit (0-9,A--Z), and 0x0000000z is followed by 0x00000010, creating a mapping table like the

This article follows: SQL Server execution Plan operator detailed (1)-Assertion (Assert)Objective:According to the plan, this article began to tell the other operator concatenation (concatenation), the reader can be based on the word (both English

--select select * from student; --all query All the Select all sex from student; --DISTINCT filtering repeats select distinct sex from student; --count Statistics SELECT COUNT (*) from student; Select count (Sex) from student; Select count (Distinct

1. After the SA user logs in, create a new login in security2, add the login name, the following default database select the default database that the user can access3. Select public in the server role4. Select the database that the user can access

First step: Open Administrative Tools in Control PanelSecond step: Click "Administrative Tools" and then double click "Data Source (ODBC)"Step three: After opening, click "Add"Fourth step: Select "SQL Server" and click "Finish"Fifth step: Fill in

The following error occurred while learning the ASP. NET process used to create a new dataset and connect to the SQL Server 2008 database remotely:the server was not found or could not be accessed. Verify that the instance name is correct, and that

Activiti-Explorer uses the SQL server database implementation method, activitiexplorer How to enable Activiti-Explorer to use the SQL server database The war file of Activiti-explorer downloaded from the official website uses the h2 memory database

SQL Server implements the split function to split strings and Its Usage example. sqlsplit This article describes how to use SQL Server to split strings using the split function. We will share this with you for your reference. The details are as

Deep Learning of SQL Server aggregate function algorithm optimization skills, SQL server Aggregate functions are widely used in practical work to cope with various needs. Optimization of Aggregate functions naturally becomes a key point, whether a

SQL Server lock table, unlock, and view sale table, Lock a table in the database Copy codeThe Code is as follows:SELECT * FROM table WITH (HOLDLOCK) Note: What is the difference between locking a database table? Copy codeThe Code is as