DBCC TIMEWARP?

I was tempted to suggest that only IBG and Jeff's queries can run that fast. Also, that queries running that fast can overheat the processor and should be slowed...

Bouke Bruinsma (5/6/2014)

---

ChrisM@home (5/6/2014)

---

Without sample data to test against...

Try this.

;WITH Updater AS (

SELECT

FTEHrsAVG,

NewFTEHrsAVG = AVG(CASE WHEN FlexVast = 'VAST' THEN FTEHrs ELSE NULL END)

...

Begin by eliminating the obvious differences - your parameters are different datatypes between the two environments. The datatype of your parameters should match the datatype of the table columns wherever...

WHILE affects only the statement immediately afterwards. If this statement is a batch defined by BEGIN and END, then the statements in the batch will be processed until the WHILE...

Jeff Moden (5/6/2014)

---

In most cases, I'd strongly agree with you but... with two DATE, one...

Variation on David's;

DROP TABLE #Sample;

CREATE TABLE #Sample (a INT, b INT, c INT);

INSERT INTO #Sample (a, b, c)

SELECT * FROM (VALUES (12345, 10000, 1),

(12345, 10000, 2),

(12345, 10000, 3),

(12345, 10001, 1),

(12346,...

Sean Lange (5/6/2014)

---

ChrisM@Work (5/6/2014)

---

PIVOT / UNPIVOT haven't been told about the output column limitation of SELECT. Here's how to get 10,001 output columns from a SELECT:

DROP table #Sample

Create table #Sample...

PIVOT / UNPIVOT haven't been told about the output column limitation of SELECT. Here's how to get 10,001 output columns from a SELECT:

DROP table #Sample

Create table #Sample (Empid int primary...

ChrisM@Work (5/6/2014)

---

10,000...

10,000 rows...

It won't need a genius, only a decent explanation. Perhaps a model would help. Try tinkering with this for starters:

SELECT [identifying field], A, B, C,

MAX(B) OVER(PARTITION BY [identifying field]),

CASE WHEN...

Sean's...

psingla (5/6/2014)

---

I have complex view and try to fetch data from it.

In following code query 2 takes 1 sec to execute and query 1 keeps on running for hours.

I tried...

yuvipoy (5/5/2014)

---

yuvipoy (4/22/2014)

---

After doing the recommendation i now see that the query is using index seek with 84%.

So my question is index seek is better than index scan

previously my query...

You have three options: dynamic sql, a catch-all query, or using IF blocks to test the parameters and run whichever query fits the parameters.

Catch-all queries are popular but come...