In this case, I would say that checking in the application is irrelevant unless it happens in a service layer on a web server, so that the application can know...

Of course Gail 🙂

I would go for the merge statement.

And, as for the percentage: "There are three kinds of lies: lies, damned lies, and statistics." Those percentages is at the best a...

This is most likely due to updates from multiple transactions. In read committed transaction isolation level, a query won't "see" changes made by other queries before they are committed. So,...

My first thought, is why do you want to do this? As the servers already are licensed for enterprise edition, and assuming that you have license for all the nodes,...

I would say that piecemeal restore is a sequence partial restores, beginning with the primary filegroup. The two are not the same. When you restore the primary filegroup, you will...

As far as I know, no you can't. The only option I know of is to disable the index, but disabled indexes are not updated, so you would have to...

The first parameter to sp_executesql must me ntext, nchar or nvarchar, in your case it is varchar. Btw, I do hope you did not actually post an adminstrator password?

Looks like you have written @MinVal instead of @MaxDiferenca in your dynamic sql:

SET @SQLString = 'select @maxVal = isnull(max(cod_sincronismo_fim),0)

from '+@DB+'.dbo.sincronismo where

tp_processo =''I'' and cod_tp_classificacao =2 AND STATUS =0

and cod_rep_fiscal...

bitbucket-25253 (6/14/2012)

---

This is code by Jason Strate

http://sqlserverpedia.com/wiki/Find_Tables_Without_Primary_Keys

It should give you the result(s) you are seeking.

SELECT SCHEMA_NAME(o.schema_id) AS [schema]

,object_name(i.object_id ) AS

,p.rows

,user_seeks

,user_scans

,user_lookups

,user_updates

,last_user_seek

,last_user_scan

,last_user_lookup

FROM sys.indexes i

INNER JOIN sys.objects o ON i.object_id =...

Could you possibly post the actual execution plan?

I would strongly recommend having a look at How to prove it's a SAN problem[/url] by Brent Ozar.

As far as I understand the error message, remove the SET NOCOUNT OFF from the trigger.

Here's a link with information about "not for replication": Controlling Constraints, Identities, and Triggers with NOT FOR REPLICATION

Is the constraint created with "not for replication"? If so, could you try to create it without this?