Question: How can I find tables in a SQL Server database that have a Primary Key ?  Answer: To identify if a table has a Primary Key - you can use the OBJECTPROPERTY method with the pro… Read More

Question: How can I find SQL Server Filtered Indexes  ?    We are woking on some migrations  from SQL Server to other engine platform and part of the process includes loc… Read More

A very simple way to rename table in PostgreSQL is using alter table statement. While changing table name you would be thinking about what will happen to indexes and other constraints on the… Read More

When you need to check the health or status of all INDEXs and need to REBUILD the required INDEXs depends on the Fragmentation level (%), you can get help from below SQL queries.In my exampl… Read More