This article describes how to check if a temporary table exists before you delete it. IF OBJECT_ID(‘tempdb..#tmpTable’) IS NOT NULL…
DBCC CHECKIDENT can reseed (reset) the identity value of the table. For example, YourTable has 25 rows with 25 as…
You will often find your database log file (.ldf) growing to a very large size, often larger than the databasie…
I had a problem with a SQL Server 2008 database that had a log file in excess of 90gb, when…
This article describes how to change the location of the data files and of the log files for any Microsoft…
When creating a SELECT query, sometimes you may want to display a dynamic field with a different value depending on…