T-SQL script to get list of tables which dont have clustered index August 12, 2013 SELECT name AS Table_Name_WithoutClusteredIndex FROM SYS.TABLES WHERE OBJECTPROPERTY(OBJECT_ID,‘TableHasClustIndex’) = 0 ORDER BY NAME GO
SQL Server- Implementation of Database Mail 1. Background The purpose of this article is to describe implementation of database mail configuration in SQL Server so that…
SQL Server – How to create an assembly in SQL Server that references a .DLL file CREATE ASSEMBLY uploads an assembly from .dll file to use inside an instance of SQL Server. Below is the code…
How to Read and Use SQL Server Error Logs The SQL Server Error Log is a vital diagnostic tool that captures crucial information about server activities, errors, and system…