招聘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
相关问答:
如题,想将我以前做过的网站放在网上给人看,由于是ms sql的,大多数网络商的虚拟主机是要收费的,
想打包后放在一些免费的空间,让人家自己下载去看,所以希望打过包后的数据库的表不让客户看到,
或者是加过 ......
mssql如何只显示有重复的数据呢?
有重复的数据就显示一条重复的数据,没重复的不显示,查询语句该怎么写呢?谢谢
SQL code:
select distinct *
from tablename
where id in (
selec ......
假设有两张表,t1 t2
t1:id 字段1 字段2 字段3
t2:id 字段4 字段5 字段6
现用一条查询语句select t1.*,t2.* from t1,t2 where t1.id=t2.id and 条件……
将符合条件的数据从mssql数据库中导出至exce ......
mssql在另外一台电脑上恢复备份后,不能连接,使用sa帐户也不能连接,以前也遇到类似问题一直得不到解决
请高手帮忙解答?
但是选择访问数据库的时候,提示"21002用户""已经存在"错误?
......
由于最近要写一个分页的程序,在网上找了个存储过程;
create procedure add_pp_SqlPager
@sqlstr nvarchar(4000), --查询字符 ......