The indexes on a the tables of a large database make a huge difference in its performance and utility. Without an index, locating a single record in a large table can take several seconds; with the ...

A WPF ListBox lets you display data created and stored in a SQL table. You must query the SQL database, and you use the retrieved data set to populate the ListBox items. The SQL table can contain one ...

The new capability supports tables, figures, and diagrams with spatial metadata, making documents searchable and actionable ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

We have an application that is used by users at two locations. It was set up with two SQL Servers and merge replication, because performance is an issue (neither end can work with the VPN lag). The ...

I am in an ongoing debate with my technical managers regarding accessing lookup tables and he keeps waving the "best practices" mantra at me but offers nothing concrete, I have several lookup tables ...

Updating fact rows inside a star schema set of tables is never a best practice. Even so, some organizations travel down this path. Consultants occasionally will go so far as to embrace the idea of ...