When using Windows utilities, Performance Monitor, perfmon, will be better at showing server bottlenecks.

It should be relatively cheap to upgrade the amount of memory in the servers to 32GBytes.

(I think that is the maximum for the standard version of WS2008R2.)

It is also worth...

As mentioned, this is an horrible design.

If you have to live with an app which uses it, I would alter it so the parameters are logged and a check made...

Further to Grant's post, even some basic monitoring of Latency, Waits and PLE once a month will show the way instances are heading:

http://www.sqlskills.com/blogs/paul/how-to-examine-io-subsystem-latencies-from-within-sql-server/

http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

http://blog.sqlauthority.com/2010/12/13/sql-server-what-is-page-life-expectancy-ple-counter/

Before getting into lots of complicated checks on SQL Server I would check some basics first.

1. Is SQL Server the only program on the server?

2. Have you set the Maximum...

Thanks for your reply.

It could be the same software as I get those two messages from all 37 instances. Ours seems to run once or twice a week out of...

Did anyone manage to solve this?

I have a similar problem. Our infrastructure team has an Intrusion Detection System and every time it is run I get alert 020 from all...

DECLARE @var_time datetime2(1) = '20160414 15:21:39.0';

SELECT @var_time, DATEADD(hour, DATEDIFF(hour, '19000101', @var_time), CAST('19000101' AS datetime2(1)));

The simplest way would be to add the user to the db_datareader role.

With SQL2012, and above, this can be done with ALTER ROLE but with SQL2008 I think you will...

Your trigger looks too complex to perform well under load.

In this case it looks as though it can be made set based.

An alternative would be to make the processing asynchronous...

Part of the problem is the IDENTITY.

Can you switch to using SEQUENCEs with a different range for each server?

Ouch! I feel your pain.

My experience is that trying to do remote queries within an application causes all sorts of support issues when one server and/or the link either slows...

The GUID just needs to be unique, why do you want to order by it?

Looking at your last query does:

ORDER BY alber_no, linea_no;

do what you want?

As Lowell has already mentioned, your question does not make sense. A table being an UNORDERED set is a fundamental part of relational theory.

The only guaranteed way to order a...

Brandie Tarvin (5/19/2016)

---

Ken McKelvey (5/18/2016)

---

tcalloway (5/17/2016)

---

I have a Stored Procedure which runs every hour during business hours. It's purpose is to delete all rows, about 28,000, in a table...