In this article, I show you how to install SQL Server on a Windows machine (screenshots included).
In this case I used the installation wizard to install SQL Server 2019 onto a Windows 10 machine, using the Basic installation option, which uses the default configuration.
Continue readingSSMS (SQL Server Management Studio) is a graphical tool that you can use to administer SQL Server.
SSMS used to be bundled with SQL Server, but that is no longer the case. You must now install it separately.
This article shows you how to install SSMS (including screenshots).
Note that SSMS is only available for Windows machines. If you’re using a non-Windows machine (such as Mac or Linux), try Azure Data Studio or perhaps DBeaver.
Also note that Azure Data Studio is now included when you install SSMS (starting with SSMS 18.7).
Continue readingThis article provides step-by-step instructions for installing SQL Server 2019 for Linux on SUSE Linux Enterprise Server 12.
These steps should work on SUSE Linux Enterprise Server 12, SP2, SP3, SP4, and SP5.
You should have at least 2GB of memory before you install SQL Server on your SUSE machine. If you’re installing this on a virtual machine, you should have at least 2GB of memory allocated to it.
The file system must be XFS or EXT4.
Continue readingThis article provides step-by-step instructions for installing SQL Server 2019 for Linux on Red Hat Enterprise Linux (RHEL) 8.
I performed these steps using RHEL 8.3, but they should also work on RHEL editions 7.3 to 7.8, and 8.0 to 8.2.
You should have at least 2GB of memory before you install SQL Server on your Red Hat machine. If you’re installing this on a virtual machine, you should have at least 2GB of memory allocated to it.
Continue readingThis article provides step-by-step instructions for installing SQL Server 2019 for Linux on Ubuntu 18.04.
It should also work with Ubuntu 16.04 (just change the path as instructed).
You should have at least 2GB of memory before you install SQL Server on your Ubuntu machine.
Continue readingIn SQL Server, you can use the sys.partition_range_values system catalog view to find out the boundary values used for a partitioned table.
However, you’d need to know the function_id of the partition function before you use that view.
But as always, you can run a join against a bunch of other tables to get the desired info.
Continue readingIf you’ve got a partitioned table or index in SQL Server, and you want to check the parameter type of the partition function, you can use the sys.partition_parameters system catalog view.
This view returns a row for each parameter of a partition function.
The parameter type should match or be implicitly convertible to the data type of the partitioning column in the table or index.
Continue readingHere are a couple of ways to return partition info for a table in SQL Server.
sys.partitions system catalog view to return partition info for a table and most kinds of views.sys.dm_db_partition_stats system dynamic management view to return page and row-count information for every partition in the current database.If a table or index hasn’t been partitioned, these views will still return partition info (with a partition_number of 1). This is because all tables and indexes in SQL Server contain at least one partition, whether or not they are explicitly partitioned.
You can use the sys.partition_functions system catalog view to return a list of partition functions in SQL Server.
You can use the sys.partition_schemes system catalog view to return a list of partition schemes in SQL Server.