One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or the database is slow. In the ...

SQL Server 2008 SP3 Express, a free edition of Microsoft's database management system, can be downloaded here. Microsoft also released a Feature Pack for SQL Server 2008 SP3.

How to Reindex SQL Tables. 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 ...

I have taught several classes on the new features of SQL Server 2008, made a Web Seminar and written a Whitepaper on the subject. I have also attended the SQL PASS Summit in Seattle where there ...

News SQL Server 2008 R2 SP2 Available for Download By Kurt Mackie July 27, 2012 Microsoft released SQL Server 2008 R2 Service Pack 2 this week and announced that it's available for download. The new ...

Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth ...

An index stores both the values of a table's columns and a system of directions that enable access to rows in that table by index value. Defining an index on a column or set of columns enables SAS, ...