OK, sorry. I guess I interpreted "any other benefits" too broadly.

Just curious. Since your table has at least 100M rows, did you review the indexes, particularly the clustered indexes?

That usually makes vastly most difference than how the...

Yeah, no gaps will be a royal pain to implement.

If you can allow "voided" gaps, then I think a standard identity would handle this, don't see the need for using...

WHERE

[Entered Date] >= DATEADD(MONTH, 6, DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE())

- CASE WHEN MONTH(GETDATE()) < 7 THEN 1 ELSE 0...

select times, LEFT(times, len(times) - 3) * 60 + RIGHT(times, 2) as seconds

from @time

The restores themselves per se wouldn't cause big tempdb growth.

However, I think it's possible that some settings in those dbs might (for example, snapshot settings).

As noted by all,...

You can use different RAID levels for data vs logs. Data often does best with RAID5, whereas logs often do best with RAID10.

sirishgreen (6/3/2014)

---

I thought I had cracked this issue but now....

and DE_Date between

'20140906' and '20140906'

This is being read as The 9th of June by SQL server.

After I looked...

To return a single "OR'd" row, I think you can just add MAX()es to the "standard" & conditions:

SELECT

STUFF(

MAX(CASE...

I think the overhead of XML is unwarranted here, if I understand the desired output correctly. needed[/i].]

But,...

Not 100% sure what output you want: the warranty date in a separate column based on its status or a status column itself, like below.

SELECT

machNameTab.machName

,warranty

,CASE WHEN warranty...

If you're saying all the tables already have the correct clustered indexes, as I noted in my previous post, I don't agree with that for at least:

dbo.DCSubRegionTran

This isn't something where...

First, as always, verify that you have the best clustered index on each table.

For example, just from a very quick look, table:

dbo.DCSubRegionTran

should have:

DCSRFiscYear

as its first clustering column, assuming you (nearly)...

I'd urge you to add a bit flag to the PROD table to indicate whether a given row has 7 consecutive valid flow values or not, rather than recomputing every...

SELECT

ISNULL(sales.ItemCode, returns.ItemCode) AS ItemCode,

ISNULL(sales.total_sales, 0) - ISNULL(returns.total_returns, 0) AS NetSales

FROM (

SELECT T0.ItemCode, SUM(T0.LineTotal) as total_sales

...