SQL Server

The original: Anatomy of SQL Server sixth to avoid regressions in the system test of OrcamdfAnatomy of SQL Server sixth to avoid regressions in system tests for Orcamdfhttp://improve.dk/avoiding-regressions-in-orcamdf-by-system-testing/The risk of

SQL Server Windows authentication changed to Mixed Mode authenticationAs needed, change SQL2008 single Windows authentication to mixed-mode authentication. Make a memo here.Steps:1. Enter SQL2008 with Windows authentication, and in Object Explorer,

SQL Server always on switch host after login and user cannot match, looked for a long time no solution was found, and later asked Microsoft, said that because login in the login host SQL Server instance SID, because the server before the SQL The SID

Use [msdb]GO/****** object:storedprocedure [dbo].    [Indexmaintain] Script date:6/14/2013 1:46:17 PM ******/SET ANSI_NULLS onGOSET QUOTED_IDENTIFIER ONGOCREATE procedure [dbo]. [Indexmaintain]AsSET NOCOUNT onBEGIN TRYDECLARE @EXCEPTION VARCHAR (MAX)

DECLARE @s VARCHAR (100)SET @s= ' r1-1-1 ' gets the number after the last "-"SelectREVERSE(@s) return value: 1-1-1R reverses the character. SelectLEN(@s) return value: 6 Get length SelectCHARINDEX(‘-‘,REVERSE(@s)) Return value: 2--Gets the position

It is obviously unsafe to use the superuser sa everywhere, so there is a need to create a user and make it accessible to only one database. Of course, you can use the SQL Server's own graphical Interface wizard, but it's too hard to use! Sometimes

SQL Server 2008 deletes a job when it encounters an inability to deleteWorkaround: Use [msdb]DECLARE @job_name VARCHAR( -)SET @job_name =N'JobName'--Note: JobName for the maintenance plan corresponding to the JobName--Delete the log inside the

Concept IntroductionDevelopers like to use with (NOLOCK) in SQL scripts, with (NOLOCK) is actually one of the table hints (table_hint). It is equivalent to readuncommitted. The specific function functions are as follows (from MSDN):1: Specifies that

Http://www.cnblogs.com/adandelion/archive/2006/11/08/554312.html1, the common date method (below getdate () = ' 2006-11-08 13:37:56.233 ')(1) datename (datepart, date)Returns a String that represents the specified date portion of the specified date.

Reference:SQL Server null+ strings, isnull and assigning query results to one character variable to form another query statement1. The string that starts the definition is null. For example: Declare @sqlRequirement: A string that loops through a

SQL2008 expression: Is any combination of constants, variables, columns, or functions, and operators.1. String functionsFunction Name Parameter Example descriptionASCII (string expression)Select ASCII (' ABC ') returns 97Returns the ASCII code of

　　　　If you need to reprint, please attach the author and the original link: http://www.cnblogs.com/zeusro/p/4016228.htmlMicrosoft SQL Server Profiler is a graphical user interface for SQL tracing that is used to monitor the database engine or

Background knowledge:sp_configure display or change global configuration settings for the current server (use sp_configure to display or change server-level settings.) )View global configuration valuesMethod 1, execute sp_configure; view all

When SQL Server frees up its own memory! In order to provide it to other programs?--------------------------------------------------------------------------------------------------------------- -----------------------------------------------To say

Turning on deadlock monitoring in the database collects the deadlock conditions that occur in the database. There are 2 ways to open it:1 Turn on 1222 monitoringExecute SQL statement:DBCC Traceon (1222,-1);Then view the deadlock information in the

WorkaroundMethod 1, rebuild the specified index, this method has no performance to talk about. The table is not yet accessible at rebuild time.Method 2, rebuild the index online, only supported by SQL Server Enterprise Edition.Method 3, using fill

SQL uses three-valued predicate logic, so the result returned by a logical expression can be true, false, or unknown, and returning true in the three-value logic is not exactly the same as not returning false.SQL handling of query filtering

Definition and usageThe DATEDIFF () function returns the number of days between two dates.GrammarDATEDIFF (Datepart,startdate,enddate)The datepart parameter can be the following value:DatePart abbreviation year yy, yyyy quarter QQ, Q

This is illustrated here directly with a small example.1. Open the new Web site, vs2010-> file, select the ASP. NET site and set the storage path to create an empty Web site. (My path here is set to D:\EXCELEDUCETOSQL)2. Create the database test and

In SQL Server, if bigint is converted to int, an error is returned. How can this problem be solved? sqlserverbigint One requirement is to store multiple statuses (including exceptions and warning statuses that can exist at the same time) in the