MS-SQL Server - Input Perameters & Various Data Types

Input Perameters & Various Data Types..

Input Perameters

https://learn.microsoft.com/en-us/sql/relational-databases/stored-procedures/parameters?view=sql-server-ver16

However, it becomes Irrelevant when we ignore the datatype or specified length.

Data Types

https://learn.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-ver16

Additionally,

Causes for Space Issue

- Log file Full

- Recovery Model

- No Maintenance Cleanup job

sys.dm_server_registry

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-server-registry-transact-sql?view=azuresqldb-current

Ultimate Pivot

https://amit-sqldbasupport.blogspot.com/2022/11/sql-server-ultimate-pivot-script.html?m=1

Server Role

https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles?view=sql-server-ver16

Costing/Pricing - Management Studio

https://www.microsoft.com/en-in/sql-server/sql-server-2019-pricing

Procedure to send mail

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql?view=sql-server-ver16

Performance by Index Rebuild & Reorganize

USE AdventureWorks2012;
GO
ALTER INDEX PK_Employee_BusinessEntityID ON HumanResources.Employee
REBUILD;
GO
ALTER INDEX PK_Employee_BusinessEntityID ON HumanResources.Employee
REORGANIZE;
GO

I believe, for being a Professional SQL DBA, all we need to learn from DBA related learning websites and practice.... eg. https://learn.microsoft.com/.

Initially, we can start from Backup and Restore, Azure Basics, Different Type of Joins, Managed Services, Basics of HA, All Basic commands, Performance Monitoring.

Best Regards

T. Amit Vaid S.