Learn more about SQL Server tools

   
   

















































SQL Server DBA Tips and Tricks


Latest SQL Server Tips
Deleting Historical Data from a Large Highly Concurrent SQL Server Database Table
I have a large table with millions of historical records. I was asked to remove millions of old records from this table, but this table is accessed by our system 24x7, so there isn't a good time to do massive deletes without impacting the system. In this tip I will show you an unconventional way of doing massive deletes.
What's Trending?
SQL Server Cursor Example
In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you provide some cursor examples? Can you give any guidance on when to use cursors? I assume Microsoft created them for a reason so they must have a place where they can be used in an efficient mann
SQL Server Tutorials
SQL Server Webcasts
Backup made easy with SQL Safe Backup

This demonstration will focus on the features and benefits of the SQL Safe Backup product developed by Idera to help you easily manage the backups and restores in your SQL Server environment.

Some of the features of SQL Safe Backup include:

  • Instant database restore
  • Speed up SQL Server backups
  • Maximize backup file compression
  • Reduce backup failures
  • Automate backup policies<
All Categories

 
Sponsor Information