SQL Server

(I ' m sitting here-Seattle Airport at 7am Sunday waiting to catch the same flight to Boston that I caught II weeks a Go. Instead of TechEd, this time I ' m going to a training course at MIT. I ' d enjoy the air travel a lot and a bigger gap in

Customer Database error Contact us, our engineers get customer data, the database DBCC CHECKDB repair, reported "MSG 211, Level 23, State 51, line 1thSchema corruption may have occurred. Please run DBCC CHECKCATALOG. ”message 0 , Level - , the

Method One:With Cte_sid (Bsid, SID, sql_handle)As (SELECT blocking_session_id,session_id,Sql_handleFrom sys.dm_exec_requestsWHERE blocking_session_id <> 0UNION AllSELECT a.blocking_session_id,A.SESSION_ID,A.sql_handleFrom Sys.dm_exec_requests AJOIN

Grammar:DATEDIFF (datepart,startdate,enddate)The datepart parameter can be the following value:Date-part:year | Quarter | Month | Week | Day | Hour | Minute | Second | MillisecondThe parameter date-part specifies the date portion of the interval to

1: How to use Windows Authentication:CREATE ENDPOINT Instinitiatorendpoint state = STARTED as TCP (Listener_port = 4022) for Service_broker (authentication = WINDOWS); Go is created between two instances, using Windows authentication, which is

Navicat for SQL Server can create, edit, and delete all database objects, and is a comprehensive graphical way to manage the database. But a lot of users of their friends do not know enough, we will give you some tutorials to explain. This tutorial

Microsoft Technology Specialist (MTA)-DatabaseHttps://www.microsoft.com/zh-cn/learning/mta-certification.aspx Mcsa:sql Server Solutions SpecialistHttps://www.microsoft.com/zh-cn/learning/mcsa-sql-certification.aspx Mcse:data Platform

Computer room toll System reconstruction version of the landing knocked for several days, finally the landing window knocked out, code debugging almost the same, the problem is in the database. SQL Server in configuration management. SQL Server The

Some tools used for a long time or have new tools appear, slowly forgotten a lot, they become unfamiliar from the familiar, of course, it is not good for us.Today, let's review the basic class library of the MS that is used by ADO, first on the code

An aggregate function is a function that performs a calculation on a set of values and returns a single value, which is often used in conjunction with the GROUP BY clause of a SELECT statement, and what aggregate functions are specifically in SQL

5. Can we build the index on the view, if it can be built, what will be the advantages and disadvantages; What is the difference between the index on the view and the index on the table;----------------------------------------------------------------

To delete a database, or to delete all tables in the database (delete table structure and data), you need to delete the foreign key constraint between the tables before you can delete the table. such as deleting all tables in the database

Due to the widespread use of SQLServer2000, many companies also want to use the new SQL Server to directly "detach/Attach" or "Backup/restore" the database to be stored between different versions. The issue of incompatible versions is often

Tag: SQL Server database log shrinks free space.How SQL Server database shrinks log spaceDescription: SQL Server database log will become larger, especially when the space is tight, you have to shrink the log to release some of the space, the

Lock EscalationRelated to the number of locks and memory pressure, after the threshold is reached, upgrade directly to table lock without minor upgrade to page lockThere are several ways to reduce lock escalation: Disabling lock escalation

SQL Server configuration database mirroring, there may be friends will be more confused, you do two database out, their IP address is not the same, when the database switch past, my database connection string can be good? Do you have to control

Project backgroundThis is to a data center to do a project, the project is very difficult, the project really makes me feel, the mall like battlefield, and I just one of the soldiers, too many tactics, too many high-level contest, too much insider.

One, time and date function1.Set Datefirst 1--setting Monday as the first day--datepart function to return a part of a time date--parameter 1 refers to which part is returned, and DW represents DayOfWeek--Parameter 2 refers to the time and date in

Variables are an essential part of a language, and of course, the same is true for T-SQL. In simple queries, variables are often seldom used,However, variables are an essential part of a complex query or stored procedure. In SQL Server, variables

Find the maximum value for multiple columns in one row in a SQL Server tableSometimes we need to find the largest value from multiple identical joins (the same data type for these columns) and showHere is an exampleIF(object_id('tempdb: # #TestTable'