Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL 2005   (RSS)
Friday, November 20, 2009 7:04 PM

SQL Server 2005 Cumulative Update or GDR fails when trying to rename the mssqlsystemresource files

I’ve seen a few customers run in to this recently when the resource database is in a different location than the master database.  A cumulate update or GDR for SQL Server 2005 may fail with the following for the SQL Server Database Services 2005
Posted by psssql | 1 Comments
Friday, November 13, 2009 5:02 PM

How It Works: How many databases can be backed up simultaneously?

Previously I have posted details on backup/restore designs and how to tell what backup/restore is doing. http://blogs.msdn.com/psssql/archive/2009/03/03/how-it-works-sql-server-vdi-vss-backup-resources.aspx http://blogs.msdn.com/psssql/archive/2008/01/28/how-it-works-sql-server-backup-buffer-exchange-a-vdi-focus.aspx
Posted by psssql | 0 Comments
Filed under: , , ,
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 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, 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
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
Thursday, May 07, 2009 3:08 PM

SSIS 2005 and the .NET Garbage Collector

I was troubleshooting an SSIS Out of Memory issue the other day which led us into how the .NET Garbage Collector (GC) works.  When debugging it, I found that we were using the Workstation GC with Concurrent GC On (this is the default for .NET applications). 
Posted by psssql | 1 Comments
 
Page view tracker