SQL Server
文章平均质量分 84
warlock333
这个作者很懒,什么都没留下…
展开
-
DBCC CHECKDB and repair
TopicWhen a database is corrupted, we will alwayssuggest restoring last known good database backup instead of running DBCCCHECKDB command to fix it. Can you explain why? Try to use a demo to show wh原创 2012-08-12 03:23:47 · 1934 阅读 · 0 评论 -
Something about deadlock
TopicExplain what is Deadlock?Give examples and explain how you can resolve it. Try to use what you havelearnt to provide more than one solutions.AnswerWhat is deadlockA deadlock o原创 2012-08-12 03:31:43 · 446 阅读 · 0 评论 -
What does the collation influence the database ?
What does the collation influence the database ? --在insert数据时,一般的,字符会根据该column的collation进行解析,随后将解析后varbinary存入数据库----如果插入的字符无法在collation对应的page中查找到,则会变为'?'(3F)--随后在读取数据时,一般的,字符会根据该column的colla原创 2012-08-12 02:51:08 · 522 阅读 · 0 评论 -
SQL Server Statistics AUTO_UPDATE_STATISTICS
It is known that the necessities for SQL Server auto updating statistics is as followedIf the table has no rows, statistics is updated when there is a single change in table.If the number of row原创 2012-08-31 15:33:21 · 1236 阅读 · 0 评论 -
Parameter Sniffing
What is the Parameter Sniffing• Parametersniffing is the process whereby SQL Server creates an optimal planfor a stored procedure by using the calling parameters that are passed thefirst time原创 2012-08-31 15:56:31 · 804 阅读 · 0 评论 -
Kerberos
简介Kerberos是一种验证机制,最先由MIT提出和实现,之后被运用到windows的认证机制中。Windows是从windows 2000时才开始将Kerberos作为默认首选验证方式,先前使用的是一种叫做NTLM(challenge-response)的验证机制。Kerberos采用对称密钥体制对信息进行加密。其基本思想是:能正确对信息进行解密的用户就是合法用户。用户在对应用服务原创 2012-08-31 16:09:28 · 1069 阅读 · 0 评论 -
Difference between OLTP and OLAP.
Difference between OLTP andOLAP Generally speaking, data in an OLTP database is generallyorganized into relational tables to reduceredundant information and to increasethe speed ...原创 2012-08-12 02:39:42 · 233 阅读 · 0 评论