Welcome to MSDN Blogs Sign in | Join | Help

September 2008 - Posts

Tuesday, September 30, 2008 7:54 PM

How to fix your SQL Server 2008 Setup before you run setup...

Huh? This is not meant to be a brain teaser. The purpose of this post is to help you avoid problems with SQL Server 2008 setup before you run..well setup. Why not take advantage of known fixes we have for setup to avoid the problem in the first place?
Posted by psssql | 13 Comments
Friday, September 26, 2008 2:36 PM

Welcome to SQL Server 2008 Patching

We have posted the first cumulative update for SQL Server 2008 aptly named Cumulative Update 1 (CU1). I thought before you considered installing a patch for SQL Server 2008, you would like to see a tour of what it looks like compared to SQL Server 2005
Posted by psssql | 9 Comments
Tuesday, September 23, 2008 1:24 PM

Reporting Services Windows Service will not start after applying MS08-052

We have been seeing a few cases where the Windows Service for Reporting Services will not start after applying the following fix: MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008 http://support.microsoft.com/kb/954606/
Posted by psssql | 2 Comments
Thursday, September 18, 2008 10:35 PM

How it Works: SQL Command Mode Parsing

I ran across a teaser this week that makes for a interesting blog post.  SQL Server uses a common batch parser for the SQLCMD, OSQL, SSMS Query Window in Command mode and various other locations. The primary job of this parser is to identify GO delimited
Posted by psssql | 1 Comments
Filed under: ,
Friday, September 12, 2008 9:23 PM

SQL Server (2000, 2005, 2008): Recovery/Rollback Taking Longer Than Expected

I have blogged on the various ways to determine the state of recovery but this week I was involved in an interesting discussion around rollback. The transaction has run for 14 hours and then a KILL SPID was issued. The SPID goes into rollback and happed
Posted by psssql | 3 Comments
Filed under:
Wednesday, September 10, 2008 3:38 AM

Upgrade for SQL Server 2008 can fail if you have renamed the 'sa' account

Gail Shaw, a SQL MVP, presented me with a new issue for SQL Server 2008 I had not heard of before. It was posted at the following web site: http://www.sqlservercentral.com/Forums/Topic560965-391-1.aspx This customer had renamed the 'sa' account as many
Posted by psssql | 7 Comments
Friday, September 05, 2008 6:57 PM

SQL Server 2005 Setup Fails in WOW (x86) On Computer With More Than 32 CPUs

  SCENARIO SQL Server fails to install a WOW64 instance (x86) an on a computer with more than 32 CPUs.    During setup you will encounter a SQL Server failed to start message.      SQL Server is attempting to determine the
Posted by psssql | 1 Comments
Filed under: ,
Wednesday, September 03, 2008 3:55 PM

How It Works: 17888 - All Schedulers on Node Appear Deadlocked

Error 17888: All schedulers on Node ## appear deadlocked due to a large number of worker threads waiting on <<RESOURCE>>. Process Utilization ##%. SQL Server creates a Scheduler Monitor thread for each node.    One of the Scheduler
Posted by psssql | 1 Comments
Filed under: , ,
Tuesday, September 02, 2008 8:29 PM

SQL Server 2008 Management Tools Basic vs Complete Explained....

A few questions have come up about the differences between the features you can install on SQL Server 2008 called Management Tools - Basic   and Management Tools - Complete. So I thought I'd blog about these to resolve any questions you might have.
Posted by psssql | 3 Comments
 
Page view tracker