November 2010 | SansSQL

Saturday, November 27, 2010

Quick flash back on MS SQL Server Code Names

Code Name         Final name                      
SQL95 SQL Server 6.0
Hydra SQL Server 6.5
Sphinx SQL Server 7.0
Shiloh SQL Server 2000 (32-bit)
Liberty SQL Server 2000 (64-bit)
Yukon SQL Server 2005
Katmai / Akadia SQL Server 2008
Kilimanjaro SQL Server 2008R2
Denali SQL Server 2012
Hekaton SQL Server 2014

Referencehttp://en.wikipedia.org/wiki/List_of_Microsoft_codenames#SQL_Server_family

Thursday, November 25, 2010

SQL Server 2008 : T-SQL Enhancement

As we all know, SQL Server 2008 came up with a huge number of changes which are helpful for both developers as well as DBA's. In this post I will be demonstrating about once such enhancement that is very helpful for data insertion.

The usual syntax for inserting data to a table is 

Insert into tbl_TSQLEnhancement values (1,'Usual','SansSQL')
Insert into tbl_TSQLEnhancement values (2,'Usual','Blog')
Insert into tbl_TSQLEnhancement values (3,'Usual','T-SQL')
Insert into tbl_TSQLEnhancement values (4,'Usual','SQL Server 2008')

If we are inserting multiple records at a time then we will have to write statements as shown above. But from SQL Server 2008 onwards, it is made easy by giving an option to insert more than one record in a single T-SQL statement as shown below.

Insert into tbl_TSQLEnhancement values
       (1,'New','SansSQL')
      ,(2,'New','Blog')
      ,(3,'New','T-SQL')
      ,(4,'New','SQL Server 2008')

Cool feature right?
So now it's time to try it out yourself.

/* Create Table */
Create Table tbl_TSQLEnhancement
(Id int not null,
Method nvarchar(10),
Name nvarchar(20))

/* Insert Data to table using Usual method */
Insert into tbl_TSQLEnhancement values (1,'Usual','SansSQL')
Insert into tbl_TSQLEnhancement values (2,'Usual','Blog')
Insert into tbl_TSQLEnhancement values (3,'Usual','T-SQL')
Insert into tbl_TSQLEnhancement values (4,'Usual','SQL Server 2008')

/* Insert Data to table using New method */
Insert into tbl_TSQLEnhancement values
       (1,'New','SansSQL')
      ,(2,'New','Blog')
      ,(3,'New','T-SQL')
      ,(4,'New','SQL Server 2008')

/* Retrive Data */
Select * from tbl_TSQLEnhancement

/* Cleanup Process */
Drop table tbl_TSQLEnhancement

Wednesday, November 17, 2010

Difference between Getdate() and GetUTCDate()


GETDATE()
GETDATE()
 function returns the current database system timestamp. This value is derived from the operating system of the computer on which the instance of SQL Server is running. 
If you are connected to the SQL server remotely then the timestamp displayed will be the timestamp of the SQL server machine and not your local machine.
UsageSELECT GETDATE() as [ServerTime]


GETUTCDATE(): 
GETUTCDATE() function returns the current UTC time. This value is derived from the operating system of the computer on which the instance of SQL Server is running. 
This can be used to store the timestamp that is independent of Time Zones.

Usage
SELECT GETUTCDATE() as [UTCTime]

Wednesday, November 10, 2010

MS SQL Server 2011 (Denali) Community Technology Preview 1 - Released

The Community Technology Preview (CTP) Version of MS SQL Server 2011 also know as 'Denali' is now available for download.
This is available in both 32 bit and 64 bit versions.
Click here to download CTP1 version of Denali.


To read about what's new in SQL Server 2011 code-named "Denali" - Community Technology Preview 1 (CTP1) click here.