l*****k
发帖数: 587 | 1 for db design? use ERwin or Qdesigner
once you have the db, you can play with it to learn DBMS like oracle
or sybase or mysql, etc. |
|
a********s
发帖数: 29 | 2 Can anyone give me some possible interview qoestions of Sybase and SQL? |
|
p********b
发帖数: 7 | 3 Hi,
Currently i am verifying a list of obsolet tables and stored procs coz
my boss is aware of some are still in use by applications on production side.
I am able to find all the dependencies from the obsolete object's
database. But i cant figure out a way to get dependencies inter-databases.
Is there any approach to do that? I use sybase, by the way.
Thanks a lot |
|
|
j*****n
发帖数: 1781 | 5 "SQL Server在自适应系统调整方面比oracle 要早六年。 很多调整在内部已经做得很
好了。
一般不需要在语句层使用hints. "
嗯，孰俺孤陋寡闻，能把这个典故详细说说么？这个optimizer什么时候出来的？据俺
所知，MS SQL 买的Sybase SQL Server 的技术，大约是在1992年推出 MS SQL Server
4.2,
在NT上跑的第一个版本是6.0.
(
SQL |
|
|
z***y
发帖数: 7151 | 7 哪里！
不是牛的人。
我也做oracle， 也做Sybase. 最近还在学mysql.
希望结识同行。 |
|
j*****n
发帖数: 1781 | 8 很贵么？$25,000/physical CPU. 比 Oracle 如何？
要不查查sybase 什么价。 |
|
|
j*****n
发帖数: 1781 | 10 bcp to a staging table that has a rundate column with default value as
GETDATE. |
|
s********1
发帖数: 3 | 11 thanks for reply.
then how to cp from staging to final one? |
|
j*****n
发帖数: 1781 | 12 now you got all you want in stating table...
insert into destinationTable
Select * from stagingTable
when you do ETL, staging table is a good practice for doing data massages. |
|
h**h
发帖数: 488 | 13 Thanks. So this refers to a programming language.
I remembered, we used ODBC database, my boss used to design the query with
Access to perform the functions with excel, so he was using the SQL
programming language as well?
Also, linking with the ODBC, it manipulate data on what database? I saw "MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems", which one I should take a look? |
|
i****a
发帖数: 36252 | 14 the query designer in Access is just a graphical interface to build SQL
commands for you.
If you look at the ODBC on the computer the Access is running on, you can
see the details on the connection.
that tutorial website talks about the basic and standard SQL, which is
almost the same for all systems.
with
"MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database
systems", which one I should take a look? |
|
w*r
发帖数: 2421 | 15 not much.. legacy support mostly
From
,
pick
planning
a |
|
w*r
发帖数: 2421 | 16 why DB2??? for Unix DB2.maybe. Mainframe DB2... very good investment.
same |
|
j***a
发帖数: 10844 | 17 It's almost gone!
From
,
pick
planning
a |
|
S*****0
发帖数: 538 | 18 link上就这2点：
1。 Microsoft and Sybase redefined "sargable" to mean 'can be looked up via
the index.'"
2。Sargable predicates can be evaluated on the tuples of a single table.
Unsargable predicates, or join predicates, require one or more joins to be
performed before the predicate can be evaluated
我在另一本SQL Server 2008上也看到这个论点。就是NOT EXITS， EXITS这些是Non-
sargable。
我同意不用index,是不合理的。我没有做过Left Join和NOT EXISTS的execution plan
比较, 但在我的工作中，数据量大的时候, Left Join的优势很明显，所以现在我都用
join了。 |
|
c*****d
发帖数: 6045 | 19 足球版的z大师不搞sybase开始搞mysql了？ |
|
f*****k
发帖数: 353 | 20 刚进公司，老板给的project都是和ASE相关的，大家有没有用ASE的，大家可以交流一
下，我以前是数据库盲，谢谢 |
|
c*****d
发帖数: 6045 | 21 俺们oracle已经没啥市场了
db2和sybase的同学更杯具呀 |
|
g***l
发帖数: 18555 | 22 Position Information
Job Title:
SQL Server DBA
Department:
Information Technology
Type:
Full Time
Job Description
SUMMARY:
AutoAnything, a San Diego-based, rapidly growing e-commerce Company, merges
the high-speed lane of specialty automotive parts and accessories with
cutting-edge internet technology and world class Customer Service. Our
entrepreneurial style, knowledge of the competitive landscape and innovative
business model has allowed us to excel in the industry since 1979.
AutoAnything is... 阅读全帖 |
|
g***l
发帖数: 18555 | 23 任何事情都是有EXCEPTION，所谓BEST PRACTICE么，就是尽量地做到，做不到的时候要
小心。另外，还有人用SYBASE吗，死菜了？LOL |
|
v*****r
发帖数: 1119 | 24 SQLServer 不是 Window 版的 Sybase 吗？ |
|
g***l
发帖数: 18555 | 25 我都很久没有见过SYBASE SQL招人的广告了。 |
|
y****w
发帖数: 3747 | 26 有兴趣把简历pm我，帮忙转下。pay的还是很不错的。
......
They're looking to hire a number of full-time Application Developers (Junior
to Senior level, primarily in Java and C++). The compensation range depends
on a candidate's level of experience - but generally falls between $80K-
150K. I've included the job description below.
....
Application Developer (Java, C++ or C#) – Multiple positions
Location: Salt Lake City, UT
These positions are with with an elite investment bank and range from entry
level Application Deve... 阅读全帖 |
|
a****g
发帖数: 295 | 27 我们倒是啥product 都有， 不过现在是找sybase 或者 db2, sql server 也凑合。 |
|
x******i
发帖数: 391 | 28 各位大侠，本人想将来找份DBA的工作，以前在公司（移动通讯）干过database
developer （SyBase+PowerBuilder）, 主要工作是生成用户报表，开发一些前台工具
。后来干过一些网站+数据库的开发工作（PERL+PHP+JAVA+C++——MySQL），自己独立
摸索干的。现在想转行去工业界，不是很了解DBA行情。希望能在1到2个月完成基本的
training.不想冒昧投简历，看似MS SQL Server 比 Oracle 机会多。TODU， ETL 等工
具用的人也比较多。真心恳请各位大侠给一些指点。如果哪位好心人可以给予一对一指
导，我可以付一些酬劳。如果你是猎头公司，负责培训+找工作，那再好不过了。
我觉得自己不是太笨，不懒（王婆一下，不要介意，只是想给未来的tutor一点信心：
）），有一定基础，只是离开工业界时间太长了。相信不会让你失望！
刚来板上，请多多指教！bow ----) |
|
|
|
|
|
|
|
y****w
发帖数: 3747 | 35 没问题啊，再借我点儿？我总共才4个不到，all in了，嘿嘿。 |
|
|
|
s********y
发帖数: 122 | 38 Honestly I have not been following db technology for long time, nor have I
the slightest interest in doing so... :) must be a relatively new thing in
sybase as far as I can remember. I know SQL server and oracle support that.
On a separate note, doing "so called" analytics work directly in database is
a joke to start with...no offense. |
|
T****U
发帖数: 3344 | 39 没有啊,人家说接sybase/sql server要open source插件, 好些功能也不能用了，还是
很实诚地 |
|
a**d
发帖数: 4285 | 40 据说是很老的东西了，被SAP收购后，未来工作机会不会多点。 |
|
s**********o
发帖数: 14359 | 41 DEAD, I would not touch it |
|
|
|
|
|
|
|
|
y****w
发帖数: 3747 | 49 没办法。从工作开始琢磨oracle都是怎么beat it. |
|
|
