Thanks again. I'll follow your advices and Frank's advices too. You folks help me a lot. Patrick MacKAY ASP.NET MVP
thank you Mirko for taking the time. I have one question. How many indexes are the maximum that you think that a table can have? We don't have more...
Thanks Mirko, I'll add that tests to determine which indexes works better. I'm sorry for not providing more information... The db model is the next...
Frank, I'll check out this links when I return to my office. Now, I'm at the MVP summit. Before I realize that the best combination was the...
Mirko, the number 4 works great. I tried first the number 2, but it doesn't work. That makes the query run very slow. I used "dbcc...
There is something I forgot to tell since the first post. In the queries, I need to filter over the four columns (c4,c5,c6 and c7) and 2 of the 3 PK...
Nope, because it wasn't really one column (col4). There were more than one column (four columns). I thought that the number of columns was not...
Frank, I did some tests with the index without the columns contained in the constraint, but the results was not what I expected. The query took...
MMarovic, I haven't tested the difference. It's a good point, but I guess that if I create the second index is because the performace was not...
Frank, I'm really surprised. I'll do that and find how the queries work. Satya, I rebuild the indexes and update the statistics once in a week,...
Hi again, I'm checking the indexes in our database, and I've found in several places the case that I'll explain here. The problem arises because...
Great thanks. Sometimes the information is there.....and we not see it. Patrick MacKAY ASP.NET MVP
Hi, a few days ago I read this topic http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3052, where someone ask about a raid...
Well, thank you all. Patrick MacKAY ASP.NET MVP
mmm ... mmm ... mmm ... thank you guys, I understand your points, and maybe it's better to rely on sql server and not to worry about it, but I...
Hi,<br /><br /> a few days ago I learnt that the data of a table with a clustered index are not sorted physically in the disk (I thought it...
Bert, Sometimes we need an explanation as yours. I really appreciate your time and the useful real-life example you did. Now, I have a better...
Bert, Thanks for the clarification. I'll not move the table to another file. I'm going to consider the raid 3 option and how it works under...
Bert,<br /><br /> following you first general rule, in case of this big table (38mill), it maybe a good idea to put in a separate file, but if I...
Bert, the raid for backups is a 3 (72GB) disk RAID5. I know the writing disadvantages of raid 5, but the raid is used only for backups, and we...
Separate names with a comma.
