Viewing 15 posts - 1 through 15 (of 230 total)
I agree with you antares unless there has been deletes on the table as heaps reclaim empty space
March 25, 2004 at 3:42 am
Make sure you do not have auto-shrink on as it will lead to this problem. The percentage of MB growth depends on your level of need, if your db is...
March 18, 2004 at 10:37 am
I would also argue that it depends on too many things to say when a nonclustered index will be used when doing a "select *", I would argue that it...
March 18, 2004 at 10:35 am
Whoa, I think a lot of stuf flying around here.
Does a nonclustered index have to be covering to be used? - No
"Since there is no clustered index on this...
March 18, 2004 at 10:31 am
It is not using the nonclustered index becuase you are returning everything. When you do select *, it would make no sense for it to go to the nonclustered index,...
March 18, 2004 at 5:55 am
To add to James's post, watch where you place that clustered index, placed on the wrong type of column and you will get additional pagesplits as SQL tries to insert...
March 17, 2004 at 4:30 pm
See if this helps - http://sqlteam.com/item.asp?ItemID=2955
A cube would be a piece of cake to create for this and you have full flexibility with X and Y axis.
March 17, 2004 at 4:26 pm
Have you already ran at least one full processing yet? If yes, have you recently changed the structure of any dim tables? I would try to run a full process,...
March 17, 2004 at 4:22 pm
I agree with raibeart to a point, I would try to use star schema as much as possible but there are certain times...
March 17, 2004 at 4:20 pm
"delete from tbl1 where pid not in (select max(pid) from tbl1)"
Wouldn't that delete all rows exept the one with the max PID?
March 12, 2004 at 3:27 am
Do you mean going forward or historically? You might look into a product by Lumigent called Log Explorer or Entegra.
Going forward you could work some magic with SQL Profiler.
March 10, 2004 at 4:27 pm
I agree with all in that if you are write heavy and query-light, scsi is the way to go, however, if you are having to perform complex analysis or queries,...
March 8, 2004 at 3:52 pm
If you are transferring the whole db, I would not use DTS, I would use T-SQL jobs to do backup and restore. If they are on seperate machines you could...
March 8, 2004 at 6:22 am
I was trying to convey that was a bad thing alzdba, I should have mentioned I agreed with you too. Anytime SQL has to perform a lot of logic before...
March 8, 2004 at 3:40 am
I agree with Colin. Since 7.0 heaps were built to reclaim space, that means SQL will hunt out free space and try to insert new data where a page has...
March 8, 2004 at 3:20 am