Learn With Sundar

Get Started

  • List All Available Time Zone – SQL Server

    Introduction In this simple tips and tricks article, I would like to share how many time zones does our SQL Server supports. Well, it’s pretty much easy to find by using the system table sys.time_zone_info sys.time_zone_info Here is the sample T-SQL to get the list of time zones our SQL Server supports. is_currently_dst – This column…

  • DAX Basics in Power BI

    Introduction In Power BI, we can do a limited amount of calculations using Power Query Editor, but that is not enough to perform. For that we have DAX. DAX means Data Analysis Expression is an inbuild function which is the formula language that is used by Power BI. DAX is developed by Microsoft to interact…

  • To Get Total Number of Columns In a Table In SQL Server

    Introduction In this simple article, lets explore to get total number of columns in a table in SQL Server Example From the INFORMATION_SCHEMA.COLUMNS table we can find the number of columns in a table. TABLE_CATALOG – We need to pass the database name TABLE_SCHEMA – We need to pass the schema name TABLE_NAME – The…

  • sp_rename – Rename a column or table in MS SQL Server

    Introduction In this article, I would like to share how to rename a column name or table name in SQL Server using T-SQL. For that, we have to use sp_rename. sp_rename renames the objects in the current database. Renaming column name to new column name The syntax for renaming a column in SQL Server using…

  • Altering Column – From NULL to NOT NULL in SQL Server

    Introduction When working in SQL Server tables, sometimes we may need to change a column that allows NULL to NOT NULL. This change is required as part of business requirement, that is definitely this column contains value or else as part of performance improvements, we may be in need to change the column from NULL…

  • Execution Time of Stored Procedures In SQL Server

    Introduction When working in SQL Server Stored Procedures, we are keen about the execution time of it. Its very simple to find execution time of stored procedures in SQL Server. Execution Time Its simple to figure out the execution time of stored procedures using SET STATISTICS TIME ON. After executing the above statement, see the…

Subscribe

Enter your email below to receive updates.