Solved

Analytic functions in SBS 2005 R2

Posted on 2008-10-05
2
264 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
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

In the event you manage a Small Business Server 2003, and you are audited for PCI compliance, there are several changes you must make in order to pass the audit. I can take no credit for discovering any of these fixes or workarounds, but there is no…
This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Small Business Server 2011. NOTE: This guide has been written using the preview version of SBS2011 therefore some of the screens may …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

706 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now