Category：MsSql
-
Time：2020-1-22
Yesterday, I installed a SQL2000, opened the enterprise manager, and found that there was nothing under the SQL server group, indicating “no project”. Before SA set is empty password did not encounter this phenomenon, SA user set password this time appear this situation! Resolvent Open enterprise manager, as shown in the following figure. Right click […]
-
Time：2020-1-22
Connect SQL Server from Linux Client using Windows Authentication and troubleshoot steps
-
Time：2020-1-21
To view the locked table: select spId from master..SysProcesses Where db_name (dbid) = ‘database name’ and spId <> @@SpId and dbID <> 0 Unlock: exec (‘Kill ‘+cast(@spid as varchar)) To view the locked table: select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type=’OBJECT’ SPID lock table process Tablename locked table name Unlock: declare @spid int Set […]
-
Time：2020-1-21
When connecting to the SQL Server local server, the following error is reported: Title: connect to server ———— unable to connect to localhost. —。。。。。 Open the windows service management interface (Win + R key,) Then find Just connect again
-
Time：2020-1-19
About sqlserver 9003 error resolution only for SQL2000: Unable to open new database ‘pos’. Create database aborted. (Microsoft SQL server, error: 9003)“ Looking at the 9003 error, I think it may be due to the log file. Looking at the database file, I think of the DBCC CHECKDB instruction The method is as follows: 1. […]
-
Time：2020-1-19
This article is the author’s first original article in InfoQ. It is mainly written in succession by using weekend time, and it is also considered as a recent work. Now reprinted back to their own blog, please give us more advice. On November 4, Microsoft officially released its new generation of database product SQL Server […]
-
Time：2020-1-18
SQL Server compilation and recompilation Meaning of compilation When SQL server receives any instruction, including query, batch, stored procedure, trigger , the prepared statement and the dynamic SQL statement need to complete the syntax interpretation and statement interpretation, Then compile to generate the execution plan that can run. During compilation, SQL server will estimate the […]
-
Time：2020-1-18
Summarize the most commonly used SQL statements 1. Special date SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0) SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE())+1,0) SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0) SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0) SELECT DATEADD(dd,-1,DATEADD(mm,DATEDIFF(mm,0,GETDATE())+1,0)) SELECT DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0) SELECT DATEADD(dd,-1,DATEADD(yy,DATEDIFF(yy,0,GETDATE())+1,0)) 2. String processing SELECT LTRIM(col1),RTRIM(col2),LTRIM(RTRIM(col3)) FROM tableName SELECT SUBSTRING(col1,3,2) ,STUFF(col2,3,2,”) ,STUFF(col3,3,2,’XXX’) ,REPLACE(col4,’old’,’new’) FROM tableName Select stuff ((select ‘,’ + col1 from tablename where filter condition for XML path […]
-
Time：2020-1-17
Sqlserver English word full word matching Environment: vs2013 + SQL server2012 Problem: now the database records are as follows: The sentence column stores English sentences. Now I want to find out all sentences containing “I” (word). If I use sentence like ‘% I’ as a condition, then the word “it” (case insensitive) selected as […]
-
Time：2020-1-17
Realcase: Failed to upgrade SQL Server 2016 SP2 CU11. (Installation success or error status: 1648)
-
Time：2020-1-16
Sqlserver 9003 error resolution only applies to SQL2000 (SQL2000 only) Unable to open new database ‘pos’. Create database aborted. (Microsoft SQL server, error: 9003)“ Looking at the 9003 error, I think it may be due to the log file. Looking at the database file, I think of the DBCC CHECKDB instruction The method is as […]
-
Time：2020-1-15
Recently, colleagues reported that in the process of using Pt heartbeat to monitor master-slave replication latency, if the master is down, Pt heartbeat will fail to connect, but will try again and again. It’s OK to try again. After all, from the user’s point of view, I hope Pt heartbeat can try again and again […]
