SQL Indexes

In MS SQL database, let's say there is a table with fields {A, B, C, D} and you have three queries

Query 1: Searches on A & B fields
Query 2: Searches on B & C fields
Query 3: Searches on A& C fields

For a better performance you would need 3 indexes, IX_AB, IX_BC and IX_AC. Having 1 index IX_ABC will not give the same performance as having 3 indexes.

Security Tab in Windows XP Professional

I just found out that the Security Tab in Windows XP would be disabled by default. To see the security tab for file or folder, one needs to turn off the Simple File Sharing used by Windows by default.

Follow instructions on this page: http://support.microsoft.com/default.aspx?kbid=307874

Or

1.	Click Start, and then click My Computer.
2.	On the Tools menu, click Folder Options, and then click the View tab.
3.	In the Advanced Settings section, clear the Use simple file sharing (Recommended) check box.
4.	Click OK.

For Sharing Tab

1.	Click Start, and then click Control Panel.
2.	Click Performance and Maintenance, click Administrative Tools, expand Services and Applications, and then double-click Services.
3.	Right-click the Server service, and then click Start.