sql server
数据库
2026-03-22 11:12 浏览次数 25
数据库
important: it is important that, for performance and stability reasons, your sql server has a database maintenance plan configured.
重点:由于性能和稳定性原因,重要的是,您的sql服务器配置了一个数据库维护计划。
however, if you are using a sql server instance called 「instance1」 on a server called 「myserver」 then you would need to use the tcp port number of the instance, such as: myserver:1434
但是,如果您在一个名为 「myserver」 的服务器上使用一个名为 「instance1」 的sql服务器实例,则需要使用该实例的tcp端口号,比如myserver:1434。
to begin with, the ncb file will be replaced with a sql server compact database. currently the entire ncb file needs to be loaded into memory, an expensive proposition in large projects.
首先,它的ncb文件将被替换为sql servercompact数据库,现在使用的ncb文件需要装载到内存中,对于大量项目来说,这是一个奢侈的前提条件。
fortunately, sql server compact edition and linq have made it easier for me to code a data app, even if i’m not involved with the code itself directly.
幸运地是,对我来说用sql server精简版和linq开发一个数据库应用程序的确十分的简单,尽管我没有直接使用它们这样做过。
ideally, the sql server should be running on a server dedicated to this task only.
理想情况下,sql服务器应该在一个针对这个任务的专用服务器上运行。
database objects can also be debugged through sql server projects. we will look at using sql server projects and how to use them to create and debug managed database objects in the next tutorial.
数据库对象也可以通过sql serverprojects来进行调试,在下一章我们将考察使用sql serverprojects,以及如何利用其来创建和调试管理数据库对象(manageddatabaseobjects)
naturally they chose to use ms sql server for their database and django does not support that database by default.
自然,他们选择使用了mssql server作为他们的数据库,而django默认是不支持该数据库的。
it replaces dts packages as one of the primary ways to move large amounts of data into and out of sql server from other data sources such as flat files and non-microsoft databases.
它代替dts包作为一个首要的方式,来把大量的数据从其他类似的平面文件和非微软数据库的数据源中移入到sql server中,或从sql server移出。
applications and databases developed on this edition can easily be upgraded to sql server 2008 enterprise.
基于这一版本开发的应用和数据库可以很容易地升级到企业版。
the next step is to restart the sql server service for the instance for the changes to take effect.
接下来的一步是为事例重启sql服务器以让变更产生效果。
for a connection name, type the sql server instance name.
对于连接的名字,您可以输入sql服务器实例名。
change the default storage location for the data/log files on the sql server at this point, to save time in the future.
此时更改sql服务器上的data/log文件的默认存储位置,以便将来节约时间。
ensure that the proper sql services are running on the sql server to allow remote access to the sql instance.
确认在sql服务器上运行了合适的sql服务以支持对sql实例的远程访问。
note: this performance counter is selectable during sql server installation.
注意:这个性能计数器可以在sql服务器安装过程中选择。
to do that, see the connection properties of datasource.rds. the database name should be c2 and test connection should be successful for the supplied sql server credentials.
确认这一点,只要查看datasource.rds的连接属性,该数据库的名称应该是c2,而且,与sql server的连接认证测试必须是成功的。
microsoft has made available sql server express, a free and limited edition of their database server, which can be used to test the server and applications using it.
微软已经提供了sql server快捷版,那是一个免费且功能有限的数据库版本,我们可以使用它来测试服务器和应用程序。
press ok to create a connection to the sql server instance.
点击ok以创建一个对sql服务器实例的连接。
before running this report with the next samples, please make sure that the report data source correctly references the sql server 2008 instance where the database sample is installed.
在使用此报表运行下一个示例之前,请确保该报表的数据源正确的链接到了已经安装有示例数据库的sql server2008实例上。
you cannot transfer a database from one sql server (to a different sql server) if the two servers have different server default collation settings.
如果两个sql服务器拥有不同的服务器默认校对设置,那么您不能将一个数据库从一个sql服务器传输到另一个sql服务器。
conversely, if a database user exists but there is no login associated, the user is not able to log into sql server server.
相反,如果存在数据库用户,但没有与其关联的登录,则该用户将无法登录到sql server服务器中。
in most circumstances, it is easiest to place this share on the sql server
在多数环境中,将这个共享放置到sql服务器上最简单
in figure 1, the tree view, shows a sql server instance called 「rsa」 running on a physical server with the hostname of ibm-max0q2aifg2.
在图1中的树形视图,显示了一个叫做「rsa」的sql服务器,它在一个物理服务器上运行并且主机名是ibm-max0q2aifg2。
enable remote connections for the sql server
激活对sql服务器的远程连接
select the sql server instance given to you by your database administrator, in this format: hostname\instance name.
选择数据库管理员向您提供的sql服务器,格式为:主机名\实例名。
from the drop-down menu, select the sql server instance, which is in the form of hostname\instance name.
从下拉菜单中,选择sql服务器实例,它的形式是主机名\实例名。
to address these and other issues, sql server 2008 moved full text search into the database.
为了处理这些和其他的问题,sql server2008把全文检索移到数据库中。