SQL Server

Original: SQL Server memoryBackgroundRecently a client found me that all the SQL Server server's memory was exhausted, and then showed me the task manager of a server.Here to illustrate that the task manager will not completely tell the real memory

SELECT * FROM sys.sysprocesses -check processSELECT * FROM Sys.sysusers ----Check user related informationSelect * FROM Sys.dm_exec_connections--this command can see the connection condition--This command can see how many sessions, one

With the development of the network and the increasing of hacker technology, the attack on SQL Server database is more and more, and the confidential data of many enterprises are threatened by some. How to enhance the security of SQL Server more

During the recent development of the SQL Server database project, a problem was found in the background site memory consumption of 95%, through the Task Manager to view the memory of the process Sqlserver.exe, because SQL Server R2 run longer, the

A system database is a necessary database for managing and maintaining SQL Server, which is critical to the operation of the server instance. Multiple system databases must be backed up after a large number of updates, including master, model, msdb,

The first type: Row_number () over () modeSELECT * FROM (SELECT *, Row_number () over (Order by ArtistID) as RowId from Artistmodels) as Bwhere RowId between and 20　　---where RowId between the current number of pages -1* and pages * Number of bars---

I. Cold Backup Recovery1. net stop MSSQLSERVER # If the default DB instance that is installed shuts down SQL Server's database2. Copy SQL Server data files are mainly MDF data files and the LDF disk files.3. If the database takes a full log mode log

Sqlserve errorlog files Sometimes encounter large files, may be executed by command xp_readerrorlog or Sp_readerrorlog, you can add search text or start and end time--Log View--exec xp_readerrorlog @FileNum, @Type, @SearchText1, @SearchText2,

Directly on the code:1 SELECTOsub.name as [child table name] ,2Fk.name as [FOREIGN Key Name] ,3Subcol.name as [child table column name] ,4Omain.name as [Primary Table name] ,5Maincol.name as [primary table column name]6 fromSys.foreign_keys FK7

Because of the 2 databases before and after the project, it is necessary to change the structure of the statistical database, the change of each table needs to be counted, because the Manual check is a waste of time, wrote a little code:1. Number of

We all know that when the amount of database data is large, data can be horizontally extended, such as sub-Library, partition, sub-table (also called partition) and so on. One scenario for a sub-table is to use the partitioned view

First, the AlwaysOn conceptAn availability group supports a failover environment for a discrete set of user databases, known as availability databases, which collectively implement failover. An availability group supports a set of primary databases

Modify the 3 parameters (database name, log file name, and target log file size) to runSETNOCOUNT on DECLARE @LogicalFileNamesysname,@MaxMinutes INT, @NewSize INT UseTableName--the name of the database to manipulateSELECT @LogicalFileName =

SQL Installation Notes installation SQL Server 2008 Open Setup.exe in SQL Server 2008 displays a dialog box for the SQL Setup program.Tip You must install related components Microsoft.NET Framework and Windows Installer.my virtual

User login:, create a login formconnect to SQL Server;The construction of the SqlCommand class is used to create a SqlCommand object for executing specific SQL statements, such as modifications, updates, deletions, and so on. The steps are as

Baidu's information, save it:When writing SQL statements that are queried by time periods, we usually write this query condition:where date>= ' 2010-01-01 ' and dateHowever, when you execute SQL in real time, some statements are converted to

How SQL Server server modifies collationsOperation and verification steps:1 after you log on to the database, look at the two ways that the default collation of the currently installed database isAfter you log in to the database using SQL Server

To create a database:Command: Create database name;Example: Create database student;To delete a database:Command: drop database name;Example: Drop database student;New table:Command: CREATE TABLE table name(Column name data type, column Name 2

　　What the constraint is:　　　　　　　　Everyone in the website or the app registered account, in the registration of the account will limit the user name, password and other formats, if the format is not registered. In the database we can restrict by

Graphic explanation of new functions of SQL Server 2016 Alwayson, 2016 alwayson Overview It has been more than a year since SQLServer2016 was released. The latest stable version is SP1. Next, let's take a look at the improvements made in Alwyson in 2