x****a
发帖数: 6 | 1 I've checked from internet that the price for MSSQL server are
very different among different products.
My company has about 30 ppl to access the server often. Which
product is suitable then?
Thanks! |
|
f****y
发帖数: 70 | 2 DB is MS SQL7.0, OS is Win2000 Server. The
problem is that Chinese characters can not insert into
DB correctly. Could you pls help me how Can we solve
the problem?
thanks a lot. |
|
a*****a
发帖数: 438 | 3 use unicode
or choose correct colation.. |
|
a*****i
发帖数: 4391 | 4 use SQl command to back up a database?
MIT to MITbackup |
|
a*******s
发帖数: 324 | 5 假设有两个MSSQL SERVER(A,B)，各自都存有相同的一个数据库D(相同的tables,table 内
容不同），如何将SERVER B中的数据库定期的和进SERVER A 中的数据库（只保留不同的
内容）。
先谢过了！ |
|
S*********e
发帖数: 7 | 6 不小心drop掉一个table，并且没有begin transaction，不知道还有没有办法rollback回
去？database是昨天的backup，要restore的话，今天的data就完蛋了。 |
|
h**h
发帖数: 132 | 7 wasn't he asking diff btw mssql and mysql? |
|
t*****s
发帖数: 124 | 8 is MS SQL Server?
if yes, then \SQLHome\MSSQL\LOG\ERRORLOG |
|
s******n
发帖数: 45 | 9 Basically u r intested in "audit". The log file won't be easy to look into,
but there are tools out there that can help u do that. One of them is as
follows:
http://www.sql-server-performance.com/lockwoodtech_log_navigator_spotlight.asp
Btw, an earlier post told u about the errorlog, which is not the log u r
looking for. The right one is in ....\mssql\data\[database name]_log.ldf |
|
WB
发帖数: 170 | 10 显示的日期竟然连毫秒都显示,可我只要显示到天就可以了 |
|
|
f*****g
发帖数: 15860 | 12 ORACLE的一般都是老手霸着，别人新手很难插手。
MSSQL的相对好很多，很多人一半DEVELOPER一半DB的干。 |
|
c*****d
发帖数: 6045 | 13 nod
ORACLE的一般都是老手霸着，别人新手很难插手。
MSSQL的相对好很多，很多人一半DEVELOPER一半DB的干。 |
|
m******y
发帖数: 588 | 14 I have two jobs which will both drop the tables in the same destination
server and copy tables with same names from different servers to the same
destination db on that third server as illustrated below:
JOB A: did a set of steps and then drop table a, b, c, d, e ... from
database abc on Server 3 and copy table a, b, c, d, e, ...from database abc
on Server 1 to the database abc on Server 3
JOB B: did a set of steps and then drop table a, b, c, d, e ... from
database abc on Server 3 and copy tabl |
|
a*******t
发帖数: 891 | 15 from access, File -> Import |
|
n****c
发帖数: 13 | 16 access有直接从Excel输入数据的功能，但是我不提倡用。因为这个方法老丢数据。比
较可靠的办法是，把Excel存为tab delimited文本文件(text file),然后用数据输入的
办法输入到Access. |
|
|
a*******t
发帖数: 891 | 18 process it as string, and do string search |
|
|
t*****g
发帖数: 1275 | 20 Hard to find big companies using MSSQL.
end,
heard
many
of |
|
k***e
发帖数: 7933 | 21 not true anymore.
even NASDAQ's MDDS moved MSSQL exclusively |
|
j*****n
发帖数: 1781 | 22 how big do you think is "big company"?
as I know, lots of wall street firms are using MSSQL. |
|
j*****n
发帖数: 1781 | 23 not sure for mysql, but for MSSQL, if you specify a primary key, it will
automatically create a clustered index for you.
anyway, indexing is different thing with your PK...
get your knowledge updated by read some database fundamental books please. |
|
j*****n
发帖数: 1781 | 24 en, maybe you right, I just suppose that lz's table has no PK and indexes
yet.
btw, you can specify do not create clustered index for PK by default. it was
critical issue for MSSQL 6.5 when creating highly transactional OLTP. e.g.
1,000 inserts/second. it will cause "hotspot" problem when PK with clustered
index.
of course, it is already the history, just mention it for fun. :)
when you see some DB under such scenario, you can say, ha, it was originally
created under 6.5 version! |
|
j*****n
发帖数: 1781 | 25 I tried in MSSQL, seems it is the best solution... |
|
j*****n
发帖数: 1781 | 26 if MSSQL Server,
run a trace and try to capture the long running queries.
eg. RPC:completed, SP:completed sp:stmtcompleted
setup duration >=500
run perfmon, see if ur production under any pressure: cpu, memory, disk i/o.
..
google will be ur best teacher and friend.
good luck |
|
j*****n
发帖数: 1781 | 27 it would not be the case in MSSQL. except dynamic SQL, SP is pre-compiled
and the execution plan is fixed unless statistics changes. |
|
n********6
发帖数: 1511 | 28 Would you explain a little bit how to use temp table and not use cursor in
this case?
Can you provide any comments if I do in this way? (MSSQL)
IF OBJECT_ID('TEMPDB..TEMPTABLE') > 0
DROP ##TEMPTABLE
CREATE ##TEMPTABLE
CREATE INDEX ... (IF NECESSARY, NONCLUSTERED PREFERRED IN GENERAL)
DECLARE CURSOR
OPEN CURSOR
FETCH CURSOR INTO @COLUMN_1, @COLUMN_2, @COLUMN_3
WHILE (@@FETCH_STATUS = 0)
SELECT FUNC(COLUMN_1, COLUMN_2), COLUMN_3
INTO (COLUMN_A, COLUMN_B)
FROM ORIGINAL_TABLE
FETCH NEXT FROM CURSOR |
|
w*******e
发帖数: 1622 | 29 干嘛买Enterprise Edition呢?? Standard Edition就能Replication, 价格还便宜 |
|
l********n
发帖数: 200 | 30 Standard Edition 是不是只有Pubisher-Subscriber 单方向的？
我们原计划采用Peer to Peer Replication，所以得买Enterprise。
据说有很多软件提供 Database Replication，不知这里是否有人用过？ |
|
j*****n
发帖数: 1781 | 31 很贵么？$25,000/physical CPU. 比 Oracle 如何？
要不查查sybase 什么价。 |
|
l********n
发帖数: 200 | 32 价格这事我不清楚，也不是我能决定的。现在整个部门都在抱怨微软的执照太贵，可能
有点理由。另外就是大家都觉得这个数据库没有什么东西，用个MySQL都足够了。
我现在就想找个软件，不行就准备全换MySQL。 |
|
w*******e
发帖数: 1622 | 33 CDC?? 俺咋觉得也不怎么样呢??---(因为多出了些CDC table(s)..)
CDC在运作时先在source server里生成CDC table(s), 然后用Query functions把
changed data给移到另一个server上....
(看着跟replication差不多, 只是多了个CDC table(s)...) |
|
|
z***y
发帖数: 7151 | 35 What is the exact business requirement here? Does your company want to do
load balance on sql server or on the web server? |
|
l********n
发帖数: 200 | 36 公司设想在西部再整一套服务器（网站/数据/搜索），接受西部和美国以外的顾客。中
部和东部的顾客还是连现在的服务器。两套服务器上的订单需要相互更新。
另外东部数据库里的产品每天更新，需要上载到西部数据库。
大家帮忙看看什么方法比较合适？ |
|
|
|
B*****g
发帖数: 34098 | 39 说说和mysql比。另外你们为啥不用free的mysql？ |
|
d*h
发帖数: 2347 | 40 for enterprise version MySQL is not free anymore...and it is expensive... |
|
B*****g
发帖数: 34098 | 41 Q1: why not use free version?
Q2: How MS SQL can be cheaper than or similar to MySQL? |
|
d*h
发帖数: 2347 | 42 A1. Any software contains bug, even Oracle is very very buggy; for
Enterprise app, you want to vendor to fix the bug or guide you to avoid the
issues,you don't want to spend time fix it yourself, that is called service,
and it is not free.
A2. MS SQL is at least a complete database, MySQL is not complete yet...
stored procedure, triggers, views, cursor etc only added to MySQL very
recently. |
|
f*****e
发帖数: 5177 | 43 redistribution of mysql is NOT free.
根据sun和ms的报价，mysql比sqlserver大概要贵一倍。
而且mysql还是没有support的community version |
|
|
|
|
t*****s
发帖数: 124 | 47 MySQL community version not free?
AFAIK, only enterprise version is NOT free. |
|
f*****e
发帖数: 5177 | 48 Depends on what license mode do you use.
Read their license agreement. |
|
a*******t
发帖数: 891 | 49 I think they charge by physical CPU, not by core. so, 4 x quard core counts
as 4 CPU
I am not 100% sure. you may want to double check.
CPU |
|
l********n
发帖数: 200 | 50 这样说来，MSSQL没有保留这些记录，除非管理员自己想办法。
我觉得如果有个系统的Table/View记录所有用户的Table/View/StoredProcedure/
Function的修改时间和账号挺方便的，也很容易实现。不知为什么MSSGQL不愿意保留这
些记录？
Not |
|
