Programming VIP

I. Questions Question 1 Scene: If your future mother-in-law asks you to give her one cent on the first day, two cents on the second day and four cents on the third day, and so on, twice as much as the previous day and one month (30 days) is enough.Question: How much is it for the 30th day and how much is it altogether? Questio ...

The source of this paper is: http://www.cnblogs.com/wy123/p/6835939.html    What is waiting Briefly explain what waiting is:When an application initiates a Session request to SQL Server, the Session request requests the required resources during execution in the database.For example, you may apply for memory resources, locks on tables, physi ...

When migrating or upgrading SQL Server database servers, we cannot restore msdb in many scenarios, so we have to migrate SQL Server related jobs manually. If it is time-consuming and laborious to manually generate scripts for each job, there are actually several methods in SQL Server that can generate job scripts in batches. Here are some of th ...

1) Overview The following articles have been published [SqlServer Series]: [SqlServer Series] SQLSERVER Installation Tutorial  [SqlServer Series] Three Database Paradigms [SqlServer Series] Form Query [SqlServer Series] Table Connections [SqlServer Series] Subquery [SqlServer Series] Turn on Sqlserver remote access This article ...

Recently, we encountered a very difficult problem. The monitoring system DPA found that a custom scalar function was invoked very frequently, which was beyond the scope of spectrum. Then when Troubleshooting is a problem, I do encounter some problems that make me very confused. Here is a little thought and try to solve the problem. If you have ...

General database role privilege handling in SQL Server   Recently, we have been doing database privilege cleanup with colleagues, mainly by deleting some accounts, removing the larger privileges of some accounts, etc. For example, some have db_owner privileges, we remove the database role db_owner of the accounts and grant the minimum required ...