y****9
发帖数: 144 | 1
I asked the below question in Oracle-L, let's if any useful info can be
obtained during weekend.
---
Don't understand why the below query does not give me the next 10 days
instead get past 10 days. ( also noticed without the cast it does not work
at all)
SQL> select * from v$version
2 ;
BANNER
----------------------------------------------------------------------------
----
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
COR... 阅读全帖 |
|
G********7
发帖数: 234 | 2 懂一些SQL，现在想学一些SQL server,现在在看by Mike
Hotek.看了1/3了，还是没什么头绪。有其他如们书推荐么？？多谢！！ |
|
g***l
发帖数: 18555 | 3 可以做个REPLICATION FROM ORACLE TO SQL SERVER，然后用SSIS在SQL SERVER里LOAD，既然现在用SQL SERVER了，SSIS和REPLICATION应该熟悉了 |
|
a*z
发帖数: 294 | 4 Thank you, a9. The version is SQL R2 express.
Thank you, jackrun. Yes, I did enable the TCP/IP under SQL server
configuration manager\SQL native client 10.0, but did not work.
Any more suggestions / inputs are appreciated. |
|
a*z
发帖数: 294 | 5 Thank you, T4. From the config, I can see that the sql server is running. I
will try to attach the adventureworks database to it and see how it goes.
Thank you, charlie90001. I have 2 win7, one is pro, one is ult. I have tried
the SQL server 2008 R2 64bit evaluation version but failed. Sorry, I do not
understand the win7 enterprise (32/64bit) (3 month evaluation version). Is
it SQL server enterprise evaluation version? I have not tried this version.
I will google it.
Thank you all again. Appreci... 阅读全帖 |
|
|
g***l
发帖数: 18555 | 7 很多人问怎么学SQL SERVER啊？无非三部曲
看书SQL SERVER 2008 ADMINISTRATION的书简单看看
实践，SEARS有SQL 2008 DEVELOPER EDITION，买一个装在机器上，自己创建一个
DATABASE，比如ORDER SYSTEM，大家都在AMAZON上买过东西，怎么ORDER东西，需要什
么，看看AMAZON的INVOICE就知道了，第一次肯定设计不好，多弄几遍，怎么提取数据
，怎么INSERT, UPDATE，DELETE，如何JOIN
考试，微软有认证，去考一下可以提高很快。买认证用的书，做做网上的练习。 |
|
a******e
发帖数: 15 | 8 我有一个.net 程序用SqlBulkCopy 向一个SQL2008R2的表（tableA)中插入大概几百条
数据。用SQL Profiler 跟综发现所有 insert bulk 的命令都执行了，SQL Server 也
未返回任何错误。但如果用户执行
select * from tableA
有时会发现刚才插入的记录不在（不是总能重复，时有时无）。
我怀疑记录是在SQL Server Cache 中，未能及时写入硬盘，但不能肯定。
Any suggestions?
Thanks. |
|
d****g
发帖数: 1542 | 9 目前是SQL Navigator与VSS 6.0
准备升级到TFS 2010,还能用SQL Navigator吗？google了一下，好像SQL Navigator 6.
2支持TFS 2008。
有大侠用过吗？
如果不支持的话，只能在vitual studio里建一个database project了？
多谢。 |
|
l******t
发帖数: 660 | 10 北美华人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 ... 阅读全帖 |
|
S*****4
发帖数: 5 | 11 SQL server工资低些。我做了15年SQL Server DBA. 另外做SQL Server DBA的老印特多
。 |
|
S*****4
发帖数: 5 | 12 SQL server工资低些。我做了15年SQL Server DBA. 另外做SQL Server DBA的老印特多
。 |
|
l****3
发帖数: 56 | 13 上周活动我参加了,讲的是Oracle有关的内容.
SQL是指的Microsoft 的 Microsoft SQL Server® 2008 Database Development对
吗?
主要是我听了五月24日那次讲座,初学者需要从Oracle, SQL sever,MySQL,DB2中选一个
操作系统来学,所以我问这个问题?
谢谢. |
|
B*****g
发帖数: 34098 | 14 http://en.wikipedia.org/wiki/SQL
选一个数据库是因为很多人要做developer或者DBA，必须先着重一个数据库。Analyst
不用过深了解特定数据库。SQL对不同数据库基本相同，学哪个都一样(Oracle or SQL
Server, forget others now)。 |
|
z**********8
发帖数: 2049 | 15 https://employee-webmd.icims.com/jobs/9355/job
分析一下技术要求：
1。logical and physical design and modeling;
2. high-performance tuning, 1 billion rows
3. technical writing skills
4. to design, develop and document database, schemas, tables, functions,
triggers, procedures, relationships
5. business analysis
6. ETL
5. complex queries
8. Oracle and sql server
9. PL'SQL and T-SQL
10. ErWin, ER studio -- data modeling
11. Microsoft SSIS or Informatica -- ETL tools
12. OLTP, ODS, data warehouse and datamart... 阅读全帖 |
|
|
s**********o
发帖数: 14359 | 17 是可以的，但可能会遇到很多问题，再说你SQL SERVER的SCHEMA跟ORACLE一模一样么，
还是别人给做好了DATA MODEL，你往里灌数据呢，如果是灌数据，就得SSIS ETL了，
我很好奇为什么换系统，PERFORMANCE不好，还是ORACLE太贵了用不起，一般换系统，
我肯定走人的，换完了人就不要你了，我给一家从SQL SERVER换到ORACLE，用从ORACLE
换回SQL SERVER，还没换完就被LAY了，后来又看到几家换系统，一看是换系统就说明
公司有问题，LOL
So |
|
o*******8
发帖数: 249 | 18 老大，你说的很对。我还是想做SQL，因为。net貌似要学很多东东。但是dice网上
entry level的SQL developer很少阿，是不是entry level的工作都不在dice上。
另外SQL和。net的前途有什么区别，对于中年出家只想混日子的人士（没有电脑专业背
景）？
db |
|
w****n
发帖数: 266 | 19 想用SQL server做一个小project， 就是执行简单的SQL statement，
CREATE TABLE
SELECT FROM WHERE
INSERT
DELETE
不知下载sql server express的哪个版本？ localDB？ 如果想用GUI 的话， 必须要装
visual studio吗？谢谢 |
|
l******y
发帖数: 60 | 20 在用Oracle SQL （程度很地哈，不是高手），从没用过SQL Sever，学BI会不会很难？
请大侠们指点迷津，多谢！ |
|
g*****6
发帖数: 208 | 21 我用了SQL SERVER有10多年了吧.用过 SQL SERVER 7, 2000,2005,2008, 2012. 但多数
是写CODE. DBA的活可能我就只会做简单的BACKUP和导入导出,系统恢复,加人之类的吧.
现在想去考证,请问我该看什么书.
有没有什么优先级的,先考什么,再考什么之类的.两娃的大妈,还真没时间具体上课.我
现在用的是C#.NET 3.5 +SQL SERVER 2005, 2008, 2012.
谢谢.
具体的建议我会发仅有的包子来感谢的. |
|
l********n
发帖数: 200 | 22 最近想换个SQL DBA/Developer的工作，很不顺利。
现在想请教大家两个有关找工作的问题：
1。哪些网站搜寻SQL DBA/Developer职位？比如我上Monster寻找Houston的SQL DBA/
Developer，根本没有多少职位。请问哪些网站搜寻DBA/Developer职位比较有效？
2。请大家推荐资料面试。经常看到程序员讨论某些秘籍通杀MS或者GOOGLE难题。数据
库是不是也有类似的秘籍，或者临时抱佛脚的速成书？偶然的机会转行做了几年DBA，
但从没静下来好好学习过。现在也不大可能静下读书，所以大部头的书估计读不下来，
最好是那种速成资料，针对面试的更好。
谢谢大家。 |
|
s**********o
发帖数: 14359 | 23 信箱和密码？SQL课，啥SQL,SQL SERVER还是ORACLE，MYSQL? |
|
|
l*****e
发帖数: 3343 | 25 新手学数据库：到底是从Oracle 还是 SQL server 学起，还是
T-SQL 和 PL-SQL 一起对着学？ |
|
B*****g
发帖数: 34098 | 26 我个人认为学习解决问题的方法远比学习一个知识点重要得多。
以你写的code为例，大家来探讨一下：
UPDATE INVENTORY
SET stockqty = (SELECT INVENTORY.stockqty - v_qty
FROM INVENTORY
WHERE INVENTORY.partid = v_Partid)
WHERE partid = v_Partid;
这个你自己看着都觉得别扭，怎么办？当然，去问会的同学也是一种方法，但肯定不是
最好的。
学习第一大法，***读文档***
找到oracle 11gR2的关于update的文档（怎么找到文档的?晕倒)。
http://docs.oracle.com/cd/E11882_01/server.112/e17118/statement
一共没几行，里面已经给出例子能解决你的问题。
如果你仔细阅读这篇文档，你会发现你的code还可以继续优化。基本上就解决了另外一
个问题，为什么update后还要再用一... 阅读全帖 |
|
l******t
发帖数: 660 | 27 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... 阅读全帖 |
|
s***s
发帖数: 1301 | 28 Free eBook: SQL Server Transaction Log Management
When a SQL Server database is operating smoothly and performing well, there
is no need to be particularly aware of the transaction log, beyond ensuring
that every database has an appropriate backup regime and restore plan in
place. When things go wrong, however, a DBA's reputation depends on a deeper
understanding of the transaction log, both what it does, and how it works.
http://www.red-gate.com/products/dba/sql-backup/entrypage/trans |
|
w****w
发帖数: 521 | 29 SQL还在用，但不多。记住这个问题是因为它是少有的实际问题,又有elegant SQL
solution。和其他通用函数式语言相比，SQL因为有表的统计信息而容易优化。 |
|
m******y
发帖数: 588 | 30 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... 阅读全帖 |
|
l******b
发帖数: 39 | 31 个人认为解决此问题最佳方法window partitioning + cross apply
T-SQL 2012 提供CROSS APPLY比Oracle 11.2(不提供CROSS APPLY)稍胜一筹.
T-SQL method
---------------------------------
CREATE TABLE t9(
acct VARCHAR(20),
status VARCHAR(20),
nDay int
);
INSERT INTO t9(acct,status, nDay) VALUES('Acct1', 'A', 1) ;
INSERT INTO t9(acct,status, nDay) VALUES('Acct1', 'B', 5) ;
INSERT INTO t9(acct,status, nDay) VALUES('Acct1', 'C', 8) ;
INSERT INTO t9(acct,status, nDay) VALUES('Acct1', 'D', 9) ;
... 阅读全帖 |
|
s********e
发帖数: 893 | 32 俺最近收到几个recruiter发来Pl/Sql developer的工作，时薪都是$80-$120, 6months
contract，还不是在东西部发达地区。pl/sql我经常用，写点stored procedure，
parameter in out,error handling等。 还真不知道pl/sql developer能拿这么高的薪
水，还是俺水平次，不知道深浅。搞的我有些心动。 |
|
d**********3
发帖数: 1186 | 33 Online Session(Nov. 5th): Notes and Takes on SQL Pass Summit 2013
Next Tuesday(9/8C), Jian and I will have a session to share some thoughts on
SQL PASS Summit 2013. This session covers
#1, Recap of SQL Pass 2013
#2, New features and roadmap on SQL2012 BI and Sharepoint 2013
#3, Big Data and Data Mining
#4, For DBA and DB developers
#5, Discussion Time
#6, Your Question(Any)--Bring your questions.
Session registration information will be posted shortly on this thread.
Dont miss it.
To make sure y... 阅读全帖 |
|
d**********3
发帖数: 1186 | 34 All,
Please register for Online Session(Nov. 5th): Notes and Takes on SQL Pass
Summit 2013 on Nov 5, 2013 8:00 PM CST at:
https://attendee.gotowebinar.com/register/1821382047447693058
Next Tuesday(9/8C), Jian and I will have a session to share some thoughts
on SQL PASS Summit 2013. This session covers
#1, Recap of SQL Pass 2013
#2, New features and roadmap on SQL2012 BI and Sharepoint 2013
#3, Big Data and Data Mining
#4, For DBA and DB developers
#5, Open Discussion Time
#6, Your Question(Any)-... 阅读全帖 |
|
o**y
发帖数: 1466 | 35 我在做一个项目,要求在1个小时的窗口内,把整个数据库全部更新一次(头的要求很奇怪
,要full,不能incremental).现在的瓶颈在一个BLOB的字段上,这个字段存放一个Object
Type,object不大,BLOB的长度在100-10000之间,但有2 million rows.整个BLOB全部加
起来也不大,只有200MB左右.
我在网上找的例子用SQL LOADER 做LOB,全部是文本CLOB的例子,看不到BLOB的例子,
BLOB的例子也有,但是都是从不同的文件载入的,比如说一条记录对应一个外部文件. 这
对我来说不现实,在本地盘上装2M个文件会慢得要死.我现在的办法是把BLOB变成BASE64
,到了ORACLE里面再把BASE64 decode成BLOB,这样可以把数据搞上去,但是这个数据内解
码耽误时间,速度达不到要求,很慢.
我希望的方法是把所有记录的BLOB内容放在一个文件里,然后用LOBFILE constant指定
一个文件名,所有的记录都在这个文件里找内容,现在的问题是我不知道怎么样把各条记
录的BLOB在一个文件里分割.ORACLE DOC上说可以... 阅读全帖 |
|
g***h
发帖数: 20 | 36 sql server纯新手。请问如何将远程sql server的数据都download到本地（csv或数据
库文件均可）？我在本地用sql server management studio 2008。
多谢多谢 |
|
s****e
发帖数: 1180 | 37 借宝地问个面试中的sql的问题。
We have two tables, students (student ID, student name, student age, student
zip) and courses (course name, course time) .
The information in the parentheses are the schema.
We want to get how many students enroll all the classes starting at 11:00 AM?
the interviewer mentioned something like many to many join.
the interviewer mentioned something like "dimensionalize" in SQL. I am
wondering who knows any SQL book on this, and can introduce it me?
Thank you so much for your consi... 阅读全帖 |
|
s****e
发帖数: 1180 | 38 借宝地问个面试中的sql的问题。
We have two tables, students (student ID, student name, student age, student
zip) and courses (course name, course time) .
The information in the parentheses are the schema.
We want to get how many students enroll all the classes starting at 11:00 AM?
the interviewer mentioned something like many to many join.
the interviewer mentioned something like "dimensionalize" in SQL. I am
wondering who knows any SQL book on this, and can introduce it me?
Thank you so much for your consi... 阅读全帖 |
|
d***e
发帖数: 793 | 39 面试题中要求：
All of your SQL should run in any ANSI SQL-92
compliant database.
limit 10是不是SQL-92Compliant？还有什么需要特殊注意的吗？ |
|
l******9
发帖数: 579 | 40 I need to add a column with an int value to the result from a subquery on
SQL.
It is Netezza SQL.
SELECT *
FROM
(
SELECT *
FROM table1
JOIN
table2
ON table1.id1 = table2.id1
GROUP BY table1.id2, table2.id3
) AS tt_a # here, I need to add a new column to tt, call it as top_id
and also assign an int value to it, such as 80
FROM
(
SELECT *
FROM table1
JOIN
table3
ON table1.id1 = table3.... 阅读全帖 |
|
D*********h
发帖数: 73 | 41 没有aggregated field, 就是把行转成列，把列转成行。现在数据如下：
ID Income Outcome Pending
1 2000 1000 50
2 3000 2000 20
希望数据呈现：
ID 1 2
Income 2000 3000
Outcome 1000 2000
Pending 50 20
我做了research, 貌似用PIVOT,但都挺麻烦的，有哪位大侠有简单的coding method吗
？ 用sql, 在sql server 上。谢谢！ |
|
l******9
发帖数: 579 | 42 I need to print out a group of values from a procedure on SQL server 2008.
If I use select , it generated a distinct table into the result part of SQL
server 2008 managemetn studio every time the procedure is called.
i need to call the procedure in a loop. I want to print the values into one
table.
Thx!
while
begin
my_procedure()
end
my_procedure()
# do something
select value1, value2, value3
i need to keep the
value1, value2, value3
in one single table after the loop is don... 阅读全帖 |
|
l******9
发帖数: 579 | 43 【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: error run SQL query from pyodbc python 3.2.5
发信站: BBS 未名空间站 (Thu Jun 19 12:04:26 2014, 美东)
I am working on pyodbc in Eclipse (4.3.2v20140221-1852) with PyDev on Win 7.
My python is 3.2.5.
At my code:
cursor.execute("select top " + str(1) + " a.my_id, a.mycode" +
"from my_table as a where a.mycode = ?", aGivenCode)
I got an error :
pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC SQL Server
Driver]
[SQL Ser... 阅读全帖 |
|
l******9
发帖数: 579 | 44 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: SQL select one value column for each distinct value another col
发信站: BBS 未名空间站 (Fri Jun 27 10:29:25 2014, 美东)
On SQL server 2008 R2, I would like to select one value of a column for each
distinct value of another column.
e.g.
name id_num
Tom 53
Tom 60
Tom 27
Jane 16
Jane 16
Bill 97
Bill 83
I need to get one id_num for each distinct name, such as
name id_num
Tom 27
Jane 16
Bill ... 阅读全帖 |
|
l******9
发帖数: 579 | 45 【 以下文字转载自 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 ... 阅读全帖 |
|
b*******0
发帖数: 236 | 46 想学SQL，请问在哪里可以下载到能在Windows8系统中用的SQL? 之前下载了几个版本都
不能兼容。
另外，MySQL，SQL Server区别大么，目前哪个应用广泛一些？
谢谢，数据库方面新手，请指教！ |
|
l******9
发帖数: 579 | 47 【 以下文字转载自 Programming 讨论区 】
发信人: light009 (light009), 信区: Programming
标 题: check time table created in IBM SQL Aginity workbench ?
发信站: BBS 未名空间站 (Fri Oct 31 18:37:40 2014, 美东)
My question may be simple, but, I have been searching the answer for a long
time.
How to check the data and time that a table was created in IBM Netezza SQL
from Aginity workbench ?
It is very easy to find this in MS SQL server, but, I cannot figure this out
in Netezza.
Any help would be appreciated.
thanks ! |
|
l******9
发帖数: 579 | 48 【 以下文字转载自 Programming 讨论区 】
发信人: light009 (light009), 信区: Programming
标 题: check time table created in IBM SQL Aginity workbench ?
发信站: BBS 未名空间站 (Fri Oct 31 18:37:40 2014, 美东)
My question may be simple, but, I have been searching the answer for a long
time.
How to check the data and time that a table was created in IBM Netezza SQL
from Aginity workbench ?
It is very easy to find this in MS SQL server, but, I cannot figure this out
in Netezza.
Any help would be appreciated.
thanks ! |
|
|
l******9
发帖数: 579 | 50 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: error of importing data from txt file to IBM netezza SQL database
发信站: BBS 未名空间站 (Fri Nov 21 14:55:51 2014, 美东)
I would like to load data from a txt file (9 KB) to SQL IBM netezza database
in Aginity workbench.
After creating the table:
I right-clicked the table and go to "import data" tab and chose "comma" as
field delimiter and skip the first row for the header in the file.
The SQL query is:
INSERT INTO username.my_table... 阅读全帖 |
|
