Spot on. Nothing to add IMHO.

20s against 0s is too huge a difference to be just parallel/serial plan. Something else must have changed in the plan.

Can you post both plans and table/index scripts please?

I don't like checking tempdb for corruption for two reasons:

1) It can't run on a snapshot, so it takes locks instead. If you have a 24/7 workload, it's out of...

I guess you're out of luck then.

There's no automated way to do it, so your only option is talk to the DB developers and make them notify everyone interested that...

jitendra.padhiyar (3/2/2015)

---

SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xfacb6aaa; actual: 0x9f6b18ec). It occurred during a read of page (1:39510) in database ID 18 at offset 0x000000134ac000...

+1

There's nothing like home after a long time...

CHECKDB runs on a snapshot on all editions. What you lose in STD...

Many things change from Standard to Enterprise.

Here's a full feature comparison: https://msdn.microsoft.com/en-us/library/cc645993.aspx

Ranking functions can help you here:

DECLARE @sampleData TABLE (

id int,

customerid int,

productid int,

[date] datetime,

quantity int,

total money

);

INSERT INTO @sampleData VALUES

(1, 1, 1, '20150201', 1, 10),

(2, 1, 2, '20150202', 1, 20),

(3, 1,...

Fandy08 (2/27/2015)

---

I made some test with varbinary(max) datatype (instead of image) and the following sequence works, LOB data is released and canceled from database.

So the problem is limited to (deprecated)...

No benefit, unless the additional file resides on a different (physical) disk and the sizes of the data files in the same filegroup are identical.

You should grow the files manually...

Damn Microsoft marketing branding...

Always-On Failover Cluster Instances is one thing and Always-On availability Groups is another one. Together they're branded as "Always-On".

Since failover clustering had been around for 15 years,...

+1

Eirikur Eiriksson (2/26/2015)

---

Have a safe...

Creating or rebuilding indexes online have different behaviors as far as the final lock is concerned.

When an index is (re)built, a temporary mapping index is populated and, at the...

Lowell (2/26/2015)

---

arrjay (2/26/2015)

---

Perfect! Thanks.

The results don't include objects which have not been written/read to/from i.e. nulls. Is there a way of returning these stats? Thanks...