Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2008   (RSS)
Tuesday, November 17, 2009 9:35 PM

How It Works: Controlling SQL Server memory dumps

I just completed a lengthy bit of research and thought I would share it with everyone.   There are several trace flags and registry keys outlined in this post.    !!! As always USE WITH APPROPRIATE CAUTION !!!   From: Robert
Posted by psssql | 0 Comments
Tuesday, November 03, 2009 5:56 AM

The SQL Server Wait Type Repository…

As part of my talk at the 2009 US PASS Summit here in Seattle called Inside SQL Server Wait Types , I’m creating this blog post as a reference point that can be used to find out information about wait types in SQL Server 2005 and 2008.  My hope is
Posted by psssql | 3 Comments
Monday, October 26, 2009 5:35 PM

Reduce locking and other needs when updating data - Better Performance

The following pattern typically stems from an old practice used in SQL 4.x and 6.x days, before IDENTITY was introduced. begin tran declare @iVal int select @iVal = iVal from CounterTable (HOLDLOCK) where CounterName = 'CaseNumber' update CounterTable
Posted by psssql | 0 Comments
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
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
Tuesday, August 18, 2009 5:30 PM

SQL Server Cumulative Update or Service Pack Fails With - CREATE DATABASE failed

Here is a situation where a cumulative update patch can fail if the default database path for the data and/or log either does not exist, or there is a permissions issue.  This example is based on a SQL Server 2005 Cumulative Update 4 for SP3. 
Posted by psssql | 0 Comments
Wednesday, July 01, 2009 10:12 PM

When in doubt, Reboot!

I tend to get quite a bit of Kerberos related cases.  These are related across the box, from the Engine, to Reporting Services to just straight connectivity with custom applications.  I had one given to me yesterday because the engineer had
Posted by psssql | 0 Comments
Thursday, June 18, 2009 4:59 PM

Zero Byte Attachments in Email Subscriptions

I had an issue a while back with RS 2000 where we would get a Zero Byte attachment when hitting a Lotus Notes server.  This ended up being corrected in KB 872774 . So, when I was assigned a case with a similar description, but this time with RS 2005
Posted by psssql | 0 Comments
Tuesday, May 19, 2009 2:43 PM

An update for Standard SKU Support for Locked Pages….

Note this article has been updated to include an update for SQL Server 2005 I posted in April that we would be releasing cumulative updates for SQL Server 2008 and 2005 to support the concept of Locked Pages for SQL Server Standard. SQL Server 2008 Cumulative
Posted by psssql | 3 Comments
Tuesday, May 19, 2009 5:35 AM

SQL Server Support Policy for Failover Clustering and Virtualization gets an update…

Last October I posted on our updated policy for support of SQL Server in a virtualization environment. This policy is based on a KB article that summarizes our policy. You recall this article is the following: Support policy for Microsoft SQL Server products
Posted by psssql | 6 Comments
Friday, May 01, 2009 10:31 PM

SQL, Powershell, Windows, Oh My!

I was in the process of setting up a repro for another Blog I’m going to be posting and ran into an unexpected situation.  My VM was running Windows 2003 and I had installed SQL 2008.  I was then going to upgrade to Windows 2008 Server and came
Posted by psssql | 1 Comments
Thursday, April 30, 2009 4:44 PM

Why Should I Use Extended Events in SQL Server 2008?…

You may or may not have heard of a new diagnostic technology in SQL Server 2008 called Extended Events (XEvent). I thought I would post an example of why this technology can do things nothing else we have can when you deploy SQL Server 2008. Someone internally
Posted by psssql | 2 Comments
Friday, April 24, 2009 12:14 PM

SQL Server, Locked Pages, and Standard SKU…

I made an announcement today while speaking at Europe PASS 2009 that we will be providing a method for customers using standard SKU for SQL Server 2005 and 2008 to use the ‘Locked Pages in Memory’ privilege to allow the server to use the AWE APIs. This
Posted by psssql | 10 Comments
Tuesday, April 07, 2009 8:16 PM

Troubleshooting sp_xp_cmdshell_proxy_account Errors

I was attempting to establish the command shell proxy on my local machine and ran into a series of errors.   As I looked at them more I decided to file some work items with the SQL dev team to provide better context in the message text.  
Posted by psssql | 1 Comments
More Posts Next page »
 
Page view tracker