Learn more about SQL Server tools

solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips

   Got a SQL tip?
            We want to know!

SQL Server DBA Tips and Tricks

Latest SQL Server Tips
Enabling SQL Server Trace Flag for a Poor Performing Query Using QUERYTRACEON
You have a bad performing query. After extensive research you find a KB article that describes the issue as a Query Optimizer bug. You download and apply the hotfix, but nothing seems to happen. In this tip we look at the possible issues and how to solve optimizer issues with QUERYTRACEON flags.
What's Trending?
SQL Server AlwaysOn Availability Groups Fail the Initial Failover Test
In a previous tip, you have learned to setup AlwaysOn in SQL Server 2012. After a successful setup and everything seems to be in the right place, you are preparing to test your AlwaysOn to failover to your secondary replica for the first time. The first test is successful, but after testing to swing back again to your primary replica, you find out that automatic failover works only the first time.
SQL Server Tutorials
SQL Server Webcasts
SQL Server 2014 in a Flash
Redefine what is possible with your SQL database decisions today and into the future with purpose built Windows all-flash arrays that will optimize your SQL infrastructure, provide the best of physical, cloud and hybrid cloud environments and help you gain control of your windows business applications, SQL databases and workloads driving today's big data and business SLAs.

In this webinar you will learn about the benefits of a se
All Categories

Sponsor Information

Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | events | first timer?
Some names and products listed are the registered trademarks of their respective owners.