招聘MsSQL DBA - 上海
有意者请联系yushan-33@hotmail.com / 18821146311
Microsoft SQL Administrator
Job Description:
A detail oriented Microsoft SQL Administratorwith excellent problem solving, analytical skills and a proven track record in managing production level environments to join our Information Technology team. The successful incumbent will be responsible for the day to day administration of current SQL Server environment. In addition He / She will be involved with designing and implementing a new scalable, highly-available global data architecture.
This position is located in Shanghai, China.
Responsibilities:
- Review and analyze database requirements; develop detailed database design specifications to meet identified requirements.
- Review and analyze user needs; determine equipment and software requirements for solutions to problems.
- Install and maintain database performance by developing tuning methodologies.
- Manage and implement database security and user accounts.
- Design and implement backup and recovery strategies.
- Assist with the design and development of data models as needed.
- Assist with the development and implementation of database/SQL standards and methodologies.
- Analyze and report on database metrics; administer and control data resources; monitor and ensure database integrity, security, an
相关问答：
MSSQL$SQLEXPRESS 无法启动.. 知道如何处理的请帮帮忙 谢谢
看看错误日志
提示什么错误?
http://blog.csdn.net/fredrickhu/archive/2009/09/20/4573408.aspx
......
mssql如何只显示有重复的数据呢？
有重复的数据就显示一条重复的数据，没重复的不显示，查询语句该怎么写呢？谢谢
SQL code:
select distinct *
from tablename
where id in (
selec ......
如何在MSSQL数据导入的时候遇上错误数据跳过?
这个？那你还是用ssis吧。数据导入导出没有控制流
是2000的数据库
2000没什么好的办法
有没有其它的导入工具呢?
自己在前台写代码判断。
路过，用前台� ......
@str = |108||203|
查找返回结果str = 108 只返回第一个 其它的都干掉
SQL code:
declare @str varchar(100)
set @str = '|108||203|'
select substring(@str,2,charindex('|',stuff(@str,1,1,''))-1)
......
现在连的一远程mssql，每次查询比较慢，现在想一下把所有记录查询出来用数据集保存起来，然后针对数据集再次查询筛选。
现在问下那个数据集如何保存查询记录，而再次查询，多谢了。
可以把数据集中的数据放到内� ......
