随笔分类 -  Database - SQL Server

白话 Microsoft SQL Server 的 index seek, scan, lookup
摘要：拿 select * from users where name like 'acme%' 举例， 在name上有非聚集索引。 Seek 翻译成定位更合适，上面的SQL直接在索引定位到该 Entry. Scan 如果 Users表很小，或者返回大量的数据；索引一个一个定位慢，还不如 从头到尾 Sca 阅读全文
posted @ 2022-05-10 12:01 tang88seng 阅读(211) 评论(0) 推荐(0)
SQL SQL Index SEEK VS Lookup
摘要：SEEK - find everything from index Lookup - find key from index, then visit table to find other row data. http://www.theboreddba.com/Categories/indexes 阅读全文
posted @ 2019-07-17 14:11 tang88seng 阅读(362) 评论(0) 推荐(0)
Docker Explanation and Apache Image
摘要：https://blog.sajjan.com.np/2017/02/05/docker-getting-started-containers-ubuntu/ https://blog.sajjan.com.np/2017/02/06/docker-running-apache-web-server 阅读全文
posted @ 2017-12-11 20:33 tang88seng 阅读(162) 评论(0) 推荐(0)
SQL Server tables export/import with bcp
摘要：Export tables below Import above data to existing tables 阅读全文
posted @ 2017-01-09 12:44 tang88seng 阅读(276) 评论(0) 推荐(0)
SQL Server Lock Escalation - 锁升级
摘要：Articles Forward from Locking in Microsoft SQL Server (Part 12 – Lock Escalation) Today I’d like us to talk about Lock Escalation in Microsoft SQL Ser 阅读全文
posted @ 2016-11-30 10:59 tang88seng 阅读(887) 评论(0) 推荐(0)
Microsoft SQL Server
摘要：instance / database / schema / objectlogin / user / schema (dbo)sequenceCollationPSM: Both Instance and DB need case insensitiveWindchill: Both Instan... 阅读全文
posted @ 2015-08-29 23:57 tang88seng 阅读(309) 评论(0) 推荐(0)