Viewing 15 posts - 766 through 780 (of 7,636 total)
Try it like this:
WITH
cteNumber AS
(
SELECT ID, ROW_NUMBER() OVER (ORDER BY ID ASC) AS IXX
FROM dbo.ContactForms
)
ctetop20 AS
(
SELECT TOP 20 num.*
FROM cteNumber num
...
March 1, 2010 at 11:00 am
agustingarzon (3/1/2010)
I double posted by mistake, sorry.Here are all the plans in the attached zip.
I am having the same problem as Paul on the sqlplan attachments. The zip worked...
March 1, 2010 at 10:48 am
Paul White (3/1/2010)
March 1, 2010 at 10:36 am
Sorry, the ACM group is "SIGMETRIC", not PMG (which appears to be a company in the UK). But I am still sure that there is abither,, research organization, I...
February 28, 2010 at 11:50 pm
Paul White (2/28/2010)
February 28, 2010 at 11:35 pm
Oh I see, both articles are by Joe Chang. Well Joe clearly has a great deal of knowledge in low-level detail and HW measurement, however, both articles come the...
February 28, 2010 at 3:46 pm
David Portas (2/28/2010)
RBarryYoung (2/28/2010)
This online article from the Microsoft documentation Books Online (BOL), explains it better than I ever could: http://msdn.microsoft.com/en-us/library/ms191300(SQL.90).aspx
Unfortunately the sample code given in that link is a...
February 28, 2010 at 3:12 pm
Paul White (2/28/2010)
Second point. Logical IO is misleading at the best of times in SQL Server.
I am sorry if I appear peevish in coming back to this, but there...
February 28, 2010 at 1:53 pm
fabi150 (2/28/2010)
Thank you for answers. But i still have to determine which of these costs mentioned above are better. Let's look on Query 1
having similar times what is better?....
February 28, 2010 at 1:43 pm
Paul White (2/28/2010)
A very small thing regarding your script: if you are going to issue DROPCLEANBUFFERS, you should always issue CHECKPOINT first. Otherwise, you're just dropping unmodified data from...
February 28, 2010 at 1:34 pm
lmu92 (2/28/2010)
Do you know the structure of your XML file?If so, can you post some sample data to describe the structure?
I agree with Lutz. We can't help you very...
February 28, 2010 at 1:12 pm
RBarryYoung (2/28/2010)
lmu92 (2/28/2010)
RBarryYoung (2/28/2010)
What I did notice though is that adding the text function ("(.../text())[1]") really seems to help the optimizer to produce a much more efficient XML query (I...
February 28, 2010 at 1:01 pm
lmu92 (2/28/2010)
RBarryYoung (2/28/2010)
What I did notice though is that adding the text function ("(.../text())[1]") really seems to help the optimizer to produce a much more efficient XML query (I actually...
February 28, 2010 at 12:36 pm
Paul White (2/28/2010)
lmu92 (2/28/2010)
Paul White (2/27/2010)
I compared your solution and mine using exec plan and mine is about 10-15 times faster (based on that limited sample data).
Really? I did...
February 28, 2010 at 9:30 am
Paul White (2/27/2010)
SELECT name = node.value('./@name', 'VARCHAR(30)'),
account = node.value('./@account', 'INTEGER'),
flag = node.value('./@flag', 'BIT')
FROM...
February 28, 2010 at 9:15 am
Viewing 15 posts - 766 through 780 (of 7,636 total)