SQL

There must be a numeric identity / Unique column for comparing current with next / previous Rows in a table.  Lets say you want to compar...

Today I was trying to change the transaction safety level in a database mirroring session from high-safety mode (safety full) to high-perfo...

Sometime when trying to browse the SSIS packages from SQL Server Management Studio the following error can come: The SQL Server specified...

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...