Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » sql server   (RSS)
Tuesday, December 22, 2009 6:00 PM

How and Why to Enable Instant File Initialization

See my new blog post (written with Denzil Ribeiro) about " How and Why to Enable Instant File Initialization " on our PFE blog . Keep an eye on the PFE blog for more posts from my team in the near future.
Posted by CindyGross | 0 Comments
Monday, December 21, 2009 4:52 PM

Latest SQL Server 2005 Cumulative Updates - SP2 based CU17, SP3 based CU7

There are two new cumulative updates (CUs) available for SQL Server 2005 as of today. · SQL Server 2005 SP2 based CU17 ( 9.00.3356) . This is the last SP2 based CU as SP2 will no longer be supported after 1/12/2010 . KB = Cumulative update package 17
Posted by CindyGross | 0 Comments
Wednesday, December 16, 2009 12:01 PM

SQL Server's Default Trace

Are you familiar with SQL Server's default trace setting? It can be helpful with finding basic who/when type information on major events. For example, you may want to know who was creating and dropping databases on a given instance. SQL Server has a couple
Posted by CindyGross | 0 Comments
Filed under: , , ,
Wednesday, December 02, 2009 9:33 AM

Backing up a corrupted SQL Server database

I had a question about how to do a backup and skip a corrupted block of data. First, DO NOT DO IT unless you absolutely have to, such as when you are taking a backup prior to trying to fix the corruption (which means you should be on the phone with Microsoft
Posted by CindyGross | 0 Comments
Friday, November 20, 2009 10:07 AM

Compilation of SQL Server TempDB IO Best Practices

It is important to optimize TempDB for good performance. In particular, I am focusing on how to allocate files. TempDB is a unique database in several ways. The ones most relevant to this discussion are: · It is often one of the busiest databases on an
Posted by CindyGross | 2 Comments
Friday, November 20, 2009 9:58 AM

SQL Server and Fragmentation

There are several types of fragmentation that affect SQL Server, all of which have the potential to cause performance problems. 1) At the disk/OS level individual files can become fragmented due to growth over time. This can be addressed by a defragmentation
Posted by CindyGross | 0 Comments
Friday, November 20, 2009 9:55 AM

SQL Server 2008 setup may report a Windows 2008 cluster validation failure

You may receive the error "The cluster either has not been verified or there are errors or failures in the verification report" while installing a SQL Server clustered installation on Windows 2008. When see this error you must fix the underlying error
Posted by CindyGross | 0 Comments
Thursday, October 29, 2009 9:38 PM

How to use PsGetSid for SQL Server

To translate a SID to a name or vice versa, you can use this tool from sysinternals: PsGetSid v1.43 http://technet.microsoft.com/en-us/sysinternals/bb897417.aspx You can use it to translate the SID in these registry keys into the SQL Domain Groups or
Posted by CindyGross | 0 Comments
Filed under:
Wednesday, May 27, 2009 11:37 AM

What to know before you choose a SQL Server Disaster Recovery and/or High Availability solution

Why disaster recovery planning matters: · Do you know what your plans are to recover from various data losses? Have you ever tested those plans? Can they be implemented within your Service Level Agreements (SLA)? Are you confident your plans cover the
Posted by CindyGross | 2 Comments
Filed under:
Monday, May 18, 2009 11:27 PM

SQL Server 2005/2008 Now Supports Guest Clustering in a Virtual Machine!

Technorati Tags: SQL Server , virtualization Guest clustering in a Virtual Machine for SQL Server has been a hotly requested feature for quite some time, and as of today it is officially supported! See the below links from Bob Ward for the exact details.
Posted by CindyGross | 2 Comments
 
Page view tracker