General

How to and where to use inbuilt objects in SQL server

There are multiple options to get database table and index details. Here I explain some useful objects and their use. sp_help Reports information about a database object (any object listed in the sys.sysobjects compatibility view), a user-defined data type, or a data type. https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-help-transact-sql?view=sql-server-ver15 sp_helpindex Reports information about the indexes on a table or view. https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-helpindex-transact-sql?view=sql-server-ver15 sp_helpconstraint …

How to and where to use inbuilt objects in SQL server Read More »

How to get all database-level information using T-SQL

How to get database information using system tables. Here is the sample with flowing fields: database_id : Database Id dbName : Database name Status : database state like 0 DataFiles : count of data files 1 = RESTORING 2 = RECOVERING | SQL Server 2008 and later 3 = RECOVERY_PENDING | SQL Server 2008 and …

How to get all database-level information using T-SQL Read More »

How to find SQL Server Job history

This topic describes how to view the Microsoft SQL Server Agent job history log using SQL Server Management Studio, Transact-SQL, or SQL Server Management Objects. To view the job history log In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance. Expand SQL Server Agent, and then …

How to find SQL Server Job history Read More »

SQL Server Management Studio (SSMS) Shortcuts

SQL Server Management Studio is a powerful software that can help to design and development of database as well help in maintenance and administrative works too. Change Selected Database Ctrl + U: Once you are in the Sql Editor, pressing Ctrl + U selects the database dropdown in the Sql Editor toolbar. You can then …

SQL Server Management Studio (SSMS) Shortcuts Read More »

Still some developer use improper data type when designing database.

Storage in very important part in RDBMS that’s why Microsoft provide various data type to solve this problem. OLTP and OLAP database behave same when they processing a query. It will effect overall performance and storage. Finally it will require more infrastructure cost. Varchar vs Nvarchar: Choice for Unicode / multilingual  data If you want …

Still some developer use improper data type when designing database. Read More »

SQL Server services

SQL Server 7 Common Name Service Display Name Service Name Executable Name Distributed Transaction Coordinator (DTC) Distributed Transaction Coordinator MSDTC msdtc.exe SQL Server MSSQLServer MSSQLServer sqlservr.exe SQL Server Agent SQLServerAgent SQLServerAgent sqlagent.exe SQL Server Analysis Services MSSQLServerOLAPService MSSQLServerOLAPService msmdsrv.exe SQL Server 2000 Common Name Service Display Name Service Name Executable Name Distributed Transaction Coordinator (DTC) …

SQL Server services Read More »

error

Enjoy this blog? Please spread the word :)