Database Optimization & Structure Archives - {coding}Sight https://codingsight.com/category/database-administration/database-optimization-structure/ Blog for SQL Server DBAs and Developers Mon, 11 Sep 2023 08:40:57 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png Database Optimization & Structure Archives - {coding}Sight https://codingsight.com/category/database-administration/database-optimization-structure/ 32 32 SSDT (SQL Server Data Tools) for Visual Studio: Main Features https://codingsight.com/overview-of-sql-server-data-tools-ssdt-features/ Mon, 27 Sep 2021 08:33:17 +0000 http://codingsight.com/?p=17443 SQL Server provides SQL Server developers and administrators with dedicated client tools for day-to-day usage. Namely, they are SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT). Since SSMS is widely popular among all SQL Server developers and administrators, we will focus on the SSDT client tool more to understand the value of …

The post SSDT (SQL Server Data Tools) for Visual Studio: Main Features appeared first on {coding}Sight.

]]> MySQL SHOW USERS: How to List All Users in a MySQL https://codingsight.com/mysql-show-users-different-ways-to-populate-the-users-of-mysql/ Wed, 25 Aug 2021 08:44:18 +0000 http://codingsight.com/?p=16238 This article explains different methods to populate the details of the Users in MySQL. We can view the list of users by using any of the following methods. Environment Setup For demonstration, I have installed MySQL Server 8.0 on Windows 10 and created a user named NisargU. Run the below query to create a user. …

The post MySQL SHOW USERS: How to List All Users in a MySQL appeared first on {coding}Sight.

]]> User-Defined Functions in SQL Server https://codingsight.com/sql-server-user-defined-functions/ Mon, 16 Aug 2021 08:35:26 +0000 http://codingsight.com/?p=16097 User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of. Although they are very useful in many scenarios (WHERE clauses, computed columns, and check constraints), they still have some limitations and bad practices that can cause performance issues. Multi-statement UDFs might incur significant performance impacts, and this article will …

The post User-Defined Functions in SQL Server appeared first on {coding}Sight.

]]> SQL Server System Databases – Restore System Databases https://codingsight.com/sql-server-restore-system-databases/ Wed, 11 Aug 2021 10:15:54 +0000 http://codingsight.com/?p=15972 In the previous articles of the SQL Server System Databases series, we have learnt the purpose of all SQL Server System databases that comes as part of SQL Server installation and understood the best practices to be implemented for them. We have also understood the Tempdb and MSDB databases in more detail. Since Backup and …

The post SQL Server System Databases – Restore System Databases appeared first on {coding}Sight.

]]> MSDB Maintenance: Your Ultimate Guide to SQL Server System Database Management https://codingsight.com/sql-server-system-databases-msdb-maintenance/ Tue, 10 Aug 2021 07:17:45 +0000 http://codingsight.com/?p=15963 In the previous articles of the SQL Server System Databases series, we have gone through the System Databases that are installed by default during SQL Server Installation, understood the purpose of each of those system databases and explored the Tempdb database and its maintenance in more detail. In this article, we will explore the MSDB …

The post MSDB Maintenance: Your Ultimate Guide to SQL Server System Database Management appeared first on {coding}Sight.

]]> TempDB Full? How to Shrink and Maintain Your SQL Server’s Temporary Database https://codingsight.com/sql-server-system-databases-the-tempdb-maintenance/ Tue, 27 Jul 2021 10:37:00 +0000 http://codingsight.com/?p=15691 In my previous article about SQL Server System Databases, we learned about each system database that comes as part of SQL Server installation. The current article will focus on frequently faced issues around the tempdb database and how to resolve them correctly. What Is TempDB? As the name of this system database indicates, tempdb holds …

The post TempDB Full? How to Shrink and Maintain Your SQL Server’s Temporary Database appeared first on {coding}Sight.

]]> SQL Server System Databases Maintenance https://codingsight.com/sql-server-system-databases-maintenance/ Wed, 21 Jul 2021 09:00:23 +0000 http://codingsight.com/?p=15618 SQL Server Installation by default creates several system databases per instance to maintain and administer that instance. In this article, we will examine these system databases and understand their responsibilities. SQL Server System Databases In SQL Server, System databases are created during the installation process to store the SQL Server instance-specific configuration details to function …

The post SQL Server System Databases Maintenance appeared first on {coding}Sight.

]]> How to Get SQL Server Statistics Information Using System Statistical Functions https://codingsight.com/get-sql-server-statistics-information-using-system-statistical-functions/ Thu, 15 Jul 2021 11:05:34 +0000 http://codingsight.com/?p=15281 Often, we need to gather system statistics regarding running SQL Server Instances, such as the number of total connections attempted to SQL Server instance since its start, or the time that SQL Server spent in active operations, etc. Microsoft brought us a separate set of system functions to retrieve the system-related statistics.  Today, I am …

The post How to Get SQL Server Statistics Information Using System Statistical Functions appeared first on {coding}Sight.

]]> Import Data into Oracle Autonomous Data Warehouse using Oracle Object Storage https://codingsight.com/import-data-into-oracle-autonomous-data-warehouse-using-oracle-object-storage/ Thu, 22 Apr 2021 12:56:46 +0000 http://codingsight.com/?p=12912 Let’s imagine you have a large raw file and need to determine the best way to load it into an Oracle Autonomous Data Warehouse instance to explore and visualize data. In this article you will find a few Oracle solutions that allow you to do that. Below you can see a table that identifies use …

The post Import Data into Oracle Autonomous Data Warehouse using Oracle Object Storage appeared first on {coding}Sight.

]]> Git Branching Naming Convention: Best Practices https://codingsight.com/git-branching-naming-convention-best-practices/ Fri, 16 Oct 2020 13:02:48 +0000 https://codingsight.com/?p=10133 Git offers flexible branching strategies, but what does it mean? In simple words, a branching strategy is a set of rules, a convention that helps teams and developers – they can follow these rules and conventions to create a new branch, its flow, etc. Not using appropriate naming conventions leads to confusion and complicates the …

The post Git Branching Naming Convention: Best Practices appeared first on {coding}Sight.

]]>