Viewing 15 posts - 31 through 45 (of 314 total)
What version of SSRS are you running? Are you returning any sort of TEXT or large BINARY fields?
Does the report only run the one query (procedure)?
March 21, 2011 at 4:53 am
Are you talking about physical CPUs or cores on a CPU?
From the above I would be getting as much memory as possible and reducing the cores/CPU as well.
March 17, 2011 at 4:26 am
Not sure if this helps
March 16, 2011 at 5:12 am
You will need to either put "breaks" into the stored procedure or run the statements separately.
March 16, 2011 at 4:59 am
My previous company was in the process of building and testing some new servers for Risk Analysis (Insurance market) and they were 128GB RAM and either 4x 8 core or...
March 11, 2011 at 4:17 am
Virtual machines can be part of a DR plan,...
March 8, 2011 at 6:44 am
If performance is "sluggish" thread topic... you would need to provide a bit more detail about how the SQL server DBs are spread across the drives, what else is running...
March 3, 2011 at 7:54 am
March 2, 2011 at 9:10 am
Do you change all the ports on your SQL Server installs or do you leave them as standard (1433, 1434)?
March 2, 2011 at 8:53 am
This statement in CMD will give you the state of all services:
sc query state= all
You will just need to strip the info you need out... I have a procedure that...
March 2, 2011 at 8:46 am
Koen Verbeeck (3/2/2011)
Jeff Moden (3/2/2011)
DECLARE @SplitString VARCHAR(100)
SELECT @SplitString = 'bas-06-12586'
March 2, 2011 at 7:41 am
I could deduce the correct answer since I ran the query on my development machine.
Not all results were zero and the columns aren't nullable, so there...
March 2, 2011 at 2:54 am
Did not think you could link to a 2008 server from 2005, but must admit, I have not tried.
Will wait for others to answer...
It help if you explain...
March 1, 2011 at 8:11 am
Well then I will wait for someone to come up with some new ideas, as everything you have said points to an authentication issue of some sorts.
March 1, 2011 at 5:20 am
Kari Suresh (3/1/2011)[p]I just run now and got the same error. When I tried using SSRS url the report worked properly.[/p]
Kari Suresh (3/1/2011)
That sounds like a Kerberos (or other) authentication issue. If...
March 1, 2011 at 3:45 am