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 Import Excel Data into SQL Server Using Python and Jupyter Notebook Python is a powerful and flexible tool for automating data movement between Excel files and databases like SQL Server. With…
How to Delete a SQL Server Database Safely A SQL Server database may be deleted when it’s no longer needed, such as after migration, project completion, or in…
SQL Server Reporting Services(SSRS) – Performance Monitoring & Optimization Common Report Performance Issues Data takes too long to retrieve Report takes too long to process Report takes too long…