Category：MsSql
-
Time：2020-7-13
Databases often need to deal with each other, but never thought about how to store data inside the database. Today, we will explore how to store data in the database from the following aspects How to store data in database How to store index data Operational data impact on storage summary How to store data […]
-
Time：2020-7-13
This paper analyzes the implementation method of SQL server to create database and data table. For your reference, the details are as follows: The syntax for creating constraints is as follows: CREATE DATABASE [test] ON (NAME=N’test’,FILENAME=N’d:\SQL2kt_Data\test.mdf’,SIZE=3mb,MAXSIZE=UNLIMITED,FILEGROWTH=1MB) LOG ON (NAME=N’test_log’,FILENAME=N’d:\SQL2kt_Data\test_log.ldf’,SIZE=1MB,MAXSIZE=2048MB,FILEGROWTH=10%) GO Term interpretation (translation) constraint 1. Constraint; restriction [C] [(+ on)] legal constraints on the company’s […]
-
Time：2020-7-9
An error occurred:Sqldatetime overflow occurred while importing data. Must be between 1 / 1 / 1753 12:00:00 am and 12 / 31 / 9999 11:59:59 PM. “This problem is mostly because the datetime field value is empty when you insert or update the database. By default, it is inserted on January 1, 0001, resulting in […]
-
Time：2020-7-9
1. Lock monitoring To view a locked table: select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type=’OBJECT’ To see which session is blocking and what they are running: SELECT DTL.[request_session_id] AS [session_id] , DB_NAME(DTL.[resource_database_id]) AS [Database] , DTL.resource_type , CASE WHEN DTL.resource_type IN ( ‘DATABASE’, ‘FILE’, ‘METADATA’ ) THEN DTL.resource_type WHEN DTL.resource_type = ‘OBJECT’ THEN OBJECT_NAME(DTL.resource_associated_entity_id, […]
-
Time：2020-7-8
A few weeks ago, the latest CTP version of SQL Server 2016 was released: CTP 2.4 (now CTP 3.0). The summary of key features of SQL Server 2016 ctp2.3 will not be discussed here. Please refer to relevant information for specific contents. This preview contains many different enhancements compared to the previous CTP. In this […]
-
Time：2020-7-8
Locking is a mechanism used by SQL Server database engine to synchronize multiple users’ access to the same data block at the same time. Basic concepts Using SQL Server profiler to observe lock Causes and avoidance of deadlock summary Basic concepts Database engine isolation level Isolation level definition Uncommitted read The lowest level of isolation […]
-
Time：2020-7-7
First of all to consolidate the basic knowledge of tempdb Introduction: Tempdb is the system database of SQL server. It has always been an important part of SQL server to store temporary objects. It is easy to understand that tempdb is a Sketchpad of SQL server. Both applications and databases can use tempdb as a […]
-
Time：2020-7-6
To share the SQL database instance name caused by the character “\” escape cannot be found or the remote connection fails with an error of error40 1、 Problem introductionI haven’t used C ා to connect the database program for a long time, but I found some information on the Internet and basically wrote it out. […]
-
Time：2020-7-6
In the development process, we often contact database indexes. It is not only DBAs who need to know the knowledge of indexes. Understanding indexes can let us write higher quality code. Index overview Clustered index Nonclustered index unique index Filter index Nonclustered index contains columns Index overview The existence of index is mainly to improve […]
-
Time：2020-7-5
How to get the server hardware and system information through SQL statements in SQL Server? Here’s how to get information about the processor (CPU), memory (memory), disk (disk), and operating system through SQL statements. If there are deficiencies and omissions, please add them. thank you! 1： View database server CPU Information —SQL 1: get CPU […]
-
Time：2020-7-4
SQL Server tempdb allocation competition is a commonplace problem of DBA. Almost all DBAs know how to build more files to solve / alleviate the problem. However, the deep-seated competition is still inevitable. Here, we will analyze the characteristics of tempdb in tempdb, so that it can replace the temporary table / table variable object […]
-
Time：2020-7-4
brief introduction In the SQL Server 2012 version, when the SQL server instance is restarted, the identity value of the table will be skipped, and the actual jump value depends on the identity column data type. If it is an integer (int) data type, the jump value is 1000; if it is a bigint, the […]
