适合 Oracle 开发人员/dba 的 SQL Server
我有几年使用 Oracle 进行开发的经验，现在已经转到他们使用 SQL Server (2005) 的地方。 对于像我这样有背景的人来说，哪里是学习 SQL Server 查询优化、基本 dba 知识和 SQL Server 陷阱等知识的好地方。
谢谢！
I have a few years experience developing with oracle and have now moved to a place where they use SQL server (2005). Where would be a good place to learn things like SQL Server query optimisation, basic dba stuff and sql server gotchas for someone with my background.
Thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
这本书非常有用，因为它同时具有 Oracle 和 T_sql 语法
由 O'Reilly
Cursors 出版的 Kevin 和 Daniel Kline 所著的《SQL in a Nutshell》对于具有 Oracle 背景的人来说可能是一个问题，因为据我了解，它们在 Oracle 中经常使用。 SQL Server 不喜欢它们，而且它们是性能的大杀手。
有几本关于 SQL Server 性能调优的书籍。 快速浏览一下亚马逊应该会让您了解很多。Red
-gate 提供了用于比较数据库的良好工具，并且还有许多您可能想要查看的免费内容。 http://www.red-gate.com/
这里有一些关于 SQL Server 的好内容，尤其是在维基百科区域。 我认识许多作者，其中一些人在非常大的 SQL Server 环境中工作，并且都是非常聪明的人。
http://lessthandot.com/
This book is really useful becaseu it has both Oracle and T_sql syntax
SQL in a Nutshell by Kevin and Daniel Kline published by O'Reilly
Cursors can be an issue for someone coming from an Oracle background because it is my understanding that they are used frequently in Oracle. SQL Server doesn't like them and they are big performance killers.
There are several books on SQL Server performance tuning. A quick loo at AMazon should get you a bunch o fthem
Red-gate provides good tools for comparing databases and also has a lot of good free content that you might want to check out. http://www.red-gate.com/
Some good content on SQL Server here, especially in the Wiki area. I know many of the authors and some of them work in very large SQL Server environments and are very smart people.
http://lessthandot.com/
我同意 hlgem 的观点。
我想补充一点，你会感到非常震惊。 SQL Server 的体系结构与 Oracle 显着不同。 您是从 DBA 还是开发人员的角度来看待这个问题的？
在进入优化器之前，首先了解 SQL 中的锁管理器和锁升级。 它与 Oracle 完全不同，您在 Oracle 时代可能抱有的大多数假设都会让您感到沮丧。 最好从大局中了解锁管理器的工作原理，从而限制您可以做的事情。 至少这样您将知道如何在 SQL 中制定解决方案，而不是根据您的 Oracle 经验进行尝试，而稍后必须进行修改。
话虽如此，请提取所有数据库系统的真实情况，并在 SQL 工作中依赖它。 DB 技术的所有首要原则仍然适用于 SQL，并将帮助您进行开发、调优和故障排除。
祝你好运。
I concur with hlgem.
I would add that you are in for a big shock. The architecture of SQL Server is dramatically different from Oracle. Are you coming at this from a DBA perspective or a developer?
Before you jump into the optimizer, first learn about the lock manager and the escalation of locks in SQL. It is radically different than Oracle and most of the assumptions you are likely to harbor from your Oracle days will produce frustrations for you. It is best you learn from the biginning how the lock manager works and thus limits what you can do. At least then you will know how to craft a solution in SQL instead of making an attempt based on your Oracle experience that just will have to be modified later.
Having said that, distill what is true of all DB systems and rely on that in working in SQL. All the first principles of DB technology still apply with SQL and will help you in developing, tuning and troubleshooting.
good luck.