SQL

There are lots of differences in Delete and Truncate Command. Some are listed below: TRUNCATE is much faster than DELETE. Reason for t...

If you get this error message in your SQL Server then read on: In "Results to Grid" format one cannot display more than 100 res...

We can use  sys.dm_db_partition_stats  DMV to find out this information select  OBJECT_NAME(object_id) as objname         , SUM (rese...

First create a table CREATE TABLE Table_1 (CustID int, CustName varchar(35)) go --Now Populat the table with some data DECLARE @iCtr I...

Run below query to delete all records from all tables: EXEC sp_MSforeachtable @command1 = “DELETE FROM ?” OR EXEC sp_MSforeachtable...