Posts tagged Query

Error “HRESULT 0x800A03EC” when outputting data to Excel

2
3 years ago
in
Sometime ago, I wrote a Query Tool application that output data from a database into Excel.  However, in the past few days, the users have been getting the “HRESULT 0x800A03EC” exception error when running a specific query. I knew that the application was working, because other query data was being [...]

Non-clustered indexes

0
3 years ago
in
When creating non-clustered indexes, you should never include the clustered index key fields (commonly used for the primary key) as part of the non-clustered index. This is because the fields will always be used within queries.  There is no need to specify them again. The only exception to this, [...]
Go to Top