Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Best Practi... » SQL Tips and Tricks   (RSS)

Installing SQL 2005 and SQL 2000 on the same box - what you should know?

Posted Friday, August 18, 2006 5:39 PM by Sanchan
Many customers have asked me if they can install SQL 2000 and SQL 2005 on the same box, side by side. The answer to this is YES. You can install SQL 2000, SQL 7.0 and SQL 2005 on the same box. However, there are certain special considerations that you Read More...
2 Comments

FAQs - SQL Server and Disk Subsystem requirements

Posted Friday, July 07, 2006 2:20 PM by Sanchan
This is the first installment in my FAQ series. In this blog entry, I have consolidated all the questions that I have received from my readers about available disk subsystems in the market and their compatibility with SQL Server. I have tried to address Read More...
1 Comments

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 - 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
 
Page view tracker