Microsoft SQL Server

Home»Tag: Microsoft SQL Server

How To Create, Check And Change Identity Column In Microsoft SQL Server

Microsoft SQL Server has built-in an identity column (fields) which used for generating key values.  It may refer [...]

By |2017-08-30T14:47:37-07:00Modified: August 30, 2017|Published: August 30th, 2017|Categories: Databases|Tags: |0 Comments

Optimize SQL Server 2000 / 2005 / 2008 in Large RAM System by Locking Pages in Memory and AWE

Microsoft SQL Server is a data-intensive and disk I/O (read and write) intensive database management systems. For SQL [...]

By |2017-11-01T18:28:37-07:00Modified: November 1, 2017|Published: June 7th, 2008|Categories: Databases|Tags: , , , , , |0 Comments

Error Has Occurred While Establishing A Connection To SQL Server 2005 / 2008 / 2012 / 2014 Which Does Not Allow Remote Connections

When connecting to an instance of Microsoft SQL Server 2005 or Microsoft SQL Server 2008, Microsoft SQL Server [...]

By |2017-01-13T15:55:54-08:00Modified: January 13, 2017|Published: October 31st, 2007|Categories: Databases|Tags: , , , , |32 Comments

Create New Table by Selecting Data from Other Tables with CREATE TABLE AS

By using SQL data manipulation statement, a new, temporary, backup or regular table can be created and filled [...]

By |2016-12-09T08:41:38-08:00Modified: December 9, 2016|Published: August 23rd, 2006|Categories: Databases|Tags: , , , , |8 Comments