Well... you know... It Depends...

calories/line of code = ((proc load increase) + (io/sec)) * number of table scans

...

temp in the server room was a bit too low, using the extra CPU cycles to heat the place up?

For me it depends upon the complexity of the backup system. I have machines using maint plans because they're easy and then I have other ones where a customized...

That part of it yes. apparently there were some issues when using images from the northwind db. It went into greater detail on those...

Glad you got it sorted.

-Luke.

have a look at the following and see if it clears things up for you.

http://kiavashshakibaee.blogspot.com/2008/07/display-database-image-in-ssrs-from.html

-Luke.

Also, I know you said you are not taking t-log backups, but if you are using differentials, the BE software may cause some issues with the log chain... Just...

Roy Ernest (11/3/2009)

---

There were couple of threads regarding this topic and the almost everyone thought that it was not a great idea since as a DBA you do no have...

Are your storing every date in the year or just start and end dates for Fiscal months and such?

I ask because the Datediff week calculation will not work correctly...

You may...

I'm gonna guess seconds, though I'm not sure what time segment is stored in that column. I'd imagine that if a report took 29 minutes...

yup, that would do it, if it was in full recovery mode. Everything would have been logged which would have made your transaction log huge. That's the difference...

-Luke.

I also get 0's where you do and TimeProcessing above 0, but I only have a small sampling of processingaborted statuses... The max Timeprocessing was 29 for me.

-Luke.

Did a bit more googling than I had when this originally came up in my office...

Here's the MS reasoning why you might be seeing the timeouts...

http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx

Basically, the session times out...

In addition, when I was seeing this issue, I checked a trace on the database server and the query was completing very quickly, just taking forever to get the results...

Had a similar issue once with SSRS. I never had the report time out, but it took quite a while to run and compile as I was pulling many...

Krasavita (11/2/2009)

---

I moved data from one server to another server, this is the same db and they look identical,but db is much bigger then another. How can I check what...