Viewing 15 posts - 3,316 through 3,330 (of 8,416 total)
The SQL Server optimiser only ever considers plan shapes that involves at least one base table in every join.
Your query is written in one of the two possible ways to...
May 25, 2010 at 1:04 am
This is the actual code that ran to produce the execution plan in my last post:
DECLARE @Name NVARCHAR(100),
@Color NVARCHAR(100),
...
May 24, 2010 at 3:58 pm
James,
Your increasingly complex nested ORs and ANDs (now in multiple combinations) are looking less and less like the original 'simple' CTE every time you post. I do understand the...
May 24, 2010 at 3:56 pm
Jack Corbett (5/24/2010)
I think it is more that there is now better weather so people are getting out instead of threading.
Speak for yourself!
http://www.stuff.co.nz/national/3727912/Weather-warning-for-New-Zealand
May 24, 2010 at 2:35 pm
vk-kirov (5/24/2010)
Nice plug-in. It's a little bit buggy ('Index was outside the bounds of the array' all the time, mess-up with the index types), it doesn't provide the...
May 24, 2010 at 2:24 pm
CirquedeSQLeil (5/24/2010)
Great article Paul. This is useful stuff.
Appreciated Jason, thanks.
May 24, 2010 at 1:44 pm
The approach advocated by James is much more suited to simpler requirements based on OR conditions, as his second example shows.
The first submission attempted to apply the technique to a...
May 24, 2010 at 1:33 pm
Paul Muharsky-474732 (5/24/2010)
As I've mentioned on other posts that discuss server side paging, most of the examples I have seen deal with Single Table paging examples.
The examples provided in Part...
May 24, 2010 at 1:08 pm
Might be the same issue as http://internalsviewer.codeplex.com/WorkItem/View.aspx?WorkItemId=5882. Make sure you download the correct version - for either SSMS 2005 or 2008.
Download choice page:http://internalsviewer.codeplex.com/releases/view/21139
May 24, 2010 at 1:01 pm
What version is reported by SELECT @@version?
May 24, 2010 at 12:56 pm
vk-kirov (5/24/2010)
Thanks for the information. I definitely need to play with these commands for better understanding of table and index structures.
No worries. Some people find Internals Viewer (an SSMS...
May 24, 2010 at 12:25 pm
Anthony Perkins (5/24/2010)
You are of course absolutely right. I stand corrected.
No worries. It was a reasonable question, and I would be very surprised if you were the only...
May 24, 2010 at 11:20 am
vk-kirov (5/24/2010)
Paul White NZ (5/24/2010)
All three can be examined in detail using the familiar DBCC commands to verify that.What is the list of these commands?
EXTENTINFO, IND, and PAGE.
You also need...
May 24, 2010 at 10:00 am
Anthony Perkins (5/24/2010)
Thank you for the very good article.
Thanks for reading it 🙂
One question I have, has to do with the need for an ORDER BY clause for the overall...
May 24, 2010 at 9:52 am
Viewing 15 posts - 3,316 through 3,330 (of 8,416 total)