SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: June 2012

The report execution has expired or cannot be found. [rsExecutionNotFound]

I ran across the following error in SQL Reporting Services 2008 R2 a few weeks ago:

The report execution has expired or cannot be found. [rsExecutionNotFound]

This report contains a very large dataset, so my first inclination was that there was some query tuning and indexing review that needed to… Read more

10 comments, 10,237 reads

Posted in Ryan Adams on 27 June 2012

Guest Post – DBAvolution

One of my favourite things about the SQL community is the exquisite diversity of talent of it’s members. Today for the “What’s it Like To Be a DBA” post series, we’re privileged to have with us a gentleman that not only flexes his technical muscles regularly on his blog but… Read more

2 comments, 1,914 reads

Posted in John Sansom - SQL Server DBA in the UK on 27 June 2012

How Local Variable or Optimize for Unknown Resolve Parameter Sniffing

In my last post , we have gone through the parameter sniffing  and possible solutions for parameter sniffing. In the possible solutions except the local variable and Optimize For Unknown are very straight forward solution and we know how they helps us to resolve the issue.In this post we will…

Read more

6 comments, 2,898 reads

Posted in PracticalSQLDba on 27 June 2012

Down and Dark

I came back from vacation to find the home DSL line bouncing up and down a bit. I wasn’t overly worried, and the kids knew to restart the router when it went down, crossing their fingers for a good connection. I suspected the router might be dying, and was getting… Read more

0 comments, 1,503 reads

Posted in The Voice of the DBA on 26 June 2012

X-XMLA: v. Creating XMLA Script from Visual Studio and Deploy the Database

This will be the easiest entry in this series.  This is a reblog of an article I wrote last year. Simple batch script to generate XMLA and deploy SSAS DB As I was working through some issues with my cube design, I realized that I wanted to deploy my SSAS…

Read more

0 comments, 960 reads

Posted in DataOnWheels on 26 June 2012

Want to lose #20PoundsBeforeTheSummit? Join the #GetHawt competition!

We here in the IT community are clearly concerned about our weight. More specifically, we’re concerned about our weight going up and up like a growth chart for a high-transaction OTLP database. (SQL tie-in for ya, there.)

Starting to move…

We’re starting to do something about it. I know people… Read more

3 comments, 911 reads

Posted in SQL Awesomesauce on 26 June 2012

Problems with my new book

First off, I apologize. As if writing a book wasn’t hard enough, now we get new problems because of on-demand printing.

Here’s the story.

Book. Nine months of writing. Excellent technical editing. Great copy editing. Book complete about six weeks ago. Yay!

Now things get fun…

Here’s how it works.… Read more

10 comments, 793 reads

Posted in The Scary DBA on 26 June 2012

Locking Behavior – Foreign Keys

With Snapshot (read committed snapshot and snapshot isolation level) enabled, when data reading on a table takes place, if any records are being modified at the same time, the data will be read from the rows in version store rather than wait until data modification complete. Such behavior lets prgrammers… Read more

6 comments, 2,650 reads

Posted in John Huang’s Blog on 26 June 2012

A Fire Drill and Voter Registration

I avoid politics here, a discussion best done in other places, but hope you’ll enjoy some thoughts about a recent Saturday that involved voter registration.

Last Saturday I went to the library, part of a leisurely weekend afternoon. It’s nice to browse for an hour and grab a stack of… Read more

0 comments, 745 reads

Posted in SQLAndy on 26 June 2012

SQL Rally 2012 Nordic

The Nordic SQL Server event of the year is getting closer and closer. YES it is SQL Rally Nordic that I’m talking about. If you haven’t booked your ticket yet, then it is about time.

SQLRally Nordic 2012 is taking place Monday, October 1st – Wednesday, October 3rd, at the… Read more

0 comments, 810 reads

Posted in SQL Server Notes from the Field on 26 June 2012

SQLBif Gets A Job - SQLCommunity Redeemed...

 Back in May, I had a conversation with a sql friend in the community, and well, my friend (who I named SQLBif) was very dismayed with the amount of time spent on SQL Server Community, and expressed frustration that with all this community engagement, event hopping, networking and more, SQLBif was… Read more

1 comments, 1,401 reads

Posted in Pearl Knows on 26 June 2012

Preach The Gospel Always, If Necessary Use Words

I’ll be honest, I contemplated a lot about whether to write this blog or not for fear that it may come off the wrong way or just not convey the point I want, but here we are…in a hotel room typing away. In no particular order, just my thoughts as… Read more

2 comments, 217 reads

Posted in Bradley Schacht on 26 June 2012

I’m speaking at the PASS Summit 2012

The PASS Summit 2012 schedule has been released, and I’m proud to announce that I’ve been selected to present a regular session during this event.

The session that I’m presenting is:

Table Variables and Temporary Tables: What you NEED to know!

Almost all SQL developers are familiar with table variables… Read more

3 comments, 641 reads

Posted in A Discussion of SQL Server-Related Topics on 25 June 2012

SQLRally 2012 Eval Scores

I was just browsing the results of the presentations at SQLRally 2012. I ended up with a evaluation average of 1.13 (on a scale of 1 to 5, with 1 being good) for the one I did on professional development. To put that in perspective the highest rating for a… Read more

0 comments, 610 reads

Posted in SQLAndy on 25 June 2012

It’s that time of year…..Exceptional DBA Awards 2012

Being a 2011 finalist I felt I should try and rally all those who truly are exceptional to get their nominations in and quick sharp as the closing date is getting close.

I was lucky enough to be nominated for this award last year and wasn’t going to follow it… Read more

1 comments, 739 reads

Posted in Chris's SQL Blog on 25 June 2012

Killing me softly with Service Broker…

A few days ago, I found a very interesting behavior regarding Service Broker on a customer system. The main thing is that your activation stored procedure is not allowed to block for a very long time, otherwise you will impact the health of your whole SQL Server instance. In this… Read more

2 comments, 3,372 reads

Posted in Klaus Aschenbrenner on 25 June 2012

And the results are in…..SQL Server 2012 beta exams

Well after being a bit late in trying to book the beta exams I managed to get three of the five I needed for the MCSE data platform booked, taken and I’m pleased to say passed!

Unfortunately due to the fact I did 461, 462 and 465 means I don’t… Read more

6 comments, 895 reads

Posted in Chris's SQL Blog on 25 June 2012

Unable to activate a Windows 2003 VM on Hyper-V behind a proxy

Ok, so this is not strictly a post about SQL itself (and it's about a fairly old OS), but I did run into this problem myself a couple of weeks ago whilst creating a very specific build to test some functionality and seeing as it took me a little bit… Read more

0 comments, 2,428 reads

Posted in SQL Server Rocks! on 25 June 2012

Review the New Migration Guide to SQL Server 2012 Always On

I had the pleasure of meeting Mr. Cephas Lin, of Microsoft, last year at the SQL Saturday in Indianapolis and then later at the PASS Summit in the fall.

Cephas has been writing content for SQL Server 2012 Always On. Cephas has recently published his first whitepaper, a migration guide… Read more

0 comments, 875 reads

Posted in Kevin E. Kline on 25 June 2012

How to use a multidimensional cube with Power View

The requirements for Power View state that it can only use tabular models as data sources.  So if you want to use Power View against a multidimensional cube, you are stuck.  But there is a work-around:

Create a PowerPivot for SharePoint workbook that is using a SSAS multidimensional cube as… Read more

0 comments, 2,245 reads

Posted in James Serra's Blog on 25 June 2012

Newer posts

Older posts