SQL Server

As I did in the previous tip, "When was your database last recovered?" , SQL Server keeps the backup and recovery records in the system tables in the msdb database active. Without proper maintenance, these system tables will become very large,

Often to connect to the remote database, so often encountered this error, and then repeatedly forget the solution, so sit down handwriting today, good next time can be recalled quickly.First, check whether the TCP/TP of the database is started.1.

one of the fields in a table student (Sno, sname, age) sname type nchar (TEN) Change to int Save the Times wrong. This is the default setting for SQL Server itself, which defaults to a type that cannot be modified. You only need to remove prvent

The merge keyword is a magical DML keyword. It was introduced in SQL Server 2008, it can be insert,update,delete simple and as a sentence. MSDN's interpretation of the merge is very short: "Insert, update, or delete operations on the target table

First, the preparatory work:Primary database server:Os:windows server R2 db:sql server R2Hostname:cxmasterdbIP:192.168.1.224/24 dg:192.168.1.1dns:192.168.1.19 dns:202.96.209.133From the database server:Os:windows server R2 db:sql server

When exec executes a SQL string, you cannot assign a value to the variable, and if you want to assign a value to the variable in SQL, use the EXEC sp_executesqlExample:by sp_executesql The 2nd parameter to define which parameter outputs the output

When it is determined that application performance problems can be attributed to one or several time-consuming statements, tuning these statements is the responsibility of the database administrator or database application developer. Statement

See an example of SQL Server today on the forum. 1/25/50/100 cents, how many kinds could be pieced together into $2. Looking at the first syntax, put it in SQL Server test, and found that it really enumerates all the ways to combine it into $2.So

With an inner join, the condition has the same result in either the join clause or the WHERE clause, but not when an outer join is used. When the condition is in the JOIN clause, SQL Server includes all rows for the appearance, and then

1.Bit type: bit (1) don't think it's just a bit, in fact it's going to take up a byte! That means when n 2.varchar (n) here n cannot be greater than 8000, if you want to be larger than 8000 you can only specify varchar (max); Here's the same for

In SQL SERVER 2005/2008, two types of ranking window functions and clustered window functions are supported.For example, in SQL Server, the order number is listed in chronological order.With OrderInfo as(SELECT row_number () over (ORDER by OrderDate)

Over time, you will find that the log files for the database will be up to 20G or more, and you will need the following methods.--first change the recovery model of the database to SimpleALTER DATABASE [Database] SETRECOVERY Simple;GO--to reduce the

The reason for this problem is that a user is connected to the database that is currently being restored, and the user here even includes the user currently being restored. The workaround is to close all connections to the database that you want to

Source: SQL Drip 7-error and workaround for attach function using SQL ServerToday, with the SQL Server 2008 Attach feature attached a database, a bit of a problem, the prompt error is:Unable to open physical file "D:\Documents\Dalt\XXXX.mdf"

Original: Merge keyword in SQL ServerBrief introductionThe merge keyword is a magical DML keyword. It was introduced in SQL Server 2008, it can be insert,update,delete simple and as a sentence. MSDN's interpretation of the merge is very short:

String functions are used to perform various operations on characters and binary strings, and most string functions can only be used for char, nchar, varchar, and nvarchar data types. String functions can be used in select or where statements.1.

Sp_locksp_whoSp_who2Sp_who2 ' active ';DBCC INPUTBUFFER (64)-- check for blocked spidSelect Blocking_session_id,wait_duration_ms,session_id,wait_type fromSys.dm_os_waiting_tasksWhere blocking_session_id is not null-- search for spid contentsp_who

Transferred from: http://www.cnblogs.com/lyhabc/archive/2013/02/10/2909761.htmlWhen we find that database query performance is very slow, everyone will think of Gazzo to optimize database query performance,But in the face of a complex SQL statement,

1. Index ConceptsIndexes are used to quickly find the rows of a particular value in a column, and without an index, the database must begin reading the entire table from the 1th record, knowing that the required rows are found. The larger the table,

When the database is relocated, too many login and user needs to match, too cumbersome, deliberately write this script, each move the database just run down the script to match login and user.Use [msdb]GO/****** object:storedprocedure [dbo].    [Usp_