Viewing 15 posts - 151 through 165 (of 219 total)
can you post those 6 records which are appearing in view and not in table?
Also the main query where it is being used?
May 24, 2012 at 12:12 pm
Let me clarify two things..
1. I was not testing the performance of max function. The reason I used max was that i did not want to use ssms resultset discard...
May 24, 2012 at 9:35 am
drop table mytable_part
go
drop partition scheme ps_mytable
go
drop partition function pf_mytable
go
create partition function pf_mytable(int)
as range left for values (10,20,30,40)
go
create partition scheme ps_mytable
as partition pf_mytable all to ( [primary])
go
create table mytable_part (id int,...
May 24, 2012 at 8:50 am
I will let others who have been following along here continue to help you with this. But I have a HUGE CAUTION for you: BEWARE doing tuning by running...
May 24, 2012 at 7:59 am
Speaking of "based on testing, not a wild guess" - have you actually TRIED your SELECT MAX(... query on a large partitioned table?
I had put a real time example to...
May 24, 2012 at 7:28 am
Not necessarily. Properly done indexing can provide just about the same benefit. Partitioning may give you somewhere around an additional 1% performance improvement over just indexing, but is that really...
May 23, 2012 at 12:01 pm
In this case, what if a report needs to be run (even if only rarely) on last year's data?
I think here partition elimination will sure be used and will...
May 23, 2012 at 11:24 am
It will help specially if you can provide the parttitoning columns. Not just this eliminates the partition but it might help in other indexes as well. This will reduce the...
May 23, 2012 at 10:32 am
drop table #office
go
create table #office
(office1 int,
dy char(3) not null,
hr int not null,
val int not null
)
go
insert into #office select 1,'mon',8,10
insert into #office select 1,'tue',8,10
insert into #office select 1,'wed',8,0
insert into #office...
May 23, 2012 at 9:40 am
Nice script.
If parallel plan is used in the procedure for any query(ies) then the cpu time doesnt reflect actual cpu time but of the thread which started the proc execution....
May 23, 2012 at 12:42 am
select TOP 1000 * into WealthMaker_MF.Transaction_ST_TMP from wealthmaker_mf.transaction_st
but query running from last 1 hour yet not completed .
It looks like that you want to insert just 1000 rows (...
May 22, 2012 at 3:48 am
Best would be if you just run the query without convert function on the sql server through ssms for both top 1000 and without it. Then see what output put...
May 21, 2012 at 11:23 pm
select t2.sid,t2.subcatgoryname ,count(t3.sid) subcategorycount
from @table2 t2
left outer join @table3 t3
on t2.sid = t3.sid
group by t2.sid, t2.subcatgoryname
Try this...
May 21, 2012 at 11:21 pm
Can you post the plan for top 1000 and without it? It looks strange that it returns the data with top and not returning without it?
Maybe some data type...
May 21, 2012 at 1:34 pm
Are you just querying the #missingindexes? You have to execute the final full query.
select
db_name(ddmid.database_id) as databasename,
object_name(ddmid.object_id,ddmid.database_id) as TableName,
ddmid.equality_columns,
ddmid.inequality_columns,
ddmid.statement,
ddmid.included_columns,
ddmigs.avg_total_user_cost,ddmigs.avg_user_impact,ddmigs.user_seeks,ddmigs.user_scans,
ddmigs.last_user_scan,ddmigs.last_user_seek,
ddmigs.unique_compiles
from
sys.dm_db_missing_index_group_stats ddmigs
inner join sys.dm_db_missing_index_groups ddmig
on ddmigs.group_handle = ddmig.index_group_handle
inner join sys.dm_db_missing_index_details ddmid
on...
May 21, 2012 at 1:22 pm
Viewing 15 posts - 151 through 165 (of 219 total)