Easy way to reseed identity column ? TIP #77

 
Sometimes, we may require to reseed identity column of a table due to various reason.
For example we have deleted a...

Sequence feature TIP #76

Although it is a old feature for those who knows ORACLE but for SQL server developers it is a new...

How to determine free space on each fixed drive of server machine using SQL SERVER ? TIP #75

 
When you do  SQL Server maintenance one of important aspect is available space on server drive because your SQL SERVER...

How to disable constraints of a table ? TIP #74

 
You are reading this post just because of two reason
1) You are curious whether it is possible or not...

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

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

How to replace a specific string from a large string with Write feature ? TIP #72

 
This is very interesting feature and I recently come to know this awesome feature.
Lets understand this by an example below...

How explicitly insert default value ? TIP #72

 
Suppose, sometimes you just need  entry in the table with all the default values.
For example you have a Student...

How to pause execution for particular time or interval ? TIP #71

 
Suppose, We are working on a stored procedure in which some complex operation is going. We are fetching some value...

How to find all running SQL Server Instance on a machine ? TIP #70

Hello friends,

Many times it happened with me I forgot the instance name of SQL Server.

So here is a small trick...

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

 
Recently , one of my friends shared that some interviewer asked him a question “How to copy table structure only from...