Browse by Tags

All Tags » SQL Server 2008 R2 (RSS)
06 June 2011
Failing report subscriptions
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 saying that the email address of one of the recipients... Read More...
no comments
Filed under: ,
22 March 2011
Transaction log growth in the model database
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 server the model database transaction log was... Read More...
2 comment(s)
Filed under: ,
12 November 2010
Intellisense: the ghost in the machine
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 by a space - why did you change it to something... Read More...
no comments
Filed under: ,
09 September 2010
How to re-order report parameters
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 of dialogue that lists them (where you might be able... Read More...
no comments
Filed under: , ,
14 July 2010
Be careful with table variables
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,000 rows of about 1,100 bytes each in the table variable... Read More...
8 comment(s)
Filed under: ,
02 July 2010
R2 Report Pagination
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. Now it produces page 1 of 2 that is miles long and... Read More...
no comments
Filed under: ,
02 July 2010
R2 Collation Gotcha
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 and I've only just noticed, which... Read More...
no comments
Filed under: ,
15 June 2010
Upgrade to 2008 R2
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 log shipping standby for the duration, which has a... Read More...
no comments
Filed under: , ,
11 June 2010
Upgrading log shipping from 2005 to 2008 or 2008R2
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 keeping your secondary databases in STANDBY... Read More...
no comments
Filed under: , , ,
28 May 2010
Upgrading from 2005 to R2
We're about to take the plunge and upgrade our servers from SQL 2005 to SQL 2008 R2. Real world accounts of people upgrading to R2 are a bit hard to find so I thought it might be useful to blog what happens. (I don't count marketing 'case studies' that just say stuff like "The process... Read More...
no comments
Filed under: , ,