Archive for August 2008
Finding version of service pack installed on SQL server
Posted by: Manpreet Singh on: August 28, 2008
There are times when we have to look for service pack installed on SQL Server Database Servers. SQL server provides us with many different ways to check service pack installed. Some of most commonly used methods are given below
1). @@version
Using @@version we can see information about SQL server installed on machine
The syntext are
Print [...]
OLAP Databases with SQL Server 2005
Posted by: Manpreet Singh on: August 27, 2008
With the arrival of SQL server 2005. it become the no 1 solution for OLAP databases(for windows server system). It is often consider that one database model can be used for OLAP and OLTP database. OLAP stands for Online Analytical Processing, this kind of database are used for a analysis services and have its own [...]
