SQL Server FAQ

I wanted a place to throw a lot of the high level SQL FAQ and answers for issues I come to.

v=sql.70 7
v=sql.80 2000
v=sql.90 2005
v=sql.100 2008
v=sql.105 2008R2
v=sql.110 2012
v=sql.120 2014
v=sql.130 2016

This site lists build versions, this is really useful for matching version to version by running the updates needed manually:

Microsoft SQL Server 2012, 2008R2, 2008, 2005, 2000 and 7.0 Builds

SQL Server 2012 msdn: Editions and Components of SQL Server 2012

SQL Server 2008 R2 msdn: Editions and Components of SQL Server 2008 R2

Server Editions:
*Datacenter
*Enterprise
*Standard

Specialized Editions:
*SQL Server Developer
*SQL Server Workgroup
*SQL Server Web
*SQL Server Express (SQL Server Express with Tools, SQL Server Express with Advanced Services)
*Compact 3.5 SP1 (x86) Compact 3.1 (x86)

SQL Server 2008 msdn: Editions and Components of SQL Server 2008

SQL Server 2005 msdn: Editions and Components of SQL Server 2005

Anything else was too old for my purposes.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

MSSQL Data links:

http://en.wikipedia.org/wiki/Microsoft_SQL_Server

Deprecated Database Engine Features in SQL Server 2012
http://msdn.microsoft.com/en-us/library/ms143729.aspx

Build version list, you have a version number and want to know what updates are in there:
http://sqlserverbuilds.blogspot.com/

Features Supported by the EditionhereherehereherehereNOPENOPENOPE

	SQL Server 2016	SQL Server 2014	SQL Server 2012	SQL Server 2008 R2	SQL Server 2008		SQL Server 2000	SQL Server 7
Hardware and Software Requirements	here	here	here	here	here		NOPE	NOPE
Editions and Components	here	here	here	here	here		NOPE	NOPE

Hardware and Software Requirements for Installing SQL Server 2012
http://msdn.microsoft.com/en-us/library/ms143506.aspx

Features Supported by the Editions of SQL Server 2008 R2
http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx

Features Supported by the Editions of SQL Server 2012 (FYI SQL web does support SQL profiler some how?)
http://msdn.microsoft.com/en-us/library/cc645993(v=sql.110).aspx

Features Supported by the Editions of SQL Server 2014
http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

Features Supported by the Editions of SQL Server 2016
http://msdn.microsoft.com/en-us/library/cc645993(v=sql.130).aspx

Features Supported by the Editions of SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms143761(v=sql.90).aspx

Prevent Truncation for Dynamically Generated T-SQL Results in SSMS
https://www.edwinbush.com/prevent-truncation-for-dynamically-generated-t-sql-results-in-ssms/

Migrating SQL Server Users
https://www.edwinbush.com/migrating-sql-server-users/