Indexes are like the contents page of a book; they help SQL Server find data quickly. However, if indexes are fragmented or not designed optimally, data retrieval can slow down significantly.

Depends, I know from DB2 that a TS can cause havoc and suck up a lot of CPU and disk I/O. Depends on the table size though but still. Always use indexes and avoid TS ...

Microsoft has made some big promises for SQL Server 2008, a major update of its enterprise database product. Here's an outline of the key new features. SQL Server 2008: a first look | ZDNET ...

SQL Server Integration Services (SSIS) Pros Architecturally, SSIS has become simpler and more congruent with SQL Server 2012. The development environment is improved generally and now features a zoom ...

It's been a busy month for Microsoft. In the past few weeks, the company has released community technology previews for SQL Server 2008 Release 2, SQL Server StreamInsight and the SQL Azure Database.