Welcome to MSDN Blogs Sign in | Join | Help

September 2009 - Posts

Wednesday, September 30, 2009 12:57 AM

Reporting Services: What’s my version?

I was working on a case where I needed to try something on different Cumulative Updates (CU) to see what the result was in each.  Let me outline the version numbers for the Service Pack 1 release we have to date. Release Version Number SQL 2008 RTM
Posted by psssql | 0 Comments
Wednesday, September 23, 2009 9:58 PM

Did your backup program/utility leave your SQL Server running in an squirrely scenario?

My colleges asked me if 'squirrely' is a technical term and for this post the answer is yes.  CSS is not going to deny support to customers but SQL Server was not tested in this scenario so you may have chased yourself up a tree, hence I use the
Posted by psssql | 1 Comments
Tuesday, September 22, 2009 8:49 PM

If you use linked server queries, you need to read this….

If you use the linked server feature with SQL Server 2005 and 2008, please read through this carefully. We have discovered several problems that can result in memory leak(s). The conditions are a bit complicated so let me try to describe the problems,
Posted by psssql | 0 Comments
Thursday, September 17, 2009 4:16 PM

You may not see the data you expect in Extended Event Ring Buffer Targets….

Not sure how many of you have started using the new Extended Events feature of SQL Server 2008. For those who have not, there are several good resources out there already for you mostly done by the community: http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/05/27/whitepaper-using-sql-server-2008-extended-events-published.aspx
Posted by psssql | 0 Comments
Thursday, September 17, 2009 3:08 PM

How It Works: What are the RING_BUFFER_RESOURCE_MONITOR telling me?

The ring buffer records (which can be sent to XEvent) for Resource Monitor and Memory Broker are the key aspects to understanding RM.  The record is produced when a change is detected in state monitored by RM.    CREATE EVENT SESSION RingBufferInfo
Posted by psssql | 0 Comments
Friday, September 11, 2009 8:40 PM

Fun with Locked Pages, AWE, Task Manager, and the Working Set…

I realize that the topic of “locked pages’ and AWE can be confusing. I don’t blame anyone for being confused on this. I also realize we have blogged and talked about this topic many times perhaps “beating it to death”. And I certainly know this is not
Posted by psssql | 1 Comments
Filed under:
Tuesday, September 08, 2009 7:41 PM

The Future of SQL Server Express Installation and Voting with Microsoft Connect

The SQL Product team that owns setup is looking to improve the SQL Express installation experience including application developers who look to embed SQL Server Express with the install of their application. Peter Saddow is a Program Manager on this team
Posted by psssql | 0 Comments
Filed under: , ,
Thursday, September 03, 2009 4:30 PM

Another update for the Support Policy for Virtualization for SQL Server….

We now have live an update to the KB article for the Support policy for virtualization for SQL Server at: Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment I created this blog post, because there
Posted by psssql | 0 Comments
Wednesday, September 02, 2009 4:06 PM

Distributed Queries – Remote Login Permissions and Execution Plans

Recently I troubleshooted an issue where a distributed query was randomly getting a poor plan and slow performance where the join would not be remoted.  However, based on the actual data distribution and the join condition, you would expect the join
Posted by psssql | 0 Comments
 
Page view tracker