Introduction Hi All, How are you today? In this article we will see a solution for a fix that we usually encounter when you work in ...

Introduction Hi All, I hope you are fine. We all are using SQL parameter in our application right?Yeah it is a good way to restrict the ...

This code helps you to find out the missing Indexes in SQL SELECT d.[object_id], s = OBJECT_SCHEMA_NAME(d.[object_id]), o = OBJECT_NAME(d.[object_id]), d.equality_columns, d.inequality_columns, d.included_columns, s.unique_compiles, s.user_seeks, s.last_user_seek, ...

Find the relationship difference between two DB. SELECT f.name AS ForeignKey FROM sys.foreign_keys AS f where f.name not in (SELECT f.name AS ForeignKey FROM inova.sys.foreign_keys AS ...

find the relationships between tables in SQL Server 2008 SELECT f.name AS ForeignKey, SCHEMA_NAME(f.SCHEMA_ID) SchemaName, OBJECT_NAME(f.parent_object_id) AS TableName, COL_NAME(fc.parent_object_id,fc.parent_column_id) AS ColumnName, SCHEMA_NAME(o.SCHEMA_ID) ReferenceSchemaName, OBJECT_NAME (f.referenced_object_id) AS ...

Find which are all table has set identity. select COLUMN_NAME, TABLE_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA = 'dbo' and COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') = 1 order by TABLE_NAME

Hi All, This code will helps you to get the count of entries in each table in a DB in SQL: SELECT sysobjects.Name , sysindexes.Rows FROM ...

Get the table count in a DB in SQL. select * from sys.tables where is_ms_shipped='0'