Welcome to MSDN Blogs Sign in | Join | Help

June 2006 - Posts

Working with TempDb in SQL 2005

Posted Thursday, June 29, 2006 7:13 PM by Sanchan
Just a quick note, Microsoft has published a great whitepaper on TempDB. You can download it here: http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/WorkingWithTempDB.doc I will add more blog content about TempDb soon. Read More...
0 Comments

SETUP – Installing Analysis Services 2005 on a cluster

Posted Wednesday, June 14, 2006 12:25 AM by Sanchan
I have received a lot of questions on installing Analysis Services 2005 on a cluster and I wanted to write this blog to answer those questions using specific scenarios. Scenarios - You create a new Windows Cluster and decide to install ALL components Read More...
2 Comments

SETUP - SQL 2005 and domain groups best practices

Posted Wednesday, June 14, 2006 12:07 AM by Sanchan
Unlike SQL 2000, SQL 2005 setup on a cluster now requires you to provide domain groups for each clustered service – like SQL Database Engine, SQL Agent, FTS, Analysis Services. Many customers have asked me interesting questions about domain groups and Read More...
2 Comments

Add/Remove Program and SQL 2005

Posted Tuesday, June 13, 2006 11:21 PM by Sanchan
When you install SQL Server 2005, depending upon the components you installed, you will see a couple of entries in the Add/Remove programs related to SQL Server 2005. The most important one is Microsoft SQL Server 2005. This entry provides you with a Read More...
4 Comments

SQL Server 2005 and compressed drives - what you should know?

Posted Sunday, June 04, 2006 11:08 PM by Sanchan
You will be surprised to know how many times this topic comes up during discussions with SQL Server DBAs. I guess the reason for confusion or discussion primarily emanates from the fact that the documentation on this topic hasn’t been that detailed. So Read More...
5 Comments

SQL Error Messages – I/O Related

Posted Saturday, June 03, 2006 9:04 AM by Sanchan
You may see the following error message in SQL Server 2005 Error logs or event logs: SQL Server has encountered %d occurrence(s) of I/O requests taking longer than %d seconds to complete on file [%ls] in database [%ls] (%d). The OS file handle is 0x%p. Read More...
4 Comments
 
Page view tracker