Abu Dina (1/29/2014)

Is it?

So what happens if I have two records with the same Organisationname but the...

I suppose you could write some job that fetched the entire contents of the table on a regular basis and compared with previous versions. Horribly inefficient though.

Someone's got to have...

As I mentioned above, snapshots are point in time (static) as of the time they are created. They are not and can not be kept in sync with their source...

Write your queries in such a way that they can seek on the primary key, or add indexes to support the queries. Adding a NC index on exactly the same...

Trigger on AccountSample, Change data capture, Change tracking or SQL Audit. All require you to have fairly high permissions on the table, database or server. If you don't have them,...

There are very, very, very few times when it makes sense to put a nonclustered index on the same column as the clustered primary key. Usually it's a waste of...

You need to either use a subquery or CTE or to put the entire CASE in the where clause. The WHERE is evaluated before the aliases in the select are...

Ok, so every single time someone inserts one or more rows into InvoiceHeader, you want the one single highest invoice ID to be inserted into Client Invoices, regardless of how...

If SQL is using too much memory, if there's too little free memory left on the server, reduce max server memory.

Sparse files are not used for TempDB. They're used only for database snapshots. See Books Online (SQL help file) under database snapshots for details.

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

Can you post the stored proc code please? Without seeing that, there's not a chance in hell any of us are going to be able to guess why the trigger...

What I would suggest - don't nest transactions and do all your transaction handling at one level

Dup.

A view is a single select statement. It cannot have any other commands in it.