Chuck Lu

摘要： Cookie Category Cookie category definition (noun) A cookie category is a set of cookies defined by their function. Cookie categories may include perfo 阅读全文

摘要： cannot apply the specified columns kentico Pagination in union query of two page type The error has 2 specific messages in it: [SqlHelper.ReplaceColum 阅读全文

摘要： System.NotSupportedException: [DataTypeManager.GetFieldType]: SQL type 'datetimeoffset' is not registered, register the type with method RegisterDataT 阅读全文

摘要： How .NET Standard work A little journey under the hood of .NET Standard implementation If you deal with Microsoft technologies you’ve probably heard a 阅读全文

摘要： Deleting 1 millions rows in SQL Server I am working on a client's database and there is about 1 million rows that need to be deleted due to a bug in t 阅读全文

摘要： Get size of all tables in database 回答1 SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows, SUM(a.total_pages) * 8 AS TotalSpaceKB, CAST(ROUND((( 阅读全文

摘要： Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x64.dll' Take a look at the following two references: Unable to load native SNI (Server Name Indicati 阅读全文

摘要： What is the difference between SqlCommand.CommandTimeout and SqlConnection.ConnectionTimeout? Is there any difference between SqlCommand.CommandTimeou 阅读全文

摘要： Reference Microsoft.SqlServer.Smo.dll I need to use Server class which is stored in Microsoft.SqlServer.Smo.dll I don't see this assembly in usual Ref 阅读全文

摘要： Execute a large SQL script (with GO commands) I need to execute a large set of SQL statements (creating a bunch of tables, views and stored procedures 阅读全文