How to find the Size of INDEX on Specific TABLE in SQL SERVER

How to find the Size of INDEX on ALL TABLE in the current Database in SQL SERVER

Enable the Xp_CmdShell from "Surface Area Configuration Manager.

We are going to get the System Defined Procedure text in SQL Server

We are going to get the System Defined View text in SQL Server

We are going to see the Formula of sys.all_objects.

This helps to find all The User Defined Functions (UDF) in a Database.

Here we see how to Configure Ad Hoc Distributed Queries in SQL SEREVER

we are going to see how to enable OPENROWSET and OPENDATASOURCE support in SQL Server 2008

We are going to see How to Reset Identity column in SQL Server

We are going to see how to use DBCC CHECKIDENT command to Reseed a Table After Delete in SQL Server.

We can get get all procedure text using a single query in SQL Server.

SQL Server 2008 R2 has several new features and here is a list of a few.

FOR XML PATH in sql is used to get comma separated values from tables where there is one to many relation between tables

In this blog I am not going to write a big epic on how to crack interviews but just briefing on it in “write less, guess more, and understand most” manner...

By using this we can get all the available data types in the sql server.

In this blog, let us see how to sum the total hours present in the varchar column in SQL server.

List of all Tables that are not having any index (clustered/ non-clustered).

List of all indexes on a particular table including Clustered as well Non-Clustered indexes.

This small article is based on a situation where you need the ID of your latest inserted record from a database table.