Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which SQL Server provides. By…
Sometimes it may require that you don’t know what will be output of a stored procedure ? what kind of result set it return…
Recently , one of my friends shared that some interviewer asked him a question “How to copy table structure only from a SQL Query?”…
Heap table:- A table without cluster index is called Heap table. Now you are thinking why we are talking about this. So as SQL…
b In last TIP tip#13, We learn how to find last updated statistics status. Now we know when it last updated so it may be…
To get file (MDF/LDF) information we can write following query GOEXEC sp_MSforeachdb ‘USE ? Execute sp_helpFile’ GO Or we can write following commandGoEXEC sp_MSforeachdb ‘USE…
To Get all columns information of a table we can use following command GO SELECT st.name, sc.name,sc.is_identity AS IdentityColumn, sc.is_nullable AS NullableColumn,sc.max_length as colmaxlength,sty.name…
We can get all the table’s name from a database using following simple syntax GOSELECT * FROM sys.objects WHERE type=’U’ AND Name <> ‘sysdiagrams’GO or…
To determine table detail like column name & data types for each individual table ,Index, primary key, foreign keys etc, sp_help is one of the…