Viewing 15 posts - 571 through 585 (of 872 total)
Ok ... that's crazy ... because I've been modifying stuff quite a bit and I don't think the example I posted was the best bet ...
Anyways, one of the pieces...
April 24, 2008 at 11:30 am
matt stockham (4/24/2008)
Your index is on mydate, col1, col2, col3 - in that order?
No, I did not include mydate ... but yes the index is in the same order as...
April 24, 2008 at 10:25 am
That's the thing though ... it is using the index, but just scanning instead of seeking. The index matches the select columns of the query and even in the execution...
April 24, 2008 at 9:20 am
Well, I'm tweaking this proc in 2005 ... but I'm gonna have to push it into a 2000 environment 🙁 thus, includes are not a possibility ...
April 24, 2008 at 6:19 am
Grant, is your summary that the columns need to be included into the clustered index?
April 24, 2008 at 5:56 am
matt stockham (4/23/2008)
a) the stats are old, or inaccurate for the date range
b) it's more efficient to just use a scan - the...
April 24, 2008 at 5:54 am
rbarryyoung (4/22/2008)
If mydate is not the Clustered Index and the total numbers of rows it estimates to return exceeds some value (10% maybe?), then it will scan instead of seek.
Really?...
April 24, 2008 at 5:50 am
Ok, the datatype of the column was smalldatetime ... I was able to remove the implicit conversion, but still scanning instead of seeking. What are other usual suspects of this?
Thanks
April 22, 2008 at 1:45 pm
So far so good ... this definitely looks to be what I needed. Now I just have to determine what I want to do with the data ...
Thanks again...
April 2, 2008 at 12:36 pm
Awesome! I'm playing with it now, but oh my is this taking awhile ... probably gonna need an index or two to support this beast.
I'll let ya know, thanks again!
edit:...
April 2, 2008 at 11:57 am
Kyle Schlapkohl (3/28/2008)
What does this mean when unknown is queried?-Kyle
Means that the registry location is incorrect. @key='SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer'
March 28, 2008 at 1:05 pm
neeraj arora (3/28/2008)
You can use this query to get the info
DECLARE @test-2 int
EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer',
@value_name='AuditLevel',
...
March 28, 2008 at 1:00 pm
So when comparing my current database to a backup taken before my maintenance ... the index/table sizes did not increase at all ... it appears that the unused space is...
March 25, 2008 at 9:42 am
Frank Brennan (3/24/2008)
Additially, setup the -T1118 trace flag for sql startup. The result is that your tempdb allocations will be scattered across multiple files all having their own allocation...
March 25, 2008 at 9:22 am
Steve Jones - Editor (3/25/2008)
I agree with Doug. allowing developers to make changes to anything other than development is asking for deployment issues.
I can't wait for the policies feature of...
March 25, 2008 at 9:10 am
Viewing 15 posts - 571 through 585 (of 872 total)