Related posts about index

• NTFS Corruption: Files created in Linux corrupted when Windows Boots

  as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
  I'm getting some file loss and corruption on my Win7/Ubuntu 12.04 dual boot setup. I have a large shared NTFS partition. I have my Windows Docs/Music/etc. directories on that file and have the comparable directors in Linux setup as a sym. link. I'm using ntfs-3g on the linux side of things to… >>> More

• SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint

  as seen on SQL Authority - Search for 'SQL Authority'
  Recently I received the following two questions from readers and both the questions have very similar answers. Question 1: I have a unique requirement where I do not want to use any index of the table; how can I achieve this? Question 2: Currently my table uses clustered index and does seek operation;… >>> More

• Covering Index versus Clustered Index (Database Index)

  as seen on Stack Overflow - Search for 'Stack Overflow'
  Hi, I'm working on a database system and it's indexes, but I'm having a really hard time seing the clear difference between a covering index and a clustered index. I've googled my way around but hasn't got a clear cut answer on: What is the differences between the two types of indexes When do… >>> More

• SQL SERVER Force Index Scan on Table Use No Index to Retrieve the Data Query Hint

  as seen on Dot net Slackers - Search for 'Dot net Slackers'
  Recently I received the following two questions from readers and both the questions have very similar answers.Question 1: I have a unique requirement where I do not want to use any index of the table; how can I achieve this?Question 2: Currently my table uses clustered index and does seek operation;… >>> More

• Custom SNMP Cacti Data Source fails to update

  as seen on Server Fault - Search for 'Server Fault'
  I'm trying to create a custom SNMP datasource for Cacti but despite everything I can check being correct, it is not creating the rrd file, or updating it even when I create it. Other, standard SNMP sources are working correctly so it's not SNMP or permissions that are the problem. I've created a… >>> More