Viewing 15 posts - 586 through 600 (of 1,353 total)
Fill factors are not an exact science. But given the situation you describe, I would start with 80 and see how it goes.
August 13, 2015 at 1:23 pm
Bottom line: No, there is no need to worry.
But... if you are experiencing performance issues accessing data from this table, then you should be concerned. But you don't...
August 13, 2015 at 12:55 pm
If you're not experiencing slowdowns when accessing a table, I wouldn't worry about fragmentation percentages too much. Use it when you're investigating performance issues. Don't chase the number...
August 13, 2015 at 12:44 pm
If the index is on a small table, some amount of fragmentation can't be avoided because of the storage of pages in extants. If it's a large table, something...
August 13, 2015 at 12:02 pm
Where apportionment is required divide for all except the final installment and then correct for the rounding errors in the final one.
I don't understand what this means. Please clarify.
August 13, 2015 at 7:18 am
Go directly to the bookstore
or order it from Amazon. In any case, he's right. You will just have to take the time to dig in and learn....
August 12, 2015 at 7:10 pm
FLOAT and REAL are also illegal under EU and GAAP rules because they have rounding errors.
What's your recommendation then?
August 11, 2015 at 8:21 am
You are not going to be dividing the sales totals when creating an invoice
But average sales per invoice would be normal. It may be because I work almost exclusively...
August 11, 2015 at 7:30 am
When you have to perform division it will round
Dividing isn't limited to interest though. Calculating averages will also do this. I think I'll stick with four decimals...
August 11, 2015 at 7:10 am
If you're going to use the decimal data type, you should probably go to 4 decimal places. There is rounding that needs to take place behind the scenes. ...
August 11, 2015 at 5:46 am
Now you have two recommendations to get a copy of that book.
August 10, 2015 at 11:24 am
Yes, but couldn't a fact table have a surrogate with a secondary composite key that is declared unique ?
Absolutely. Some would say that's overkill since there are many who...
August 10, 2015 at 11:18 am
OLAP Data modeling is a complicated topic. Fact tables need a primary key. I have never used a composite key, but I guess this is not an error. Unlike...
August 10, 2015 at 6:09 am
advocate keeping all backups (full, diff, tlog) for at least a month
In too many cases the lose of the most current data for the last month would be catastrophic.
August 4, 2015 at 2:56 pm
As you have 2 days of log backups. If you restore latest full backup, do you apply log by looking at create date time or is there some auto way...
August 4, 2015 at 9:33 am
Viewing 15 posts - 586 through 600 (of 1,353 total)