Check the Target Server version in the properties of the project. It should be set to SQL Server 2012. If you created a new project using Data Tools 2015 it...

We use TFS in work and took the decision that all check outs should take an exclusive lock. We have worked around this by ensuring communication among team members and...

Is there a question here?

The red dot is i guess a pie chart, the icon is meant...

Are you looking to know how to configure SSRS? If so use the SQL Server 2014 Reporting Services Configuration manager. It will be under SQL server 2014 in the Programs/apps...

The expression below will do that.

=Year(Now()) & Right("00" & Month(Now()),2)

Here is a way you can test.

CREATE TABLE dbo.Test (

Val INT NOT NULL

, sdate DATETIME NULL

...

replace the http://xxxxxxxxxx/Pages/Report.aspx?ItemPath=%2f in your url with

http://xxxxxxxxxx/ReportServer/Pages/ReportViewer.aspx?/

Yes you can. I'd much rather use stored procedures though.

First thing to do is check out the wait stats. Paul Randal has a great query you can use to gather this information - see link below. The article will...

I think you want to look at rollups. Check this out for a very quick example.

There is a lot of information at the link below

https://technet.microsoft.com/en-us/library/bb522495(v=sql.105).aspx

CREATE TABLE #Orders (

...

I'm confused with how your data/report is laid out but have you tried enabling Page Breaks on the grouping and then adding an expression to the Page Break Disabled property...

You haven't provided enough information to help. How are you determining the number of rows in the oracle table? What process are you using to move rows. Does the destination...

I'm assuming they have individual schedules? If they use shared schedules then you can update them from Management Studio.

The query at the end will output the Report name, SSRS...