By Ginger Daniel | SQL Administration , SQL Server
AlwaysOn is a great new feature in SQL Server 2012 and 2014 Enterprise edition. It has been described as the next evolution of database mirroring. AlwaysOn enhances the existing technologies of database mirroring and failover clustering to provide a strong layer of high availability and disaster recovery. The way it works is that you have […]
Continue readingBy SQLRx Admin | Performance Tuning , SQL Administration , SQL Server , Tip of the Month
SQL Server Performance Tuning: Create indexes with included columns. I recently did some tuning work on a query that has computed columns in the SELECT. While the index that was being used by the query did contain columns used in the query’s WHERE clause performance was still not as fast as it could be. I […]
Continue readingBy Jeffry Schwartz | Miscellaneous , Performance Tuning , SQL Server
Recently, a coworker asked me about a query performance problem that had suddenly arisen as they so often do. During testing, this particular query had performed extremely quickly, but when it was shown to a C-level person, it dragged terribly making this impatient person wait 80 seconds for the answer to come back. We all […]
Continue readingBy Jeffry Schwartz | Performance Tuning , SQL Server , Windows
Introduction Have you ever been placed in the position of being forced to address user complaints about how slow the system is performing without really knowing exactly where to begin looking? Some analysts begin with Task Manager or viewing the Windows event log. Others who are working with SQL Server search the ErrorLog for problems […]
Continue readingBy SQLRx Admin | SQL Administration , SQL Server , Tip of the Month
SQL Server Administration: Every so often someone will call with a terrible problem because a drive was lost or someone mistakenly deleted transaction log files. When this happens, the affected databases are not useable and are usually marked as SUSPECT or IN RECOVERY in Management Studio. Usually the best option is to restore the database […]
Continue readingBy SQLRx Admin | SQL Server
This article excerpt, by Johan Åhlén, originally appeared here: http://bit.ly/1dARmgI Just when we thought that nothing could get any better than SQL Server 2012, Microsoft announced news around SQL Server 2014. There’s even a SQL Server 2014 website where you can get a free trial. So, what’s new and cool? Hekaton In-memory Database Capabilities Hekaton makes it […]
Continue reading