Quick thought, it may be worth looking into splitting the table in two, one for the "Tasks" and another for the "Process attempts", so instead of updating the column a...

Quick note, you need to post more information, this is not enough!

😎

Have a look at this article: Solving SQL Server Database Physical File Fragmentation[/url]

😎

This...

What the code example demonstrates is that even if the error message is passed up to the application, it wouldn't make much of a difference as the cursor will still...

Quick suggestion, use the MERGE (Transact-SQL) statement

😎

First result I got was A Better sp_who2 using DMVs (sp_who3)

😎

On the tin...

Quick and simple solution, the problem is trivial if broken down into iteration by the different orders of magnitude, that is 1000 => 1 - 9, 100 => 1 -...

mahikero (3/28/2015)

If I try to connect to ServerName\I01, I get the error below.

"A network-related or instance-specific error occured while establishing a connection to SQL Server.

The server was not found...

Quick thought, you may want to re-think the error handling in the stored procedure, consider this code

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

IF OBJECT_ID(N'dbo.TBL_SAMPLE_RESULT') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_RESULT;

CREATE TABLE dbo.TBL_SAMPLE_RESULT

(

...

Jeff Moden (3/27/2015)

ScottPletcher (3/27/2015)

Eirikur Eiriksson (3/27/2015)

Until the locale driven...

Realize

Quick point, there is a hidden speed trap in the XML concatination, consider this code

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_DIAG') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_DIAG;

CREATE TABLE dbo.TBL_SAMPLE_DIAG

(

...

Until the locale driven implicit conversion starts to produce...

SQLRNNR (3/27/2015)

Yes you can certainly get a...