by Desiree Harris; originally posted November, 30 2004 on OrcsWeb.com Many people know the importance of creating indexes on SQL Server database tables. Indexes greatly improve the performance of a database. However, while many people create indexes on their SQL Server tables, many people don’t maintain them properly to ensure queries run efficiently as possible. I’ll begin […]
Fill A DataGrid From Access Database
Originally posted October 2, 2001 on OrcsWeb.com The code below demonstrates how to connect to and query a Microsoft Access database then bind those results to an ASP.Net datagrid for display as an HTML table. <%@ Page language=”VB” Debug=”false” %> <%@ Import Namespace=”System.Data” %> <@ Import Namespace=”System.Data.OleDb” %> <script language=”VB” runat=”server”> Sub Page_Load(Sender as Object, […]
Exporting SSE Database Data to a Remote SQL Server
Originally posted April 15, 2006 on OrcsWeb.com When ASP.Net v2.0, Visual Studio 2005, and Visual Web Developer were released to manufacturing, ORCS Web began supporting those technologies making them immediately available to our clients. Visual Web Developer 2005 has a very cool feature that will allow you to dynamically create a SQL Server Express database for use when developing […]
SQL Server 2005 Export / Import Issues
We had a client run across some issues recently when they exported their SQL Server 2005 database from their old host and imported it into a new database at OrcsWeb. After spending quite a bit of time working with the client on why the application wouldn’t work, we tracked it down to a page on […]
How to Set All Databases to Simple Recover Model (Logging)
Below is a slight variant of some TSQL I borrowed from http://www.roelvanlisdonk.nl/?p=1703 It loops through all the databases on a server and changes the recovery model to Simple, which, if you aren’t aware, changes the amount of logging and how the logging is handled. You should make sure you aware of the impact of that change […]