招聘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在另外一台电脑上恢复备份后,不能连接,使用sa帐户也不能连接,以前也遇到类似问题一直得不到解决
请高手帮忙解答?
但是选择访问数据库的时候,提示"21002用户""已经存在"错误?
......
错误类型：
Microsoft OLE DB Provider for SQL Server (0x80040E14)
除非同时指定了 TOP，否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。
/cnblms/index_2/Order_show.asp, 第 94 行
......
原数据----------------------------
a b
49 皮书系列
50 经济 ......
由于最近要写一个分页的程序，在网上找了个存储过程；
create procedure add_pp_SqlPager
@sqlstr nvarchar(4000), --查询字� ......
@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)
......
