Archive

Archive for June 16, 2013

free SQL server books for download

June 16, 2013 Leave a comment

download some of the BEST SQL server books ALL for FREEE … books on more then 10 topics …

available for free download ..

1> execution plan

2> profiler

3> security

4> SQL hardware and many more ..

JUST click on —– Download eBook (PDF): Free —— beside the book you are interested in ………….

http://www.sqlservercentral.com/books/

freeebook

 

ENJOY 🙂

Advertisements

what the service pack of my SQL server

June 16, 2013 2 comments

 

Hi all,

 

you may required to check your SQL service packs .. use below template to compare the same as of JULY 2013 …

 

use query as

 

1> select @@version

 

output ::

 

Microsoft SQL Server 2008 R2 (SP2) – 10.50.4000.0 (X64)

 

Jun 28 2012 08:36:30

 

Copyright (c) Microsoft Corporation

 

Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

 

2>

 

SELECT SERVERPROPERTY(‘productversion’)‘productversion’,SERVERPROPERTY(‘productlevel’)‘Servicepack’,SERVERPROPERTY(‘edition’)‘Product Edition’

 

use below chart for your reference

 

 

 

 

 

SP_list

 

chart referred from –> http://sqlserverbuilds.blogspot.in/

 

Enjoy 🙂