随笔分类 -  sql server

Enabling Remote Errors in SSRS
摘要：January 18, 2011By default theremote errors property in SQL Server Reporting Services is set to false, which means error messages in a multi-server en... 阅读全文
posted @ 2015-05-25 10:10 Jason.Bird 阅读(343) 评论(0) 推荐(0)
SQL 优化
摘要：http://msdn.microsoft.com/en-us/library/cc645993(v=sql.110).aspxfrom Alex Feng (privately):标准版不支持数据压缩from Alex Feng (privately):MAXDOP hint: http://ms... 阅读全文
posted @ 2014-11-05 17:17 Jason.Bird 阅读(120) 评论(0) 推荐(0)
sql trace script
摘要：CREATE EVENT SESSION [sql_query_tracing] ON SERVER ADD EVENT sqlos.wait_info( ACTION(sqlos.scheduler_id,sqlserver.client_app_name,sqlserver.client_con... 阅读全文
posted @ 2014-10-28 15:15 Jason.Bird 阅读(205) 评论(0) 推荐(0)
如何关闭SQL进程
摘要：--通过下面的查询得到trace ID select * from sys.traces--修改下面的@traceid参数，关闭，删除对应的traceexec sp_trace_setstatus @traceid = 2, @status = 0 exec sp_trace_setstatus @... 阅读全文
posted @ 2014-10-14 18:25 Jason.Bird 阅读(1987) 评论(0) 推荐(0)
sql performance Kill Lock
摘要：sp_who2 activesp_lock 76select object_name(261575970,16)select %%lockres%%,* from SessionLock(nolock) --from reporttempdbselect * from SessionData whe... 阅读全文
posted @ 2014-09-04 17:48 Jason.Bird 阅读(188) 评论(0) 推荐(0)
how to trace the error log
摘要：Executed as user: WTC\Ebw.Admin. Transaction (Process ID 95) was deadlocked on lock resources with another process and has been chosen as the deadlock... 阅读全文
posted @ 2014-09-02 11:24 Jason.Bird 阅读(144) 评论(0) 推荐(0)
sql数据库 大小查询
摘要：select * from sys.master_files where name='CODA_PRD_Catalog'12416*8/1024=(m) 阅读全文
posted @ 2014-08-22 15:35 Jason.Bird 阅读(246) 评论(0) 推荐(0)
Proxy account failing to run SSIS Error (Proxy (11) is not allowed for subsystem "SSIS" and user "AB\testuser ".
摘要：USE [msdb]EXEC msdb.dbo.sp_grant_login_to_proxy @proxy_name=N'SSISProxyAgentV1', @login_name=N'WTC\Ebw.Admin'GO 阅读全文
posted @ 2014-07-21 21:00 Jason.Bird 阅读(359) 评论(0) 推荐(0)
connect db2 by tools
摘要： 阅读全文
posted @ 2014-07-01 08:48 Jason.Bird 阅读(108) 评论(0) 推荐(0)