Nerd Techies

Learn & Share knowledge with nerds

Skip to content
Menu
  • ASP.NET
    • ASP.NET MVC
    • WEB API
  • Testing
    • Selenium
    • Coded UI
    • Load Testing
  • Database
    • SQL Server
    • MongoDB
    • OrientDB
    • Neo4jDB
    • PostgeSQL
    • DocumentDB
  • Azure
  • JavaScript
    • Angular JS
    • Node.JS
    • Knockout.js
    • Meteor.js
  • BI
    • SSIS
    • SSAS
    • SSRS
  • Events
  • NEWS

Category: table information

How easy to determine table dependencies ? TIP # 86

by Rajat JaiswalPosted onFebruary 24, 2015

  Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which  SQL Server provides. By…

Read More

How to determine Meta data or result set information of a stored procedure /trigger ? TIP # 73

by Rajat JaiswalPosted onNovember 20, 2014

  Sometimes it may require that you don’t know what will be output of  a stored procedure ? what kind of result set it return…

Read More

How to copy table structure only from a SQL Query ? Tip #69

by Rajat JaiswalPosted onNovember 3, 2014

  Recently , one of my friends shared that some interviewer asked him a question “How to copy table structure only from a  SQL Query?”…

Read More

What is Heap table in SQL Server and How to get all the heap table from a database ? TIP # 54

by Rajat JaiswalPosted onOctober 9, 2014

  Heap table:- A table without cluster index is called Heap table. Now you are thinking why we are talking about this. So as  SQL…

Read More

How to update statistics ? TIP #14

by Rajat JaiswalPosted onJune 6, 2014

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…

Read More

Get files (MDF/LDF) information of all databases – TIP #6

by Rajat JaiswalPosted onMay 28, 2014

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…

Read More

GET all columns of a table–TIP #4

by Rajat JaiswalPosted onMay 27, 2014

  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…

Read More

Get all the tables name from a database –TIP #3

by Rajat JaiswalPosted onMay 26, 2014

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…

Read More

sp_help a way to know detail tip #2

by Rajat JaiswalPosted onMay 25, 2014

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…

Read More
© Copyright 2019 – Nerd Techies
Cambium Theme by BestBlogThemes ⋅ Powered by WordPress