1º - Create table
2º - Insert into on table
hgutsche,
2011-11-07 (first published: 2011-10-14)
1º - Create table
2º - Insert into on table
-------------------------------------------------------------------------- -- Creation date: 14/10/2011 -- Owner: Wellington A. Vitoriano (WellingtonSQL\DocTom) -- Personal: wellington_sql@hotmail.com -- MSN: doctom22@hotmail.com -------------------------------------------------------------------------- -- 1º step CREATE TABLE WAIT ( sessao int, origem varchar (30), tipoespera varchar(50), Destino varchar(20), Ult_Leitura smalldatetime, Ult_Escrita smalldatetime, comando text ) GO -- 2º step INSERT INTO WAIT SELECT s.session_id [Sessao], s.host_name [Origem], r.last_wait_type [TipoEspera], C.local_net_address [Destino], c.last_read [Ult. Leitura], c.last_write[Ult. Escrita], T.text FROM sys.dm_exec_connections c CROSS APPLY sys.dm_exec_sql_text(most_recent_sql_handle) AS T INNER JOIN sys.dm_exec_sessions s ON s.session_id = c.session_id INNER JOIN sys.dm_exec_requests r ON s.session_id = r.session_id WHERE r.last_wait_type = 'ASYNC_NETWORK_IO' --Selecionar o tempo de espera GO -- 3º step SELECT * FROM WAIT
If your database is marked suspect, this will show you a step-by-step guide in how to fix the problem.
2007-09-22 (first published: 2004-03-31)
58,842 reads
The second part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2003-12-25
13,017 reads
So you've created a diagram that you now need to transfer to a different server or database. This article will show give you a step-by-step guide on how to do this.
2003-11-13
11,576 reads
When transferring a database to a new server, you are bound to experience a user problem. In this article by Neil Boyle, he shows you how to transfer passwords and accounts seamlessly to a new server.
2007-10-02 (first published: 2002-08-14)
24,376 reads
An interesting feature added to SQL Server 7.0 and 2000 is the ability to purge
an error log through a stored procedure or DBCC command. In this article, Brian Knight shows some of the undocumented stored procedures to detect, read and purge an SQL Server error log in T-SQL.
2001-06-27
14,697 reads