As we reflect on the past and look towards the future, it’s important to take a moment to appreciate the progress we’ve made in the world of technology. For the past year, I’ve had the privilege of writing the Memory Lane series, which has allowed me to revisit the contributions I’ve made to this blog over the past 7 years. It has been a fantastic journey, and I’m excited to share the final episode of this series with you.

In this article, I’ve selected a few of my favorite articles from SQLAuthority.com throughout the years. These articles not only showcase the growth of technology but also highlight the progress I’ve made in my career. Let’s dive into some of these concepts and ideas.

Get Current User – Get Logged In User

One of the fundamental tasks in SQL Server is to retrieve information about the currently logged-in users. In this article, I provide a simple script that lists all the logged-in users in SQL Server. Understanding who is currently accessing the server is crucial for monitoring and managing the system.

Disable All Triggers on a Database – Disable All Triggers on All Servers

Triggers are powerful database objects that can automate actions based on specific events. However, there may be scenarios where you need to disable all triggers for a database or even across multiple servers. In this article, I address this common question and provide a script to disable all triggers. This knowledge can be valuable when performing large update operations or troubleshooting specific issues.

Importance of Master Database for SQL Server Startup

The Master database plays a critical role in the startup process of SQL Server. In this article, I answer common questions about the purpose of the Master database, the need for backups, and its significance in the startup sequence. Understanding the importance of the Master database is essential for maintaining a healthy SQL Server environment.

DECLARE Multiple Variables in One Statement

SQL Server offers various features that make it a unique and powerful product. One such feature is the ability to declare multiple variables in a single statement. In this article, I explore this capability and demonstrate how it can simplify your code and improve readability.

How to Enable Index – How to Disable Index

Indexes play a crucial role in optimizing query performance. However, there may be situations where you need to enable or disable indexes, especially during bulk insert operations. In this article, I discuss the common practice of disabling indexes before bulk inserts and provide a script to accomplish this task. Understanding how to manage indexes effectively can significantly impact the performance of your SQL Server.

List of all the Views from Database

Views are essential database objects that provide a logical representation of data. However, managing a large number of views can become challenging. In this article, I share a quick script that generates a list of all views in a database, including information about their indexes. This knowledge can help you gain insights into your database structure and optimize your queries.

Fundamentals of Columnstore Index

SQL Server offers two types of storage mechanisms: row store and column store. Understanding the differences between these storage types is crucial for optimizing query performance. In this article, I explain the concept of columnstore indexes and how they can improve search efficiency by storing data in columns rather than rows. This knowledge can help you design more efficient database schemas and improve query performance.

How to Ignore Columnstore Index Usage in Query

While columnstore indexes can significantly improve query performance, there may be scenarios where you need to ignore their usage. In this article, I address this requirement and introduce the query hint IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX. By using this hint, you can instruct the SQL Server Engine to use alternative indexes when querying data. Understanding how to control index usage can help you fine-tune your queries and optimize performance.

Storing Variable Values in Temporary Array or Temporary List

SQL Server does not natively support arrays or dynamic length storage mechanisms like lists. However, there are clever workarounds and solutions to store variable values. In this article, I discuss the limitations of SQL Server in this regard and provide a simple case where extraordinary coding is not required. This knowledge can help you overcome challenges when working with variable values in SQL Server.

Move Database Files MDF and LDF to Another Location

Managing database files is a critical aspect of SQL Server administration. In this article, I address the common scenario of moving database files to a different location. I provide a quick tutorial on how to accomplish this task, which is often done for performance and manageability reasons. Understanding how to move database files can help you optimize your storage infrastructure and improve overall system performance.

UNION ALL and ORDER BY – How to Order Table Separately While Using UNION ALL

The UNION ALL operator allows you to combine the results of multiple SELECT statements into a single result set. However, there may be situations where you want to order the individual tables separately within the combined result set. In this article, I demonstrate how to achieve this by adding an additional static column and ordering by that column. This knowledge can help you manipulate and sort data effectively when using UNION ALL.

Thank you for joining me on this journey through memory lane. I hope you’ve enjoyed revisiting these articles and exploring the concepts and ideas they present. Feel free to share your favorite article from this series and let me know if there are any other topics you’d like me to cover in future blog posts.

Stay tuned for more exciting content on SQLAuthority.com!