ChrisM@Work

Forum Replies Created

Viewing 15 posts - 4,576 through 4,590 (of 10,143 total)

RE: How to make my number shorter??

karim.boulahfa (5/21/2013)
ChrisM@Work (5/21/2013)
karim.boulahfa (5/21/2013)
The valua is FLOAT of the column
FLOAT is the data type.
Can you show some sample data for the columns I listed?
select *
from StatisticalDisk
Thats are the rseult...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2013 at 5:50 am

#1616948
RE: How to make my number shorter??

karim.boulahfa (5/21/2013)
The valua is FLOAT of the column
FLOAT is the data type.
Can you show some sample data for the columns I listed?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2013 at 5:26 am

#1616938
RE: How to make my number shorter??

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,...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2013 at 5:17 am

#1616933
RE: How to make my number shorter??

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 21, 2013 at 4:11 am

#1616915
RE: COUNT function during 0 case

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
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 20, 2013 at 8:44 am

#1616649
RE: same function from sql 2000 doesn't work on sql 2008 r2

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,...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 17, 2013 at 8:28 am

#1616207
RE: CROSS JOIN vs INNER JOIN performance issue.

GilaMonster (5/17/2013)
T.Ashish (5/17/2013)
Though I know the drawbacks of NOLOCK, it can't be avoided in our case.
Really? So you absolutely must allow potentially incorrect data in results because ....
And...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 17, 2013 at 7:30 am

#1616176
RE: Parent child relationship in separate tables

kunal.desai 7690 (5/17/2013)
Agreed that ParentId in my results are not in the table, but that is what I want to generate!!
then you must explain the rules for generating ParentID.
Your query...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 17, 2013 at 7:01 am

#1616160
RE: Updating Covering Indexes

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 17, 2013 at 6:56 am

#1616153
RE: Parent child relationship in separate tables

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 17, 2013 at 6:42 am

#1616144
RE: CROSS JOIN vs INNER JOIN performance issue.

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 17, 2013 at 6:35 am

#1616140
RE: CROSS JOIN vs INNER JOIN performance issue.

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.
...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 17, 2013 at 5:52 am

#1616129
RE: Updating Covering Indexes

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 17, 2013 at 5:36 am

#1616124
RE: update statement optimization?

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 17, 2013 at 2:58 am

#1616088
RE: Stuck with this update statement

patrickmcginnis59 10839 (5/16/2013)
is Id unique in both tables? If it isn't, maybe you have a cross join going on because you're joining on it. Now if you have a case...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 17, 2013 at 1:05 am

#1616065

Viewing 15 posts - 4,576 through 4,590 (of 10,143 total)