Format Number with Commas in SQL Server

Format Number with Commas in SQL Server Using Query

In this SQL Server tutorial, you will learn how to format number with commas in SQL Server. Where you will understand how to use FORMAT() function to format the number. Also, you will use the different format specifier with the FORMAT() function to format the value with commas. Format Number with Commas in SQL Server … Read more

How to Check Autogrowth in SQL Server Using Query?

Check Autogrowth in SQL Server Using Query

In this SQL Server tutorial, I will show you how to check autogrowth in SQL Server using query. In this tutorial, you will learn how to use the sys.master_files system view to check the autogrowth of a database and all the databases on the SQL Server. Also, use the sp_MSforeachdb and sp_helpfile system procedures to … Read more

Check Database Table Size in SQL Server

Check Database Table Size in SQL Server

In this SQL Server tutorial, you will understand how to check database table size in SQL Server. Where you learn about the different system procedures or views to check the size of each table within any database. Also, you will see how to use SQL Server Management Studio to check the table size. Check Database … Read more

How to Format Number with Commas and Decimal in SQL Server?

Format Number with Commas and Decimal in SQL Server using Format() Function

In this SQL Server tutorial, I will show you how to format number with commas and decimal in SQL Server. In particular, you will learn about the SQL Server FORMAT() function that helps in formatting the given numbers based on the provided format pattern. You can format the number with different format patterns, but here, … Read more

How to Check Database Size in SQL Server Using Query?

Check Database Size in SQL Server Using Query

In this SQL Server tutorial, you will learn how to check database size in SQL Server using query. You will understand the stored procedure in SQL Server that contains information about the databases and how to check the size of databases. Also, you will understand about view files in SQL Server to retrieve the database … Read more

How to Get Server Name in SQL Server using Query?

@@SERVERNAME Function to Get Server Name in SQL Server using Query

In this SQL Server tutorial, you will learn how to get server name in SQ Server using query. In this tutorial, you will understand two configuration functions in SQL Server which help in finding the name of the SQL Server. Get Server Name in SQL Server using Query To get server name in SQ Server … Read more