What is the service account your using when installing SSRS? is it network service or your local account?

create table #t1

( id int identity(1,1) ,

city varchar(128)

)

create table #t2

( id int identity(1,1),

city varchar(128)

)

insert into #t1

select 'Dubai'

union all

select 'Delhi'

union all

select 'Denver'

insert into #t2

select...

Youtube AlwaysOnhow to I had created a 3 part video on always on, or even better you can go to microsoft virtual labs

http://www.youtube.com/watch?v=BQSEjAHGCe4

try this , btw you will need to...

Try running the setup file as admin, right click and run as administrator. Or you can try disabling UAC in the control panel.

High thread counts aren't an issues usually and just reflects the load on the server , e.g parrallelism/ large number of users etc but when you have a large number...

http://www.microsoft.com/en-in/download/details.aspx?id=42299

once you clikc download you get the list of installers.

You pobably want

MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe

If the same query is run as a group by command instead of Select Distinct does it complete?

How many rows are you expecting as the output from the total? have...

It could be a number of things , like John mentioned the most likely issue is user queries. However you need to monitor non user related operations as well. ...

http://www.brentozar.com/archive/2011/09/sysadmins-guide-microsoft-sql-server-memory/

More RAM is better this way SQL doesnt need to write to disk. MS has been spending a lot of time trying to put as much data in RAM in...

You could put in a work around that might work out better for SSRS but not so great for your query.

Simply pivot the columns that are variable and make them...

I am wondering on the benefit of adding a clustered index to make sure data is sequential and then using a NonClustered index for all the queries. Since you mentioned...

Synchronizing means that records are being moved around and havent been hardend in the log. This would result in recovery of the databases since redo undo phase is applicable.

Typically...

The steps seen about right , I cant remember if a windows shutdown cleanly shutsdown SQL Server Services but i guess it should. Do you remember if the status of...

My two cents , start with your biggest tables , 400GB databases usually have just a few tables that contribute to the bulk of the issues.

Try partitioning large tables...

You will have only one entry in the DNS per listener. If the listener is not added automatically to the DNS it is usually a permissions issue. Also Listeners need...