Viewing 15 posts - 38,206 through 38,220 (of 49,571 total)
Grant Fritchey (6/25/2009)
Oooh. That's a good one.
I'd give credit, but I have no recollection who initially said it.
June 25, 2009 at 10:01 am
saidwarak01 (6/25/2009)
My simple advise to moderators is any kind of post whether it is simple or tuff. It should be properly handled by giving some solution.
And it has...
June 25, 2009 at 9:50 am
Grant Fritchey (6/25/2009)
June 25, 2009 at 9:44 am
GDI Lord (6/25/2009)
IWhy would it use IX_Tmp_bob_pkColB if I haven't included any reference/data/information about pkColA in it? ("RTFM on covering indices!"?)
As I mentioned earlier, the clustering key is always part...
June 25, 2009 at 9:42 am
It's a good idea if you're expecting inserts into the middle of the index and you want to minimise fragmentation. That's certainly a possibility with the index you have defined...
June 25, 2009 at 9:41 am
Tim Walker (6/25/2009)
Additionally I am guessing it uses the index based on the varchar(3) column because it occupies less pages than the varchar(15) one.
Depending, of course, on the size of...
June 25, 2009 at 9:38 am
Grant Fritchey (6/25/2009)
Gianluca Sartori (6/25/2009)
I don't' remember such a rainy and (relatively)...
June 25, 2009 at 6:50 am
Eswin (6/25/2009)
How to avoid clustered and non-clustered index Scan's and also table scans.
Indexes that support the queries.
June 25, 2009 at 6:47 am
Those two queries are not equivalent. In the second one, only rows from bbb or ccc that satisfy the condition are presented for the join. Now, in an inner join,...
June 25, 2009 at 6:15 am
hi_abhay78 (6/25/2009)
June 25, 2009 at 6:02 am
Tim Walker (6/25/2009)
I wouldn't recommend testing behaviour on empty tables either, because I think it can produce misleading results.
Indeed. Reading 0 pages is pretty quick no matter what index.
Load...
June 25, 2009 at 5:36 am
Haver you checked that the script hasn't been truncated? Job steps only allow so much text in them.
June 25, 2009 at 5:32 am
Those aren't object_ids. Way too long to be an object id. It's partition id. Query sys.partitions with that to get the object and index id.
p.s. can you please edit your...
June 25, 2009 at 5:29 am
vrabhadram (6/25/2009)
please provider suggetions.
Don't truncate the transaction log. Don't shrink the transaction log. Both are not recommended for regular maintenance. Only time you should be shrinking the transaction log is...
June 25, 2009 at 4:26 am
Or you could restore the backup, add clustered indexes to the tables that are heaps and drop the clustered indexes straight after. That'll remove extent fragmentation.
June 25, 2009 at 4:18 am
Viewing 15 posts - 38,206 through 38,220 (of 49,571 total)