SQL

SQL server uses the  STATISTICS  to find the appropriate Query plan. if you are experiencing performance issues for your queries than it...

Use below query to find out parameters for Stored Procedure SELECT Schema_Name(Schema_ID) AS Schema_Name,  O.Type_Desc,  O.Name AS Obje...

Sometime you may want to return a random number for each row. You can not do this directly selecting a RAND() function in query: SELECT R...

In SQL Server there is not direct function to calculate the number of words in a string.  But we can calculate the number of words in foll...

Use below query to find the Index with size in a table: SELECT OBJECT_Name(I.OBJECT_ID) AS TableName, I.index_ID AS IndexID, I.Name...