Viewing 15 posts - 2,236 through 2,250 (of 18,926 total)
Gianluca Sartori (10/1/2011)
Evil Kraig F (10/1/2011)
Lynn Pettis (9/30/2011)
Need Software with following modules and features...
... an entire software suite from the land...
October 1, 2011 at 7:50 am
Not that it matters now, but what would happen if you'd pin a table that has 10 GB of data with only 8GB on the box?
That seems like a good...
September 29, 2011 at 2:50 pm
Pravasis S (9/29/2011)
September 29, 2011 at 5:41 am
MidBar (9/29/2011)
They appears as sheet1, sheet2,sheet3.....
But with one individual report and export it actualy gives...
September 29, 2011 at 5:40 am
Can you post a screenshot of each (without login / password info).
September 28, 2011 at 6:45 pm
Thanks for the feedback.
As always SOMETHING changed :-D.
September 28, 2011 at 6:42 pm
This is simple detective work. See what SSRS is REALLY sending over to sql server and match the where accordingly.
I'm sure you can handle it from there!
September 28, 2011 at 2:29 pm
Grant Fritchey (9/28/2011)
September 28, 2011 at 7:11 am
P.S. NEVER use autoclose or autoshrink on the busy db!
The simple-talk article will definitely help if the problem really comes from the server.
September 28, 2011 at 7:04 am
Every other operations on that table.
This implies a much more complicated setup unless you have some unit tests ready.
September 28, 2011 at 7:03 am
I have a similar setup here.
What I do is use the ALL_ERRORMSGS & NO_INFOMSGS switches that way I get data back only when there's corruption.
Also if you do really have...
September 28, 2011 at 6:54 am
That solition can be found in a single query.
Use inner join to match the rows between the tables.
Sum to get the total sales
Group by to (you'll see)
order by DESC...
September 28, 2011 at 6:51 am
Profiler might actually help.
You could search for long running transaction.
You can also filter based on the rowcounts column. Look for something freakishly out of the normal range....
September 28, 2011 at 6:49 am
Google brent ozar blitz.
That'll give you a script along with a 2.5 horus video that explains how to use it.
Of course this only begins to scracth the surface of what...
September 27, 2011 at 7:53 pm
Viewing 15 posts - 2,236 through 2,250 (of 18,926 total)