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.

😎

Quick thought, check out this excellent article How to Import Data from HTML pages[/url] by Phil Factor

😎

Quick thought, the histograms represents information on data distribution and frequency, the optimizer preserves what it regards as the most useful of those and reduces the number of buckets (steps)...

Quick thought, this is an SSMS flaw when changing a table in design view, a workaround would be using DDL statements (ALTER TABLE) instead of the design view.

😎

First some quick questions

1) Data sizes?

2) Available high performance storage space?

3) Type of storage available?

Suggest using a staging area on the target Sql Server and replace the Lookup transformation with...

balasundar.sp (10/8/2014)

I have the open, close, high & low prices in a table. These are 0 minutes data, Would want to generate 5min, 15 min, 30 min, 60 min, 120min,...