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
How to get the DDMMYYYYHHMMSSMMM and YYYYMMDDHHMMSSMMM date formats in SQL Server. Below are the SQL statements by which we can get the required formats: DDMMYYYYHHMMSSMMM format : SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(),…
SQL Server – Reason for stored procedure not returning any data Following could be reason(s): 1) Multiple Exit Point in the stored procedure. We may have RETURN statement before stored procedure…
Overview of SQL Server BI Model SQL Server Business Intelligence Model basically consists of four main services i.e. SQL Server Relational services, Integration Services, Analysis Services…