Work with data Archives - {coding}Sight https://codingsight.com/category/database-administration/work-with-data/ Blog for SQL Server DBAs and Developers Thu, 14 Mar 2024 21:25:42 +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 Work with data Archives - {coding}Sight https://codingsight.com/category/database-administration/work-with-data/ 32 32 How to Get SQL Percentage Calculation as Easy as Pie  https://codingsight.com/sql-percentage-calculation/ Thu, 14 Mar 2024 15:54:32 +0000 https://codingsight.com/?p=26091 Percentage calculation in SQL can be a bit like traversing an unfamiliar labyrinth. If you’re a beginner, it’s easy to get lost in a maze of numbers and functions. You may stumble over pitfalls that can lead to incorrect results. But fear not because we’re about to make SQL percentage calculations as easy as pie!  …

The post How to Get SQL Percentage Calculation as Easy as Pie  appeared first on {coding}Sight.

]]> SQL Server PARTITION BY: A Beginner’s Lifesaver on How to Partition Datasets  https://codingsight.com/understanding-sql-partition-by/ Fri, 21 Jul 2023 16:27:34 +0000 https://codingsight.com/?p=25208 Is SQL Server PARTITION BY clause giving you a brain freeze?  Beginners feel like entering a complex maze at first glance of code complexity. But you want to tackle this like a piece of cake, without the confusion. And without hair-pulling. So, this article is for you. We’ll make it plain and simple.  The complication …

The post SQL Server PARTITION BY: A Beginner’s Lifesaver on How to Partition Datasets  appeared first on {coding}Sight.

]]> T-SQL CHAR vs. VARCHAR: How to Store Text and Slash Query Time  https://codingsight.com/char-vs-varchar-in-sql/ Fri, 07 Jul 2023 13:06:46 +0000 https://codingsight.com/?p=25079 Is it a big deal to choose between CHAR and VARCHAR? What if your choice between CHAR vs. VARCHAR results in a nightmare of query lags?  When I was a newbie in SQL Server, it was not a big deal to me. Both store strings of characters so I thought it was just the same.  …

The post T-SQL CHAR vs. VARCHAR: How to Store Text and Slash Query Time  appeared first on {coding}Sight.

]]> The Importance of SQL Server Data Tools (SSDT) https://codingsight.com/sql-server-data-tools-ssdt/ Mon, 13 Sep 2021 05:56:50 +0000 http://codingsight.com/?p=16993 Any SQL Server DBA, Developer, or end-user always needs a client tool to connect to SQL Server and access its features. In this article, we will go through various Client Tools offered by SQL Server itself and learn about SQL Server Data Tools and its hidden potentials to make the lives of DBAs and Developers …

The post The Importance of SQL Server Data Tools (SSDT) appeared first on {coding}Sight.

]]> ENUM (Enumeration) Data Type in MySQL: Top 12 Facts and Useful Tips https://codingsight.com/what-is-mysql-enum-top-12-key-facts-you-need-to-know/ Fri, 23 Jul 2021 08:53:32 +0000 http://codingsight.com/?p=15721 MySQL ENUM data is a string data type with a value chosen from the list of permitted values. You set these permitted values during the table creation as shown below: Easy, isn’t it? For starters, data validation is instant without another table and a foreign key. Under strict server mode, this means you can’t force …

The post ENUM (Enumeration) Data Type in MySQL: Top 12 Facts and Useful Tips appeared first on {coding}Sight.

]]> VARCHAR and NVARCHAR Data Types in SQL Server https://codingsight.com/varchar-vs-nvarchar-data-types-in-sql-server/ Wed, 21 Jul 2021 09:40:09 +0000 http://codingsight.com/?p=15646 Relational databases represent an organization’s data in tables that use columns with different data types allowing them to store valid values. Developers and DBAs need to know and understand the appropriate data type for each column for better query performance. This article will deal with the popular data types VARCHAR() and NVARCHAR(), their comparison, and …

The post VARCHAR and NVARCHAR Data Types in SQL Server appeared first on {coding}Sight.

]]> How to Change Server Level Collation of Running SQL Server Instance https://codingsight.com/how-to-change-server-level-collation-of-running-sql-server-instance/ Tue, 20 Jul 2021 07:05:29 +0000 http://codingsight.com/?p=15414 In my previous article I have explained the basics of SQL Server Collation. I would suggest you first read that article (if you haven’t already). Here, I will show you how to change the server-level collation or the SQL Server instance-level collation of an existing SQL Server instance. What is Server Level Collation in SQL …

The post How to Change Server Level Collation of Running SQL Server Instance appeared first on {coding}Sight.

]]> How to Change Database Collation in SQL Server: Step-by-Step Guide https://codingsight.com/understanding-database-level-collation-and-impact-of-changing-it-for-database/ Mon, 19 Jul 2021 12:13:50 +0000 http://codingsight.com/?p=15377 When you develop an application or write a code in the SQL database system, it is crucial to understand how data will be sorted and compared. You can store your data in a specific language, or you may want SQL Server to treat case-sensitive and case insensitive data separately. Microsoft has provided an SQL Server …

The post How to Change Database Collation in SQL Server: Step-by-Step Guide appeared first on {coding}Sight.

]]> SQL VARCHAR Data Type Do’s and Don’ts for Faster Databases https://codingsight.com/the-best-sql-varchar-dos-and-donts-for-faster-databases/ Tue, 13 Jul 2021 08:05:46 +0000 http://codingsight.com/?p=15170 This post has “strings attached: for a good reason. We are going to explore deep into SQL VARCHAR, the data type that deals with strings. Also, this is “for your eyes only” because without strings, there will be no blog posts, web pages, game instructions, bookmarked recipes, and a lot more for our eyes to …

The post SQL VARCHAR Data Type Do’s and Don’ts for Faster Databases appeared first on {coding}Sight.

]]> FLOAT Data Type in SQL Server: A Practical Guide to Prevent Unexpected Mathematical Errors https://codingsight.com/sql-float-3-points-that-will-help-you-to-avoid-weird-math-errors/ Tue, 08 Jun 2021 10:31:45 +0000 http://codingsight.com/?p=14516 Have you ever thought that SQL can be wrong in math? It sounds crazy. But if you’ve used the SQL FLOAT data type, you may have come across the problems I am about to show you. Consider this. 0.1 + 0.2 should be 0.3, right? But check this out using SQL FLOAT data type. The …

The post FLOAT Data Type in SQL Server: A Practical Guide to Prevent Unexpected Mathematical Errors appeared first on {coding}Sight.

]]>