Solved

Analytic functions in SBS 2005 R2

Posted on 2008-10-05
2
285 Views
Last Modified: 2010-04-21
What are the new "Analytic Functions" that are available in SQL Server for SBS Premium R2?

Why are they important for SBS when you consider that Premium edition does not actually have Analysis Services?



It's the last row of the table here ....

http://www.microsoft.com/WindowsServer2003/sbs/evaluation/faq/sql2005.mspx
0
Comment
Question by:craigdev
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
Eidron1980 earned 500 total points
ID: 22644126
Analytic Functions are special functions used in SQL to enhance your queries.
Example of Analytic Functions are: ROW_NUMBER, NTILE, OVER etc..

Se more here: http://main.xfusiondn.com/Contributions/PT11100601.aspx
0
 
LVL 1

Author Closing Comment

by:craigdev
ID: 31503161
awesome, thanks
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Glen Knight (demazter) as part of a series of how-to articles. Introduction One of the biggest consumers of disk space with Small Business Server 2008(SBS) is Windows Server Update Services, more affectionately known as WSUS. For t…
The SBS 2011 release date (RTM) is supposed to be around Christmas, 2011.  This article is a compilation of my notes -- things I have learned first hand.  The items are in a rather random order, but I think this list covers most of what is new and d…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question