SQL Server – Temporary Tables

SQL Server temp tables are very useful for temporary modifications or transformations to data that we do not need to keep rather than manipulate or work with permanent tables. Let’s say you want full DDL or DML access to a table, but don’t have it. You can use your existing read access to pull the data into a SQL Server temporary table and make adjustments from there. Read More …

Change the Compatibility Level of a Database (SQL Server)

Compatibility level sets certain database behaviors to be compatible with the specified version of SQL Server. It affects behaviors only Read More …

SQL Server – Add Column Default Value

–> (Word) –> (PDF) –> (Epub) –> (Text) –> (XML) –> (OpenOffice) –> (XPS) Send Us a Sign! (Contact Us!) Read More …

SQL Server 2005 – Recover Database from SUSPECT Mode

Introduction Sometimes, you may have experienced that your Microsoft SQL database is marked as SUSPECT. Database may go into SUSPECT Read More …