join the MSSQLTips community

Today's Site Sponsor


 

all 12 Red Gate SQL Server tools in a single installer
 

Tips for Today  

JUL
2
SQL Server Filtered Indexes - What They Are, How to Use and Performance Advantages
JUL
1
Check the Last SQL Server Backup Date using Windows PowerShell
JUN
30
June 2009 Tips - Recap
 

Additional Tips

Best Practices for SharePoint Content Databases in SQL Server
Getting exclusive access to restore SQL Server databases
Using Identity Insert to keep SQL Server database table keys in sync
Custom Logging in SQL Server Integration Services SSIS
SQL Server DBA Telecommuting Tips
Index Usage Report in SQL Server
 

More

 
Latest News from MSSQLTips

Thursday, July 02, 2009

Today's tip SQL Server Filtered Indexes - What They Are, How to Use and Performance Advantages goes over the new filtered index feature in SQL 2008.


Today's highlights


The next MSSQLTips webcast is on July 8th.  Author and speaker Don Jones will show you how to become an effective SQL Server administrator.  Signup now for this great live webcast.


Interested in contributing to MSSQLTips?  Let us know!


Love it, hate it or leave it alone!  Give us your feedback!


Many thanks to our sponsors for keeping MSSQLTips absolutely free to the community:


How long is your SQL ‘To Do’ list in the morning?

Some professionals have discovered how to get more done.
 
Compare and Data Compare boxshot

"The functionality provided by the SQL Toolbelt is astounding."
Mustafa Bashti Ducto Group.

 

Download a 14-day free trial of SQL Toolbelt

SQL Toolbelt logo
Red Gate Software - ingeniously simple tools
 
Information From Our Sponsors
Free SQL Server performance monitoring dashboard – Idera SQL check

SQL Multi Script: single-click script execution against multiple SQL Servers. Download free trial.

Are you looking for more help and just cannot find it?

All SQL Server, all the time! Sign-up for the MSSQLTips newsletter!

This is MSSQLTips. How can we help you?

Free whitepaper - SQL Server Fragmentation Explained

Industry Leading Products
   LiteSpeed for SQL Server
When you need a rock-solid backup and recovery strategy, trust LiteSpeed™ by Quest Software. LiteSpeed gives you the control, lowering costs and speeding up the backup and recovery process.

See for yourself – download a trial of LiteSpeed today!
Copyright (c) 2006-2009 Edgewood Solutions, LLC All rights reserved
privacy statement | disclaimer | copyright | advertise | write for mssqltips | feedback | about
Some names and products listed are the registered trademarks of their respective owners.