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 Create a Database Diagram from SQL Server Database Database diagrams are visual blueprints of your database schema, showing how tables relate to each other through primary and foreign…
Auditing, Tracking, and Change Monitoring Technologies in SQL Server 1. A Common Conversation about Auditing a. What was the value of this particular field ? b. How many…
SQL Server: How to create a linked server pointing to a server different from its name Background The purpose of this article is to provide a step-by-step method of creating a linked server that point to…