This is the essentially the same in SSIS 2012 (VS 2010)

😎

Quick thought, an identity property column cannot be updated, here is a demonstration and a workaround

😎

USE tempdb;

GO

SET NOCOUNT ON;

/* Drop if exists */

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

/*...

Quick (semi) dynamic sql approach, simple and self explanatory

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE TABLE dbo.TBL_SAMPLE_DATA

(

Doc_ID VARCHAR(20) ...

GilaMonster (10/10/2014)

Which the OP said he's using (albeit with a incorrect word, he said advanced settings...

Koen Verbeeck (10/10/2014)

You should see this as an...

Quick notes:

1) First of all this server needs patching, suggest you bring it up to SP3.

2) Read activity will not alter the data in any way, shape or form,...

Duplicate posting, respond to this thread instead.

😎

Quick questions

1) can you post the DDL for the table and all the indexes?

2) what is the result of select @@version

3) what kind of activity is on the table?

😎

Nice job Alan!

😎

Quick questions

1) Can you briefly describe the network topology/structure?

2) Which devices are between the attackers and your server (make/model/role)?

3) Are the attacks external? (how can you tell?)

4) What authentication mechanism...

Quick window function solution, note that it averages entries within the same minute, could be handled differently as Koen mentioned. This solution creates sliding 5 and 10 minutes windows on...

Quick though, you can play around with the order of values in the UNWANTED_CHARS, add some if missing and so on, should get you pretty close. As a general approach,...

Here is a quick rCTE based solution, probably not the most efficient but easy for an SQL developer to understand I would presume;-)

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

;WITH BASE_DATA(LN_ID,LastName,Problem) AS

(SELECT * FROM...

For fun, maybe do a trace to see what SSMS is doing wrong?

😎

First thought would be the SAN, check out the storage network / fibre network, don't think this is a software related error.

😎