SQL Server 2008 SP1 CU #9 is available for download

The SQL Server Release Services team recently announced that they have released a new Cumulative Update for SQL Server 2008 SP1: http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/07/19/cumulative-update-9-for-sql-server-2008-service-pack-1.aspx This update will bring you to build 10.00.2789.  From the…

All1 min read

Back-2-Basics: Diff Types of Joins in SQL Server

Back to Basics – Series ::  Cool links for getting to know about the Different Types of Joins in SQL Server. http://www.c-sharpcorner.com/UploadFile/raj1979/SqlJoins10012008164642PM/SqlJoins.aspx http://programming.top54u.com/post/Types-of-Joins-in-Sql-Server-2005.aspx Have Fun!! Happy Coding!!!

All1 min read

SQL Server 2008 R2 is finally RTM

Microsoft has finally released the upcoming version of their SQL Server, called “Sql Server 2008 Release 2(R2)”. Previously i have mentioned in my post that SQL Server 2008 R2 RTM is Nearer .…

All3 min read

SQL Server 2008 R2 RTM is Nearer

It was quite a surprise to see a forum post claiming the SQL Server 2008 R2 – Release Candidate 1, i first thought it was just a bogus information. Since so far i…

All3 min read

DATENAME() function in SQ Server

SQL has a DateName function, however it takes a datetime as a parameter, not a number Usage is as follows DATENAME(month,date) returns Month Name Sample Query SELECT DATENAME(month, GETDATE()) AS ‘Month Name’——————————…

All1 min read