Microsoft has announced that SQL Server 2008 R2 will be available by May 2010. Its CTP (Community Technology Preview) version was already available from August 2009. It is still available for download.
This new release offers many benefits over the previous versions. Also, the pricing has not been revealed thus far.
What’s new?
Master Data Services: This technology deals, with the secure and direct management of master data, ensuring its integrity.
StreamInsight Technology: This technology deals, with complex, high-scale event processing.
Benefits
This technology has helped the IT departments of many prominent industries to effectively manage and monitor information centrally. Some of the major highlights of this technology are as follows: the central management of information, including databases; and support for virtualization and Live Migration. It also supports the effective deployment and development of applications.
I am personally excited that SQL Server 2008 R2 is about to release very soon.
Let me know which version of SQL Server are you using in your business. I am very sure many of you are still using an older version of SQL Server, which is no longer the best choice. Please leave a comment in the comment section of this blog.
Reference: Pinal Dave (https://blog.sqlauthority.com)
9 Comments. Leave new
Hi pinal
i have created the table valued function Getreport with parameter @Deliverdate
i have also created SP GetReportDetails with various columns in select list and selecting the Table valued function in subquery as follows
SELECT FacilityId,Name,Address1,
(select * from dbo.GetPrizeForCubist(@EndDate))as ‘Prize’
IT returns the error as
(95 row(s) affected)
(101 row(s) affected)
(65 row(s) affected)
Msg 116, Level 16, State 1, Line 53
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
i dont have enough knowledge with this error.
provide me the solution
Thankx:)
Hi Senjay,
It seems like you are trying to get two result sets in one query. The result from the table valued function probably has to be inserted into a table, then join that table to the query containing select facility.
You could possibly post the complete query…then we can check it out.
Change * in the subquery to the single column name wanted from that table/function.
small mistake i have made
(select * from dbo.GetPrizeForCubist(@EndDate))as ‘Prize
not the function name and the function is
(select * from dbo.Getreport(@EndDate))as ‘Prize
Here is an article about some of the new features included in the R2: .
Also, here is a page on Microsoft with some pricing details for the R2: https://www.microsoft.com/en-us/sql-server/sql-server-2016
The Streaminsight technology looka very interesting, read an article on sqlservercentral about it. It looks at real time business intelligence and working with continous stream of input data.
hai
i have a table named products.
it has date,price and description as columns.
i want to retrieve the values within specified date range and if not previous date
example
if i give the year as 2009
if not in table it should return 2008 or 2007 or some previous year value for different description and different price as in table
Thankx:)
@senjay
If it isn’t in the TABLE, where is it coming from?
Please provide some sample data and a sample result.
Pinal,
There is one BIG point to watch out for with 2008 R2, which just caught us by surprise. It’s not documented anywhere that I can find. Only in blogs and forums where people have hit this trap.
We have production and test servers running SQL 2008. We do not have “Software Assurance.”
We downloaded and installed SQL 2008 R2 on our development computers.
We developed new databases, then tried to copy and attach the files to a test server. We got this nice message:
“The database ‘dbName’ cannot be opened because it is version yyy. This server supports version xxx and earlier. A downgrade path is not supported.”
So everybody watch out!
Database files from “2008 R2” are NOT compatible with “2008.” They changed the file structure, and thus the “database version.”
If you have paid extra for “Software Assurance,” then you can get a “free” upgrade for your 2008 servers. Basically, though, you can’t upgrade to R2 unless you send money to Microsoft one way or another.
Microsoft SHOULD HAVE released R2 as “SQL 2010” and version 11.x. But they did not, even though this is a major breaking change.