Browse by Tags
All Tags »
SQL Server 2008 R2 (
RSS)
Nearly three years ago I wrote about how to query the ReportServer database and see who is running which reports . Since then I've made it a bit more focused. Which reports are being used the most? Which users are the busiest and which reports are...
We had an interesting problem while I was on holiday. (Why doesn't this stuff ever happen when I'm there?) The sysadmin upgraded our Exchange server to Exchange 2010 and everone's subscriptions stopped. My Subscriptions showed an error message...
I had an odd one yesterday. I was sorting out internal fragmentation in our transaction logs (see Kim Tripp's blog http://www.sqlskills.com/BLOGS/KIMBERLY/post/8-Steps-to-better-Transaction-Log-throughput.aspx ) and I noticed that on our core production...
Intellisense really does have a mind of its own. I installed SQL 2008 R2 on my dev machine side by side with my existing 2005 installation and Intellisense worked fine. Granted it has some really annoying habits. (Dude, I typed a valid keyword followed...
I added a parameter to a report today, which put it the end of the list the user fills in before running the report. I wanted to move it higher up the list but they are presented in a tree structure. You can edit each parameter but there's no sign...
I just looked into a poorly performing stored procedure and brought it down from over 4 minutes to under 4 seconds by making one simple change: converting a table variable into a temporary table. What's interesting is that there were only about 20...
I thought it was all too good to be true. We upgraded our reporting server in place from 2005 Std to 2008 R2 and we've hit a major problem. We have a few reports that are about 60 pages. On 2005 the report would render page 1 of 60 pretty quickly...
On my dev machine I installed R2 alongside my existing 2005 instance and it did a funny thing with the new instance's collation. Our servers are all on Latin1_General_CI_AS, including my 2005 dev instance. But my R2 instance defaulted to SQL_Latin1_General_CI_AS...
I don't like it, Carruthers. It's just too quiet. Well, I've done the pre-production server, the main live server and the Reporting/BI server with remarkably little trouble. Pre-production and live were rebuilds. I failed live over to our...
If you're using log shipping you need to be aware of some small print. The general idea is to upgrade the secondary server first and then the primary server because you can continue to log ship from 2005 to 2008R2. But this won't work if you're...