使用SQL Server进行性能调整(Performance tuning with SQL Server)
我试图联系我正在阅读的关于SQL Server查询性能的书籍的作者,但似乎本书中提供的电子邮件地址不再存在。 所以我决定问社区。 我正在粘贴我在下面写到的那些问题。 提前致谢。
======
我已经购买了你的书(SQL Server 2008 Query Performance Tuning Distilled),并且知道我的SQL Server Express Edition将不支持我需要运行必要的性能测试的许多重要工具。 正如您所说,重要的是要有初步的分析来检查有多少查询会影响数据库性能。 由于我没有配置文件,所以我不知道。 我已经下载了一个免费的项目工具,但我恐怕没有得到我需要的信息。 在我看来,使用SET STATISTICS时应该显示的信息也不会出现在SQL Server Express中。
SQL Server的最低版本将为我提供运行本书中建议的测试的工具? 是开发版吗? 它是否提供我需要的所有东西以便遵循这些示例?
另外,在Express Edition的基础上安装新版本(如Developer Edition)还有什么问题吗? 或者我必须卸载以前的版本?
我希望我没有太多困扰。 我还要祝贺你就这样一个重要话题撰写的伟大着作。
I was trying to contact the author of a book I am reading on SQL Server query performance, but it seems the e-mail address provided in the book does not exis any more. So I decided to ask the community. I am pasting the messasge I had written below. Thanks in advance.
======
I have bought your book (SQL Server 2008 Query Performance Tuning Distilled) and got to know that my SQL Server Express Edition won't support many of the important tools I will need in order to run the necessary performance tests. As you have said, it is important to have an initial analisys to check how much queries are hurting database performance. Since I don't have profiler, I cannot know. I have downloaded a free project tool, but I am afraid I am not getting the information I need. And it seems to me, the information that should be shown when using SET STATISTICS won't appear in SQL Server Express either.
Which is the lowest version of SQL Server that will offer me the tools to run the tests suggested in the book? Is it Developer Edition? Does it offer everything I need in order to follow the examples?
Also, is there any problem to install the new version (like Developer Edition) on top of Express Edition? Or do I have to uninstall the previous version?
I hope I am not bothering much. I would also like to congratulate you on the great book on such an important topic.
原文:https://stackoverflow.com/questions/1806749
最满意答案
在Ajax响应文件中,您可以再次删除并初始化tinyMCE。 所以在response.js或者我的情况下,update.js你需要这个代码:
tinymce.remove(); tinimce.init({ selector: "textarea" plugins: ... ... });
当在页面上使用新注释再次呈现页面时,这非常有效。 如果你想编辑新的或现有的评论,tinymce仍然可以工作。
希望这可以帮助其他可能正在寻找相同问题的人。
On the Ajax response file, you can remove and init tinyMCE again. So in response.js or in my case, update.js you need this code:
tinymce.remove(); tinimce.init({ selector: "textarea" plugins: ... ... });
This works perfect when rendering the page again with new comments on the page. And if you want to edit the new or existing comment, tinymce will still work.
Hope this helps someone else that may be looking for the same question.
相关问答
更多-
通过本地客户端程序获取服务器mysql数据库信息[2023-04-27]
ajax -
我想你想看看这篇文章: 如何让TinyMCE在UpdatePanel中工作? 确保向scriptmanager注册init函数 ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), mce.ClientID, "pageLoad();", true); Well there were two ways I got this to work, which really didn't fix the prob ...
-
在Ajax响应文件中,您可以再次删除并初始化tinyMCE。 所以在response.js或者我的情况下,update.js你需要这个代码: tinymce.remove(); tinimce.init({ selector: "textarea" plugins: ... ... }); 当在页面上使用新注释再次呈现页面时,这非常有效。 如果你想编辑新的或现有的评论,tinymce仍然可以工作。 希望这可以帮助其他可能正在寻找相同问题的人。 On the Ajax response file ...
-
初始化Tinymce的问题(Problems with initialize Tinymce)[2023-10-03]
这很容易做到。 在初始化tinymce之前,确保tinymce源元素包含所需的内容。 另一种选择是在初始化后设置tinymce内容。 tinymce.init({ selector:'textarea.tiny', height: 600, plugins: [ 'advlist autolink lists link image charmap print preview anchor', 'searchreplace visualblocks cod ... -
Yii和TinyMCE与ajax(Yii and TinyMCE with ajax)[2023-08-14]
在使用ajax提交结果之前,需要将内容从编辑器保存到textarea。 有关保存的详细信息,请参阅此文档 例如: tinyMCE.get('TinyMCEId').save(); You need to save the content from editor to textarea before you submit the result using ajax. See this documentation for detail on save. eg: tinyMCE.get('TinyMCEId') ... -
AJAX更新rails变量(AJAX update rails variable)[2021-09-24]
你要求Rails> = 3相当于“定期调用remote”(旧的Rails 2 Prototype方法)。 所以这里: Rails 3等价于periodic_call_remote You're asking for the Rails >=3 equivalent of "periodically call remote" (an old Rails 2 Prototype method). So here: Rails 3 equivalent for periodically_call_remote -
这里的问题是,如果没有正确关闭内部tinymce实例,关闭方框会导致第二次不显示编辑器(因为变量window.tinymce.editors中仍然有一个tinymce编辑器对象)。 解决方案 :关闭(实际上在销毁或移除之前)关闭编辑器。 Problem here is that closing the box without shutting down the inner tinymce instance properly will result in not showing the editor the ...
-
我不知道为什么那段代码停止工作......但我现在已经发现没有page.select块,它仍然会工作并用这些类名替换所有的div。 I don't know why that block of code stopped working...but I've now figured out that without the page.select block, it will work anyway and replace all of the divs with those class names.
-
TinyMce rails插件错误(TinyMce rails plugins error)[2022-10-08]
tinymce插件列表(使用tinymce4!)需要看起来像这样(带括号) plugins: [ "advlist autolink lists link image charmap print preview anchor", "searchreplace visualblocks code fullscreen", "insertdatetime media table contextmenu paste" ], The tinymce plugin list (using t ... -
要修复我的问题,我必须编辑路由器操作,如下所示: edit: (id)-> @model = @collection.get(id) view = new Notes.Views.ArticleEdit(model: @model) $('#container').html(view.render().el) el_id = "article_body" + @model.get("id") if (tinyMCE.getInstanceById( ...