SQL Server is a powerful relational database management system that has been widely used in various industries for many years. Throughout its history, SQLAuthority.com has provided valuable articles and insights on SQL Server. In this blog post, we will explore some of the most interesting concepts and ideas related to SQL Server.
Query Analyzer Shortcuts
In 2007, SQLAuthority.com introduced a downloadable PDF that contained useful shortcuts for Query Analyzer. These shortcuts were designed to enhance the productivity of production DBAs who spend a significant amount of time working with SQL Server Management Studio (SSMS).
Fixing Remote Desktop Copy Paste Issues
Although not directly related to SQL Server, one of the most frustrating issues faced by many professionals working on Windows Server is the sudden stoppage of copy-paste functionality in Remote Desktop. This blog post shed light on this problem and provided solutions to overcome it.
Database Table Partitioning Tutorial
Database partitioning is a critical task performed by DBAs to improve performance and handle large volumes of data. This blog post provides a step-by-step guide on how to create horizontal partitions, which can significantly enhance the performance of a database.
Best Practices for Query Optimization
Optimizing queries is a crucial aspect of database performance tuning. In this article, SQLAuthority.com shares some simple yet effective tricks that DBAs can apply to achieve immediate performance gains. These best practices can help improve the overall efficiency of SQL Server databases.
Finding the Longest Running Query
Identifying and optimizing long-running queries is essential for maintaining a well-performing database. This blog post presents a script that can be used to find the longest running query in a database, allowing DBAs to focus on optimizing the most time-consuming queries.
Safe Operations for Shrinking NDF and MDF Files
Shrinking database files can have negative impacts on performance and should generally be avoided. However, there are scenarios where shrinking becomes necessary. This blog post discusses the safety of shrinking NDF and MDF files and provides insights into the potential risks and considerations.
Understanding Execution Plan Costs
Execution plans play a vital role in query optimization. This blog post addresses common questions related to the estimated I/O cost, estimated CPU cost, and the absence of unit measurements for these costs. Understanding execution plan costs can help DBAs make informed decisions when optimizing queries.
Tracking Statistics Update Date
Statistics provide valuable information about data distribution in database objects. Updating statistics is often recommended for optimizing queries. This blog post offers a query that can be used to determine the last update date of statistics, enabling DBAs to assess the freshness of their statistics.
The Pitfalls of Shrinking Databases
Despite the warnings against shrinking databases, it is still a practice observed in the industry. This blog post highlights the negative consequences of shrinking databases, including increased fragmentation and reduced performance. It aims to educate readers about the potential drawbacks and alternatives to shrinking.
SSMS Tricks in SQL Server 2012
SQL Server Management Studio (SSMS) is a powerful tool for database administration. This blog post showcases two enhancements introduced in SQL Server 2012: multi-monitor support and the clipboard ring feature. These tricks can improve productivity for DBAs working with SSMS.
Quiz Month: Testing Your SQL Server Knowledge
In January 2012, SQLAuthority.com hosted a quiz month, challenging readers with interesting questions related to SQL Server. This blog post lists several quiz questions covering topics such as MERGE, XML datatype, index management, piecemeal restore, database mirroring, fillfactor, and policy-based management. Test your knowledge and refresh your memory with these thought-provoking questions.
These selected articles from SQLAuthority.com provide a glimpse into the diverse range of topics covered over the years. Whether you are a DBA, developer, or SQL Server enthusiast, exploring these concepts and ideas can enhance your understanding and proficiency in working with SQL Server.
Which of these articles resonates with you the most? Let us know in the comments below!