招聘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 ......
由于最近要写一个分页的程序,在网上找了个存储过程;
create procedure add_pp_SqlPager
@sqlstr nvarchar(4000), --查询字符 ......