http://200yi.com/ff_internal/ 2026-04-28T01:13:17+0800 http://200yi.com/ff_internal/ http://200yi.com/ff_internal/lib/tpl/mnml-blog/images/favicon.ico text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:SQLServer:SQLServer%20Batch%20Mode&rev=1687008318&do=diff 1. SQL Server列存储 Columnstore index 列式索引也是一大特色，从SQL SERVER 2012起，支持列式索引了。我们要谈一谈列式索引的概念，用法，比较下与row-based index的区别，特别是列式索引的存储。据说列式索引采用了独特的压缩方式。这种压缩方式叫xVelocity(前称VertiPaq)，专门用于 Analysis Service和Power Pivot的数据存储，现将其移到relational database storage engine中来。 text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:SQLServer:SQLServer%20on%20Linux%E4%BD%BF%E7%94%A8%E5%9F%BA%E7%A1%80&rev=1687008318&do=diff 1. 安装SQL Server 2017 on RedHat 7.2 下载rpm包 https://packages.microsoft.com/rhel/7/ 安装SQL Server $ sudo rpm -ivh mssql-server-14.0.600.250-2.x86_64.rpm +--------------------------------------------------------------+ Please run 'sudo /opt/mssql/bin/mssql-conf setup' to complete the setup of Microsoft SQL Server +--------------------------------------------------------------+ text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:SQLServer:SQLServer%E6%97%A0%E6%B3%95%E5%88%A0%E9%99%A4%E6%95%B0%E6%8D%AE%E5%BA%93%E9%97%AE%E9%A2%98&rev=1687008318&do=diff SQL Server 删除数据库时，提示“无法删除数据库 "testdb"，因为该数据库当前正在使用。” 方法1 先尝试以下命令 use master go drop database testdb 如果仍然无法删除，可以在使用以下更强方法。