第21页_sql server_数据库_文章_思韵闪耀

select APP_NAME() SELECT Host_Name() SELECT @@SERVERNAME 可用于触发器监控

2012-11-27 0 71

In my Are you ready for SQL Server 2012 or are you still partying like it is 199...

sql server 2012-11-27 0 99

SELECT CAST(SUBSTRING(command, 7, 8000) AS NVARCHAR(MAX)) FROM msrepl_commands W...

2012-11-20 0 85

--估算每天数据库的更新量DECLARE @starttime DATETIMESELECT @starttime = sqlserver_start_time...

服务器数据库 2012-11-20 0 107

Create table #sales_details(sales_id int identity(1,1),item_id int not null,qty ...

WAN 2012-11-17 0 100

一，入手：拿到存储过程后，先执行一次看速度与编译时间，确定是编译慢还是执行问题。 SET STATISTICS TIME ON Exec dbo.bdOrde...

数据库 2012-11-15 0 88

--查看当前库的账号SELECT members.name, roles.name,roles.type_desc,members.type_descFROM ...

2012-11-09 0 100

T-SQL Enhancements参考：英文，中文 1，WITH RESULT SETS更改存储过程返回结果表的字段名类型CREATE PROCEDUR...

sql server 2012-11-08 0 84

一、内存 1.查看整体内存使用情况 select type, sum(virtual_memory_reserved_kb)/1024 as [VM Reser...

服务器 LAN RIP 2012-11-05 0 104

For many reasons SQL Server DBAs need to find the last date and time of an updat...

RIP sql server 2012-11-02 0 92