This is What'sUp Gold data. What version of SQL Server is hosting it?

The left joins in the query will be converted into inner joins by the child table joins:

INNER...

karim.boulahfa (5/21/2013)

---

select *

from StatisticalDisk

Thats are the rseult...

FLOAT is the data type.

Can you show some sample data for the columns I listed?

ChrisM@Work (5/21/2013)

---

What are typical values for SUM(nUsed_Min) and SUM(nSize)?

What are typical values for nUsed_Min and nSize?

You could operate on either the original values or the aggregated values by a constant,...

What are typical values for SUM(nUsed_Min) and SUM(nSize)?

Your query is easier to read if table aliases are used:

SELECT TOP 10

d.nDeviceID,

d.sDisplayName,

sgroupname,

sDescription,

dPollTime,

MIN(nUsed_Min) AS Minimaal_gebruik,

MAX(nused_Max) AS...

or something like this:

SELECT

p.ProductId,

t.TransactionCount

FROM Product p

LEFT JOIN (

SELECT

ProductId,

TransactionCount = COUNT(*)

FROM [Transaction]

GROUP BY ProductId

) t ON t.ProductId = p.ProductId

Linda_web (5/16/2013)

---

We have very strange situation I hope someone can help, we copied a database from sql 2000 sp4 to sql 2008 R2 SP2 , runs with compatibility level 2000,...

GilaMonster (5/17/2013)

---

Really? So you absolutely must allow potentially incorrect data in results because ....

And...

then you must explain the rules for generating ParentID.

Your query...

Sean Pearce (5/17/2013)

---

Hi Chris,

I'm more curious about the logical reads rather than the execution time. I tried my test script again, but rebuilding all indexes before the update, but saw...

Your results are incorrect - they show a parentid which doesn't exist in the table.

WITH ParentTable AS (

SELECT * FROM (VALUES

(1,'Parent1'),

(2,'Parent2'),

(3,'Parent3')) d (Id, Name)

), ChildTable AS...

The queries are logically equivalent, they generate the same result set. The plans are identical. What was the question again?

Think of your query as a description of the result...

T.Ashish (5/17/2013)

---

Dear All,

I have a query which was using CROSS JOIN (with relations) earlier and now we modified it with INNER JOIN.

...

Hi Sean

Just a hunch, I rebuilt all of the indexes then updated stats after loading the tables with data - and the results are quite different. Updating the table with...

lgegerton (5/16/2013)

---

DECLARE @Blocksize AS BIGINT = 5000,

@pagenum AS BIGINT = 0,

@ROWCNT AS BIGINT = 1;

While @ROWCNT > 0

BEGIN

Update ceb set CEB.new_WCDSCreatedOn = D.CreateDate

from contactextensionbase ceb join

(SELECT IndividualID,CreateDate

from #tmpIndividualCreateDates

order...