Sunday, May 20, 2012

Table variable

table variable will store in temp db only. when the tempdb space is
full then it will create on memory.
It is not always true that table variable will create in memory.
see the test bellow
DECLARE @tablevar TABLE(col INT);
INSERT INTO @tablevar VALUES(1);
SELECT TABLE_NAME
FROM tempdb.INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE '%#%';

Friday, April 20, 2012

SqlServer Supported OS


Sqlserver 2008 is supported on 32 bit and 64 bit operating System.
SqlServer 32 bit can install on 32 bit and 64 bit version of windows on windows (wow).

SqlServer 2008 Cannot be installed on windows Server 20008 Server Core .Windows server 2008 Server core does not support .net frame work. SinceSever relies on .net  frame work.

Sunday, February 26, 2012

SQL ServerHistory
 
Version
Year
Release Name
Codename
1.0
(OS/2)
1989
SQL Server 1.0
(16bit)
-
1.1
(OS/2)
1991
SQL Server 1.1
(16bit)
-
4.21
(WinNT)
1993
SQL Server 4.21
SQLNT
6.0
1995
SQL Server 6.0
SQL95
6.5
1996
SQL Server 6.5
Hydra
7.0
1998
SQL Server 7.0
Sphinx
-
1999
SQL Server 7.0
OLAP Tools
Plato
8.0
2000
SQL Server 2000
Shiloh
8.0
2003
SQL Server 2000
64-bit Edition
Liberty
9.0
2005
SQL Server 2005
Yukon
10.0
2008
SQL Server 2008
Katmai
10.25
2010
SQL Azure
Matrix (aka CloudDB)
10.5
2010
SQL Server 2008 R2
Kilimanjaro (aka KJ)
11.0
2012
SQL Server 2012
Denali