SET NOCOUNT ON Improves Stored Procedure Performance in SQL Server

 Move SQL Server transaction log files to a different location via T-SQL and SSMS

 SQL Server Cursor Examples

 Upgrading SQL Server databases and changing database compatibility levels

 Using the script task to dynamically build SQL Server Integration Services SSIS package variables

 Processing Data Queues in SQL Server with READPAST and UPDLOCK

 Export data from SQL Server to Excel

 Getting Started with Reporting Services

 SQL Server Integration Services (SSIS) Performance Best Practices

 Making the case for SQL Server Full Text Search

 We would like to welcome our newest author - Bru Medishetty

 Looking for SQL Server tools? Here are hundreds of industry leading products...

 Free...Free...Free...SQL Server Tools

 Many thanks to all of the MSSQLTips authors! You make great contributions to the community!

 SQL Server Tutorials on Stored Procs, SELECT, Backup, Restore, SSIS...

 User Group Listings Just Updated

 We are not bragging or anything, but we have over 40 tips on SQL Server 2008...Check them out...

 Searching and searching??? Find your SQL Server solutions here...

 Are you looking for a local SQL Server user group?

 Here are T-SQL solutions at your finger tips!

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

• Idera
• Quest
• Red-Gate
• SQL Sentry
• Devart
• IronSpeed

• Webcasts
• Whitepapers
• Tutorials
• Forums
• Blogs
• SQL Tools
• RSS Feed
• Follow MSSQLTips on Twitter
• Follow MSSQLTips on LinkedIn
• Contribute
• Feedback
• SQL Server Interview Questions