Index analysis of union primary key (Union index) in SQL Server (MySql)

Recently, someone asked this question in the interview. Before that, they had not studied the specific use logic of the joint index, consulted several articles, and came to some conclusions after testing Test environment: SQL Server 2008 R2 The test results are similar to the query mechanism of MySql joint index. We can think that MySql is the ...

Posted by kathas on Fri, 01 May 2020 08:02:06 +0200

Why not create a column with ANSI? Padding set to OFF?

SQL Prompt is a practical SQL syntax prompt tool. It searches automatically according to the object name, syntax and code fragment of the database, and provides users with appropriate code selection. Automatic script settings make code easy to read - especially useful when developers are not familiar with scripts. This article describes not to ...

Posted by MrXander on Thu, 12 Mar 2020 13:13:27 +0100

SQL Server obtains relevant stored procedures and other objects through conditional search.

In SQL Server, we often meet some requirements. We need to search whether objects such as procedures and functions contain an object or involve an object. For example, I need to find out whether those stored procedures and functions call LINKED SERVER. If we search from sys.sql modules, we need to search for multiple functions. The user databas ...

Posted by frist44 on Tue, 22 Oct 2019 16:45:54 +0200

SQL Server get index creation time & rebuild time & reorganization time

I wrote a blog before“ Can the last index rebuild time be accurately obtained in SQL Server? ", which mainly deals with three questions: can we find the creation time of the index? When was the last index rebuild? When was the last index reorganize? At that time, we came to the conclusion that the answer was that we could not accurat ...

Posted by Mr Camouflage on Tue, 22 Oct 2019 11:40:31 +0200

SQL Server Views Specific Permissions Granted by login

How to check the specific rights of a login in the SQL Server database? If you use the UI interface of SSMS to check the specific rights of the login name, there are many user databases. It is time-consuming and troublesome to sort out all the rights of the user database. Individuals highly advocate concise and efficient methods and dislike tho ...

Posted by satya61229 on Tue, 01 Oct 2019 01:07:21 +0200

SQL Server uses Hierarchyid to manipulate hierarchical data

Hierarchical data is defined as a set of data items that are correlated through hierarchical relationships. In hierarchical relationships, a data item is the parent or child of another item. Starting in 2008, SQL Server built-in hierarchyid data types make it easier to store and query hierarchical data. Hierarchy is actually a CLR data type.   ...

Posted by OnePlus on Fri, 05 Jul 2019 20:24:24 +0200

T-SQL Realizes the Computation of the Most Steady Scheme of the Success, Balance and Loss Combination of the Football Game

Standard Origin: http://www.cnblogs.com/wy123/p/6970721.html     Disclaimer:This article is only for entertainment, from the point of view of winning or losing the lottery, to analyze how to invest to achieve the "most secure" income, ^ O^This article does not have any guidance or responsibility for any actual investment portfolio. ...

Posted by paul.mac on Mon, 24 Jun 2019 02:55:11 +0200