Timely Email Warning and Reminder for Blockage in Database (Part 2)

stay Timely Email Warning and Reminding of Blocking in Database (Part I) We build a new table to store blocked records, collect blocked stored procedures and configure sending mail to test ok, etc. Step 4: Create a storage process for sending mail. There are two modes that you can choose according to your needs Create a stored procedure for sen ...

Posted on Wed, 03 Jul 2019 15:53:38 -0700 by ksb24930

Who exactly is synchronized locking?

This article code repository: https://github.com/yu-linfeng/BlogRepositories/tree/master/repositories/sync Start with an enrollment-level concurrent programming pen test Title: Use 5 threads to execute concurrently, num digits count up to 10000, and print. 1 /** 2 * Description: 3 * Using five threads to execute concurrently, num numb ...

Posted on Thu, 13 Jun 2019 10:00:16 -0700 by popsiclesph

Descending Indexes for SQL Server

  Test environment: SQL Server 2012   The table structure is as follows USE [test] GO CREATE TABLE [dbo].[tt8]( [id] INT IDENTITY(1,1) NOT NULL, [win_num] [int] NOT NULL DEFAULT ((0)), [lost_num] [int] NOT NULL DEFAULT ((0)), [draw_num] [int] NOT NULL DEFAULT ((0)), [offline_num] [int] NOT NULL DEFAULT ...

Posted on Tue, 30 Apr 2019 15:30:37 -0700 by kaimason1

Summary of SQL Server Database Files and File Groups

File and File Group Concept   For documents and file groups, a brief summary is as follows. For details, please refer to the official documents.“ Database Files and Filegroups ” More relevant information:   Data file concept:   Each SQL Server database contains at least two system files: a data file and a log file. Data files contai ...

Posted on Wed, 24 Apr 2019 20:27:36 -0700 by driverdave

[SQL Foundation] Three Category Statements

SQL statements can be divided into the following three categories. DDL (Data Definition Languages) statements: Data Definition Languages, which define different definitions of database objects such as data segments, databases, tables, columns, indexes, etc. The commonly used keywords include create, drop, alter and so on. The operating langua ...

Posted on Tue, 02 Apr 2019 11:18:29 -0700 by Azzyh

How to Use SQL Server to Realize All Combinations of a Batch of Strings

In SQL Server, how to use SQL to achieve the complete combination of a batch of strings? This is a problem that colleagues encounter in their actual needs. His specific needs are as follows:   The input parameter formats are'1, 2, 3, 224, 15, 6''A,BC,GHT,TTY,B,E'   The output is all Non-permutated combinations of split strings !-factoria ...

Posted on Sun, 31 Mar 2019 23:18:30 -0700 by torrentmasta

Sql common grammar

Classification of SQL DDL - Data Definition Language (CREATE, ALTER, DROP, DECLARE) DML - Data Manipulation Language (SELECT, DELETE, UPDATE, INSERT) DCL - Data Control Language (GRANT, REVOKE, COMMIT, ROLLBACK)   II. Basic Sentences 2.1. Description: Create a database create database db-name 2.2. Note: Delete the database drop database db-n ...

Posted on Mon, 25 Mar 2019 15:15:30 -0700 by Schneider707

SqlServer Creates Data Table Description and Column Description Information

SqlServer Creates Data Table Description and Column Description Information Intro Q: Why create descriptive information? A: When the mouse hovers over the corresponding tables and columns, descriptive information will appear, which can improve the efficiency of the work. With the help of tools, we can generate Model according to the data tab ...

Posted on Wed, 20 Mar 2019 11:06:26 -0700 by hyster

Performance test of INNER JOIN and sub-query IN in SQL Server

This month, I met several people who asked me about the performance of INNER JOIN and IN in SQL SERVER. This problem. In fact, this summary is the superiority and inferiority of INNER JOIN and sub-query in SQL Server (IN is one of the ways to implement sub-query, this article only compares the performance of INNER JOIN and sub-query IN. If we c ...

Posted on Sat, 22 Dec 2018 18:27:06 -0800 by bigfunkychief