A clustered index on the primary key is usually a good idea. An identity column is usually a...

From your description, it seems to me that things got different from your analysis.

Probably, before restarts the GOOD plans were cached and you lost them restarting the service.

When the...

I mean that you can replicate tables to remote sql servers:

http://msdn.microsoft.com/en-us/library/ms151198.aspx

Obviously, if the target server is not MS SQL Server, this is not an option.

Dynamic sql is your friend:

DECLARE @sql nvarchar(max)

SET @sql = STUFF((

SELECT ',DEST.' + name + ' = SRC.' + name AS [text()]

FROM (

SELECT cols.name

FROM sys.columns AS cols

INNER JOIN sys.tables AS tabs

ON...

What about replication?

I would not focus on the DTA issue, I would rather start from the original problem: slow sql server.

It doesn't necessarily mean you need more (or better) indexes.

So, slow at...

rpfelgueiras (3/10/2011)

---

Thks about your answers, but I have a question (i'm newbie in this kind of stuff): on my post i'm talking about updates, and not about deletes 😉

Can I...

It was limited to 256 characters in SQL 2000, but from 2005 onwards it returns nvarchar(4000).

The real...

It could be something like this:

CREATE TRIGGER My_Trigger

ON MyTable

FOR DELETE

AS

BEGIN

SET NOCOUNT ON;

DECLARE @SQLBuffer nvarchar(4000)

DECLARE @buffer TABLE (

EventType nvarchar(30),

Parameters int,

EventInfo nvarchar(4000)

)

INSERT @buffer

EXEC sp_executesql...

You're welcome!

OK, here it is:

declare @rc int, @dir nvarchar(4000)

exec @rc = master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE',

N'Software\Microsoft\MSSQLServer\MSSQLServer',

N'BackupDirectory',...

Ah! Found it:

http://www.mssqltips.com/tip.asp?tip=1583

It should be:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\BackupDirectory

This is how I would do it:

SET XACT_ABORT ON

BEGIN TRY

BEGIN TRANSACTION

UPDATE srvrn.dbn.dbo.tbl1

SET name = 'test'

WHERE number=1

IF XACT_STATE() = 1

BEGIN

SELECT 'success'

COMMIT

END

ELSE

BEGIN

SELECT 'Uncommittable transaction'

END

END TRY

BEGIN CATCH

ROLLBACK

SELECT 'fail'

END...

Koen Verbeeck (3/10/2011)

---

Gianluca Sartori (3/10/2011)

---

OK, so... report this post as well!

I'm so...