p***n
发帖数: 635 | 1 【 以下文字转载自 Java 讨论区,原文如下 】
发信人: payan (沛岩), 信区: Java
标 题: MS SQL Server JDBC Driver Problem
发信站: Unknown Space (Sun Aug 17 02:35:53 2003) WWW-POST
I am using MS SQL SERVER JDBC DRIVER under Weblogic 7 to call an MS SQL Server
stored procedure. The stored procedure returns a xml string like this:
...
...
...
so far so good.
the problem comes up when there is some characters like "'" is contained in
the string, e.g.,
Let's go and have fun
Then the SP c |
|
c*****t
发帖数: 3 | 2 主机（DB Server)：SCOUNIX＋sybase
仅是Server的IP地址改变(Query和Master端口号不变，Server
Name也不变），对/usr/sybase/interfaces做了相应修改，以使Sybase的网络地址与所对
应的主机IP地址一致。但修改此文件后，我发现服务器端还是不能正确响应客户端程序提
出的请求，是否还有其他文件或者环境变量需要修改。另外，我在/usr/sybase目录下还
发现了诸如interfaces.001,interfaces.002等好多个文件，不知道是不是也要做同样修
改。并不了解sybase数据库，没把握怕改了造成数据库瘫痪.
Thanks a lot! |
|
t******y
发帖数: 3 | 3 偶在SERVER A 上BACKUP 一个数据库 QWE 为文件QWE, 想移到SERVER B 上. B 上以前没
有QWE 数据库, 因此无法在企业管理器中的SERVER GROUP 上点右键用RESTORE完成. 试了
试用右键中的"附加数据库"命令, 但当我选备份文件QWE是报错:这不是SQL
数据库文件...既然是完全备份的,.MDF 和.LOG文件都应在QWE文件中了,对吧? 为什么不
能加上去呢? DTS 是各种不同类型DATA的转化用的, 好象不能用于移植吧? 请大吓指教.
谢谢. |
|
e********t
发帖数: 3 | 4 Hi, I have intalled MySQL on one of my computer and try to access it using
another machine inside the same LAN. Some info about the setup:
* The MySQL server's IP is 192.168.0.3 while the client machine is 192.168.0.6
* Both machine running WinXP Pro
* On the client machine, I am using PHPED's embedded MySQL support to try to
access the database on the server.
But it keeping telling me that I can not connect the server, and I have tried
the following things which didn't work:
* Add host address |
|
s****r
发帖数: 36 | 5 How does a Java application insert data into SQL server?
Can Java application talk to SQL Server directly via JDBC? If Yes, is JDBC
Driver included in SQL Server package?
Thanks for help! |
|
a*******t
发帖数: 891 | 6 SQL Server 2005 will launch the week of November 7th, 2005. Visual Studio 2005
and BizTalk Server 2006 will launch at the same time. He also announced that
Report Services will be available in all editions of SQL Server and Report
Build will be available in Workgroup, Standard and Enterprise Editions
http://www.microsoft.com/presspass/misc/06-07flessner-teched05.mspx |
|
g******g
发帖数: 5 | 7 【 以下文字转载自 Linux 讨论区 】
发信人: guithing (qq), 信区: Linux
标 题: How to set mysql server to autostart as booting
发信站: BBS 未名空间站 (Tue Oct 25 17:35:45 2005), 转信
I followed the instructions in the
/usr/local/mysql/support-files/mysql.server
copy this file to /etc/init.d
and then linked it to the following two files:
/etc/rc3.d/S99mysql /etc/rc0.d/K01mysql
Then after I reboot my PC, mysql server does not
show up. The general way to startit up is:
/usr/local/mysql/bin/safe_mysqld --user=mysql & |
|
q****g
发帖数: 12 | 8 我用jdbc操作 sql server下的 database时，
遇到一个奇怪的现象：比如说一个简单的语句：
SELECT id, attr
INTO tempTB
FROM TB
WHERE (...)
ORDER BY attr
返回的tempTB 有的时候根本不是按照attr排序的，
确切地说，只是部分排序。比如说如果数据范围[1，1000]，
输出的结果可能是 992 993,...1000, 876，877，878，。。
我多run几次，有时候又能输出正确排序后的结果。
有人遇到过这种情况么？到底怎么回事啊？
难道是sql server安装有问题？
但是我的机器刚刚重装过，以前用这个sql server的安装文件
也装过，从来没有碰到过这种问题。 |
|
m******y
发帖数: 588 | 9 production DB is OLTP. We do want a OLAP to do the reporting. But because of
time constraints, we will only starts with OLTP dbs copying to offline
servers insteading of doing all reporting on OLTP dbs right now.
It's easy to get the backup of OLTP dbs and restore them on the offline
servers, but it seems not very efficient. If we want to make changes on
offilne server dbs like tuning index better for reporting, it has to be made
every time we restore them from production dbs. So I'm wondering h |
|
x***e
发帖数: 2449 | 10 If your DB is only used to record inserting data and seldom do delete or
update.
Then, you can record update/insert date as a seperate column.
Use "select into" to do incremetal load and
if your DB is big, you will have to think about table partition.
For OLAP reporting, do you need the data warehouse and mart at the same
server
or you need a data warehousing server and a mart server?
different approach will lead to different design.
restore backups is not a quite efficient way.
If you have to d |
|
b*h
发帖数: 353 | 11 我的机器是 XP HOME EDITION 的， 请问微软的 SQL SERVER 2005可以装在上面吗，
还是要求 PROFESSIONAL XP？
另外我在它的网站上看到 “Microsoft SQL Server 2005 Express Edition”和 “SQL
Server Management Studio Express”， 我应该装哪个？还是两个都要安装？
多谢了。 |
|
l********u
发帖数: 195 | 12 说具体点:
I wrote a query it select records from table 1 which has corresponding
records in table 2 and table 3. The query works fine on my machine (server
2005). I moved to clients Server (server 2000), the query works for most
cases, however there a few records get selected even they don't have any
corresponding records in table 2 and table 3 -- run select query on table 2
and 3 returns nothing. We can't figure out why this is happening? |
|
m**********o
发帖数: 58 | 13 俺朋友问俺。他的情况是用SQL server写的管理软件，其中有些数据可以根据用户的需
要删除。在没有备份的情况下，只有SQL server本身的log文件什么的，这些个被删除
的数据能被恢复出来么，比如像easyrecovery这样的工具？俺觉得应该不行吧，但俺没
什么SQL server的编程经验。请大虾给答答疑。谢谢。 |
|
c**t
发帖数: 2744 | 14 SQL server supports linked server, which could be other SQL server or Oracle. |
|
a*******t
发帖数: 891 | 15 有人可以解釋解釋
看來我需要添加一個“根” (Central management server?) 服務器，然後子服務器？
這 Central management server 做什麼樣的作用？ |
|
z***y
发帖数: 7151 | 16 这是一个判断DBA有没有一个好的习惯，是基本素质测试：
Your network team called for DBA's help. The network engineer maintains
their own SQL Server 2005 standard edition server. There are a few
databases running on that server. They used maintenance wizard to create a
couple of backup jobs. One is daily full backup job for all users' database
and one is log backup job running every 1 hour for all users' database. They
found that the log backup job has been failed since two days ago.
You review the job history and found t |
|
n********6
发帖数: 1511 | 17 发信人: zenny (智勇张肥头), 信区: Database
标 题: Re: sql server 面试题 （10）节日有奖
发信站: BBS 未名空间站 (Wed Dec 3 15:20:16 2008)
How do you do that if you have 50 servers to manage?
- Emails and/or pagers. (Never worked on that, please verify)
- However, there might be security concerns and the SQL Server may not have
SQLAgentMail to send emails because of specific company policy.
- And political issues that people might not like to be in the list to
receive such alert message and be responsible for that.
Are there |
|
B*****g
发帖数: 19 | 18 我觉得问题其实在于go是不是一个sql query. 也许Go只是sql server(我想你说得是MS
sqlserver，对吧）的一个软件命令，所以如果你通过ado让server按照sql来执行，恐
怕不行。
就好像dir是系统命令，如果你让ado传给sql server，不会通过。
不一定对，楼主参考。 |
|
d*******n
发帖数: 524 | 19 I need to run some queries on an Oracle database server and probably will
deposit some tables there for my running sessions.
However, due to the importance of the data on this server, it might not be
realistic for me to get a full writing access on the server.
So is it technically possible at all to give me some kind of "limited
writing access" so I can save my own tables there under some restriction
while I don't have the access to change the existing tables.
I've googled this but did not find |
|
gy
发帖数: 620 | 20 不敢苟同.
SQL Server用了和Oracle不同的概念而已, 比如min memory per query....
因为connection, data, log, stored procedure等都需要memory(or cache), 另外OS
也要一定的memory来正常运转, 所以SQL Server在能支配的memory范围里 dynamically
来管理这些memory suckers 以求到达最好的效果. 如果你把其中一项要求的memory固
定了, 那势必在某些情况下, 影响其他的需求(特别是当那固定memory的自己需求不大
时, 那固定的memory就浪费了), 从而影响整个SQL SERVER的performance.
Just 我的两分钱. |
|
|
c*******y
发帖数: 8 | 22 不应该是1433端口没有打开吧
因为S1的SQL Server是可以被本域内的所有机器可以访问的,如果端口没开肯定访问不
到吧
我唯一觉得是域的信任问题,也就是如果Domain A信任 Domain B,那么A里面的Sql
Server可以被来自B的机器访问,如果Domain B不信任Domain A,那么来自A的机器是不能
访问B的Server的.
现在要做两个域里面数据库的数据同步,头疼得很. |
|
gy
发帖数: 620 | 23 今天是我LD的生日, 我写点儿东东，就当是给她的生日礼物。
另外, zenny同学曾说是要写写blocking的东东, 我左等右等，望眼欲穿.
等不及了，我这块砖就先抛出来了吧。等着Zenny和其它大牛们更精彩的。
打小语文就没学好, 写不出zenny大牛那么好的东东. 各位将就着看吧.
**********************************************************************************
在一个Database Server上, 各种transaction是同时进行的, 为了保证transaction的ACID properties, SQL Server就用了一个lock manager来对各个transaction进行管理. 打个不是很恰当的比喻, 就好象十字路口的交通灯, 指挥着东南西北各方向的车通过. 也正是这样, 一个方向通过, 另一个方向的必然被block. 同样, 也就是说在SQL Server里blocking是没法避免的.
虽说blocking是没法避免的, 但是可以尽量减少it的发生, 比如, 缩短tr |
|
v*****r
发帖数: 1119 | 24 There you go. Spark just show one typical mindset conflict between Oracle
developers and SQL Server developers.
SQL Server developers: We think 管理层的人不懂,听locking变色. locking is
necessary and we can't live without it. Anyone who try to use "nolock hint"
to improve performance will have to worry about Dirty Read (as "nolock hint"
just changed the Isolation Level to Read Uncomitted)
(Note: that mindset is actually true before SQL Server 2005 Yukon release.)
Oracle developers: Oracle by design achiev |
|
M**********r
发帖数: 1087 | 25 我想请教一下，如果像俺这样对软件，硬件懂得极少的人， 想要两个月后考个SQL
Server 2008 的试 (70-432： Implementation and Maintenance SQL Server 2008)。
一周最多能花20小时学习。可行么？ 以下是俺的一些基本情况：
1。 对当DBA不感兴趣。 考试是想对老板有个交代
2。 对硬件认识极少。 完全不知怎么configure Windows Servers。
3。 能写，读SQL queries, stored procedures
4。 懂一些基本操作，例如set up jobs, db backup。 大概也差不多了。
谢谢!! |
|
g***l
发帖数: 18555 | 26 两边SERVER都设成LINKED SERVER,要MAP一个USER,MAKE SURE在LINKED的里面能看到另
一个SERVER的DB和TABLE |
|
m******y
发帖数: 588 | 27 你们都有单独的distributor server吗？ distributor server 用sql server
standard version 可以把？ |
|
i****a
发帖数: 36252 | 28 there should be a clone option at storage level.
detach disks, clone, attach new disks
server
server |
|
v*****r
发帖数: 1119 | 29 Not a sqlserver person， 但我想这种migration 不管是sqlserver 还是 Oracle, 步
骤大概是一样的。
用 Oracle 的话，如果没有 budget for two new servers, zero downtime 是不可能
的了，能 minimize 到一，两分钟的 downtime就不错了， 最好是在 SAN level 用
vendor provided tool to do online LUNs copy between old LUNs and new LUNs，
then at cutover time, shutdown database, do a final sync-split on SAN，mount
database, use scripts to rename all files to new location (whether it is
filesystem or Oracle ASM), open database. It is done.
不管是用 Oracle RAC 还是 single node ... 阅读全帖 |
|
u**d
发帖数: 211 | 30 选择 db 不仅仅看价格呀
从底层的 os，到 middleware，再到 applications，都是考量条件
ms sql server 可以便宜，那是因为要花 windows server 的钱
ms 不遗余力的推 .net，还是因为想让用户买 windows server
oracle 卖的好，我觉得和它几个 applications 很有关系
oracle 吞并 java，大概也是想在 j2ee 上拴住更多的客户 |
|
g***l
发帖数: 18555 | 31 1.你觉得SQL SERVER的内存不够了，你怎么告诉IT MANAGER内存不够了，用什么软件，
什么参数，什么COMMAND
2.MANAGER给你一个SQL SERVER 的TABLE，比如CUSTOMER，2MILLION RECORDS，要你
LOAD到自己的CUSTOMER TABLE里去，你怀疑有DUPLICATE，MANAGER不在，你又必须把
TABLE LOAD进去，你怎么处理呢
3.SQL SERVER DATABASE RECOVERY MODEL有几种，有什么不同，为什么要用某一种，我
有一个20TB每天都要全部REFRESH的DATAWAREHOUSE用哪一种
4.为什么要用CTE而不用TEMP TABLE，CTE和TABLE VARIABLE有什么不同
5.我有200个BACKUP每天都要做，我怎么知道哪个BACKUP没完成HANG了，或者FAIL掉了
。 |
|
i****a
发帖数: 36252 | 32 maybe most people are switching to oracle. 我快被 M$ 氣死了. 每個 SQL 版本都
有基本功能的 breaking changes
not just sql server, but their windows server, office, connection drivers
etc all have this shiiiity problem with every upgrade.
I've been spending most of my past 3 months fixing things that will break,
or already broke with SQL/windows server/office upgrades. |
|
B*****g
发帖数: 34098 | 33 As I know AEPX can install on Oracle HTTP Server or Application Server, but
who will install it on HTTP server? |
|
y****9
发帖数: 144 | 34 I use a Windows 7 company notebook for work. Recently per policy, I lost
admin privillege on the pc.
I am wondering if there a way to install a VM on the notebook, and then
install sql server on the VM, so I can have full control over the sql server
for study and testing purpose. It is not a problem for Oracle but I am not
familiar with SQL server world.
If you know how to do it, let me know the detailed steps, thanks! |
|
g***l
发帖数: 18555 | 35 可以做个REPLICATION FROM ORACLE TO SQL SERVER，然后用SSIS在SQL SERVER里LOAD，既然现在用SQL SERVER了，SSIS和REPLICATION应该熟悉了 |
|
l******t
发帖数: 660 | 36 北美华人SQL Server User group
Chinese in North America SQL Server User Group (CINASSUG)
CINASSUG：
https://groups.google.com/group/chinese-in-north-america-sql-server-user-
group-cinassug?hl=en
重要以数据库知识为主， 相关知识为辅助， 根据知识点和市场需要分为下边的track,
a. Application Dev, 包括database application development 以及相关的.NET
framework
b. DBA, 这个不用解释了
c. BI/DW architecture, 包括data warehouse architecture, data model, ETL,
d. BI Delivery, 包括sharepoint, SSRS, SSAS, excel service等
e. MS Professional Development, 微软技术职业规划，
f. Big ... 阅读全帖 |
|
|
c*****d
发帖数: 6045 | 38 【 以下文字转载自 Texas 讨论区 】
发信人: AcrossOcean (deepblueocean), 信区: Texas
标 题: 2 SQL SERVER Sr SQL Programmer positions
发信站: BBS 未名空间站 (Tue Jul 31 14:32:09 2012, 美东)
SQL programming/database manipulation and extraction
Create T-SQL stored procedures, SSIS packages, functions, triggers, views,
tables
Generate scripts on object in the database that will be delivered as a
prepackaged product solution.
Play a lead role in proactively identifying and fixing code that could cause
operational issues in produc... 阅读全帖 |
|
s**********o
发帖数: 14359 | 39 是可以的，但可能会遇到很多问题，再说你SQL SERVER的SCHEMA跟ORACLE一模一样么，
还是别人给做好了DATA MODEL，你往里灌数据呢，如果是灌数据，就得SSIS ETL了，
我很好奇为什么换系统，PERFORMANCE不好，还是ORACLE太贵了用不起，一般换系统，
我肯定走人的，换完了人就不要你了，我给一家从SQL SERVER换到ORACLE，用从ORACLE
换回SQL SERVER，还没换完就被LAY了，后来又看到几家换系统，一看是换系统就说明
公司有问题，LOL
So |
|
z***y
发帖数: 7151 | 40 For those 200+ servers they are all physical boxes.
I have another 100+ virtual server. The client use replication to copy the
virtual server over from one data center to another. |
|
g*****6
发帖数: 208 | 41 我用了SQL SERVER有10多年了吧.用过 SQL SERVER 7, 2000,2005,2008, 2012. 但多数
是写CODE. DBA的活可能我就只会做简单的BACKUP和导入导出,系统恢复,加人之类的吧.
现在想去考证,请问我该看什么书.
有没有什么优先级的,先考什么,再考什么之类的.两娃的大妈,还真没时间具体上课.我
现在用的是C#.NET 3.5 +SQL SERVER 2005, 2008, 2012.
谢谢.
具体的建议我会发仅有的包子来感谢的. |
|
h****p
发帖数: 25 | 42 1. mainframe: DB2
2. mini: oracle
3. pc server + linux: oracle/mysql
4. pc server+ windows: sql server
参考 tpc-c tpc-h |
|
x*****g
发帖数: 764 | 43 谢谢提供这个link,很多信息，虽然我多数都不懂，可能目前也用不上。在那个
security sector,我发现SQl Server Express 有basic auditing 的功能，但是没有
fine auditing的功能。但是我怎么就找不到在那里设这个database audit
specification. 我用的是SQL Server 2008 R2. 是不是版本不对。
另外，如果不费您太多时间的话，就把我第二个问题也一并回答了吧。我现在就是在用
JDBC编一个小java程序来管理一个很小的数据库。有那么几个人用这个数据库。就是希
望能够log一下数据库编辑的记录来防止别人干了“坏事”后赖账。用户是通过Java程
序support的界面来用数据库的。 |
|
l******t
发帖数: 660 | 44 Session: "Hekaton--SQL Server In-memory OLTP engine "
Time: 8/22/2013 8:30 PM (UTC-06:00) Central Time (US & Canada) for 120
minutes
Audience Log-in URL: http://www.anymeeting.com/SQLPassChinese1
Instructor: John huang, MCM, MVP
SQL Server In-memory OLTP engine, a.k.a code name Hekaton, is one of the
most exciting feature newly introduced to SQL Server 2014. This is the
technology to make your application to run 100x faster with minimum code
changes. In this session, we will discuss how it works... 阅读全帖 |
|
m******y
发帖数: 588 | 45 Our group has openings for 2 Senior SQL Server Database Engineers and 1
Junior position. Will sponor H1B and Greencard. If you are interested,
please contact m******[email protected]
Primary Responsibilities:
•Create databases from the ground up. Determine business requirements
, create logical models, build physical models and plan system architecture.
•Work with software engineers and data engineers to ensure the
overall application design is optimal.
•Conduct design and code walkt... 阅读全帖 |
|
w****n
发帖数: 266 | 46 公司现在租用一个online database server， 要求sql server装在D drive，所有数
据装在E drive。就是说D 上只有SQL SERVER一个软件空壳， 其他所有都要在E drive
里， 这样可行吗？ |
|
|
g***h
发帖数: 20 | 48 sql server纯新手。请问如何将远程sql server的数据都download到本地（csv或数据
库文件均可）？我在本地用sql server management studio 2008。
多谢多谢 |
|
b********e
发帖数: 74 | 49 想重装SQL Server 2005 developer edition. 不知为什么出现错误.无法安装OWC11.
好像是无法安装Office 2003 Web Components. Google了半天也不知道为什么.请教一
下这里的大牛.
=== Verbose logging started: 4/17/2014 20:26:58 Build type: SHIP UNICODE 3
.01.4001.5512 Calling process: C:Program FilesMicrosoft SQL Server90Setup
Bootstrapsetup.exe ===
MSI (c) (04:0C) [20:26:58:156]: Resetting cached policy values
MSI (c) (04:0C) [20:26:58:156]: Machine policy value 'Debug' is 0
MSI (c) (04:0C) [20:26:58:156]: ******* RunEngine:
******* Pro... 阅读全帖 |
|
l******9
发帖数: 579 | 50 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: set up data mining model in SQl server 2008 win 7
发信站: BBS 未名空间站 (Sat Jun 28 20:07:07 2014, 美东)
I would like to build up a data mining model in SQl server 2008 R2 on win 7.
This is my code:
CREATE MINING STRUCTURE [People1]
(
[CustID] LONG KEY,
[Name] TEXT DISCRETE,
[Gender] TEXT DISCRETE,
[Age] LONG CONTINUOUS,
[CarMake] TEXT DISCRETE,
[CarModel] TEXT ... 阅读全帖 |
|
