Viewing 15 posts - 781 through 795 (of 7,631 total)
Here is an example that demonstrates what I said above:
CREATE SYNONYM [dbo].[SomeBigTable]
FOR [dbo].[<Insert Your Table Name Here>]
GO
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
set statistics TIME ON
set statistics IO ON
GO
print '==== 0...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 28, 2010 at 8:29 am
The difference between Logical Reads and Physical Reads is essentially one of Caching & Batching. There is a lot more detail to it in terms of Microsoft's specific terminology...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 28, 2010 at 7:37 am
Cool. That would be my choice, simpler.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 28, 2010 at 1:10 am
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
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 28, 2010 at 12:10 am
Paul: So on RollBacks, will it leave permanent gaps, try to recycle the gaps, or does it guarantee no gaps, ever? (I am pretty sure that this last...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 28, 2010 at 12:06 am
To the best of my knowledge, you cannot do anything like that in SQL Server as it does not allow you to alter, modify or in any way change its...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 27, 2010 at 11:58 pm
Umm? Something seems missing here. You've given us a DTD, what do you want us to do with it?
(ps., an XSD would probably be easier)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 27, 2010 at 11:49 pm
Thanks for letting us know the solution, Apijena.
One suggestion: something that I learned from Paul White, is that explicitly using the "/text()" function for queries like these can have a...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 27, 2010 at 11:45 pm
Welsh, et. al.:
I have been out the last day or so, and I sure am sorry that I missed this golden opportunity for self-promotion (:-)), as I have actually written...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 27, 2010 at 10:55 pm
exactly...:smooooth:
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 27, 2010 at 10:29 pm
Paul White (2/27/2010)
RBarryYoung (2/27/2010)
Secondly, I am a little confused, is there a good form of this query or only a bad form?
That was based on Jeff's code I think....
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 27, 2010 at 9:58 pm
agustingarzon (2/27/2010)
I'm posting a different plan, the one for the query suggested by Jeff.
What I meant originally is that it takes a lot to retrieve at the position 30.000, but...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 27, 2010 at 9:49 pm
Capture the actual query plans for both the bad one (30000) and the good one (31000), save them as *.sqlplans, zip them up and post them here as an attachment.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 26, 2010 at 9:01 pm
Matt Miller already covered batching with the OP on the first page. The OP is looking into it.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 26, 2010 at 8:54 pm
Jeff Moden (2/26/2010)
Welsh Corgi (2/26/2010)
There are many reasons to avoid this. If you want...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 26, 2010 at 8:50 pm
Viewing 15 posts - 781 through 795 (of 7,631 total)