By Lori Brown | Helpful Scripts , Miscellaneous , SQL Server , Tip of the Month
Recently I had to do some R&D for a project and needed to generate a large table to test performance on. Since it is important to test queries on large data sets I thought that I would post how I populated a few data types in my table. To test query results I decided that […]
Continue readingBy Ginger Daniel | Installation , SQL Administration , SQL Server
After you make sure you have everything in your environment ready to go and all the prerequisites that need to be done before deployment have been done, we are ready to install the AlwaysOn Availability Group! The following steps need to be performed in this order: Add Windows Failover Clustering (WSFC) to each replica (server) […]
Continue readingBy Ginger Daniel | Installation , SQL Administration , SQL Server
Before implementing your AlwaysOn Availability Group, make sure you have everything in your environment ready to go. There are several prerequisites that need to be done to ensure a successful deployment. These prerequisites focus on your Windows environment, the SQL instances, and the databases to be included in your AlwaysOn group. Windows: Windows Server 2008 […]
Continue readingBy 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 Server
One of our clients wanted to consolidate files on one of their servers. In doing this I realized that I was going to have to move the files for a database that is actually log shipped. This is a fairly easy task that is pretty well documented but since I had to do it I […]
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 reading