经验首页
MS SQL ServerSQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/20]
Excel 数据导入至Sqlserver 数据库中 ltrim() 、rtrim() 、replace() 函数 依次空格无效问题
今天导一些数据从Excel中至Sqlserver 数据库中，在做数据合并去重的时候发现，有两条数据一模一样，竟然没有进行合并； 最后发现有一条后面有个“空格”，正是因为这个“空格”让我抓狂许久，因为它是个假“空格”...[2020/5/20]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/19]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/18]
数据库实验系列之1数据库及数据库中表等数据库对象的建立实验（包括关系图、完整性、权限控制、视图、索引等内容）--security--
目录实验1 SQL Server的安装安装过程展示实验2 设计数据库、创建数据库和数据表实验5 视图实验6 完整性约束实验7 权限管理附 创建market表，后续将会使用 实验1 SQL Server的安装 实验目的 掌握SQL Server安装的硬件要求和系统要求。 熟...[2020/5/18]
数据库实验系列之2数据库上的基本操作实验（针对表、视图及不同权限用户的增、删、改、查及数据库的备份和恢复）--security--
目录实验3 数据库的简单查询和连接查询实验4 数据库查询和数据操纵实验8：数据库备份与恢复实验 实验3 数据库的简单查询和连接查询 实验目的 掌握无条件查询的使用方法。 掌握条件查询的使用方法。 掌握库函数及汇总查询的使用方法。 掌握分组查询的使用方法。 掌握查询的排序方法...[2020/5/18]
数据库实验系列之3存储过程和触发器实验（至少包括完整的调试通过的8个存储过程和5个触发器）--security--
目录实验9：存储过程实验实验10：触发器实验 实验9：存储过程实验 自拟题目完成8个存储过程的编写及调试，熟练掌握存储过程的使用。也可采用下图中作业上的题目。 SQL语句代码 --1.例1 use 学生作业管理数据库; select * from 学生表; select * f...[2020/5/18]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/18]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/18]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/18]
SQL Server 2017错误日志中出现“Parallel redo is shutdown for database 'xxx' with worker pool size [2]."浅析
在SQL Server 2017的错误日志中出现"Parallel redo is started for database ''xxx'' with worker pool size [2]"和“Parallel redo is shutdown for databas...[2020/5/18]
一个简单的交叉报表_列转行
--列转行小实例 --创建测试表 if object_id(N''test'', N''U'') is not null drop table test go with UnPivotTable as ( select 1 as UserNO, ''33'' as A, ''4...[2020/5/18]
sql server 百万级数据库优化方案
1.对查询进行优化，应尽量避免全表扫描，首先应考虑在 where 及 order by 涉及的列上建立索引。2.应尽量避免在 where 子句中对字段进行 null 值判断，否则将导致引擎放弃使用索引而进行全表扫描，如：select id from t where num is nu...[2020/5/11]
YourSQLDba低版本的一个Bug的浅析
帮人分析解决一个YourSQLDba备份报错问题，个人觉得有点意思，顺手记录一下分析思路，大体解决思路如下： 首先，找到YourSQLDba作业YourSQLDba_FullBackups_And_Maintenance的报错邮件或者作业的错误日志信息，检查YourSQ...[2020/5/9]
sqlserver 数据库迁移
业务情景 客户环境是系统A的1.0版本，开发环境是系统A的2.0版本。2.0版本对于数据库有部分变更（主要是新增表和字段，不涉及字段删除和变更）。这个时候需要在客户环境安装数据库2.0（表结构、存储过程都是用的2.0），但是数据要把1.0的同步过来。 ...[2020/5/7]
sql某个日期是当年的第几周
/* *周一作为一周的开始 *当年的1月1号所在的周算作第一周 */ CREATE function GetWeekIndexFirstDate ( @date datetime ) returns int as begin /* *计算逻辑 *1.先找出当年的1月1号@fi...[2020/5/7]