See performance gains by using indexed views in SQL Server Your email has been sent A view is a saved T-SQL query in SQL Server. The view definition is stored by SQL Server so that it can be used as a ...

Using Access to build a front end for SQL Server Your email has been sent What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your ...

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 ...

Sometimes, as when testing a table in a Microsoft SQL Server database, you need to reset an identity column to its initial seed value, typically one. During testing, you populate the table with data, ...

A recent project at my current employer called for creating a new web frontend to an existing MSSQL database. My boss, having created a sophisticated MySQL and PHP-driven black diamond web site in PHP ...