Useful partition script

Retrieve filegroup by table name and partition range The following script can be used to retrieve the filegroup name for a given table and a partition range.  It can be very useful in an automated sliding window process. declare @tablename nvarchar(128) declare @range sql_variant   set @tablename = ‚myPartitionedTable‘ set @range = 1209   declare…

2

Accessing MS Reporting Services with Java

In this article I describe how to access Microsoft Reporting Services Web Service interface with a Java web service client. Microsoft Reporting Services MS Reporting Services (MSRS) provides its full functionality via two Web services endpoints. The WSDL for the endpoints are accessed using the following URL’s: http://<Server Name>/ReportServer/ReportService2005.asmx?wsdlhttp://<Server Name>/ReportServer/ReportExecution2005.asmx?wsdl The first on is the…