Since I installed the SQL Server 2000 tools on my PC, I've had problems using Query Analyzer to log in to my SQL Server 2000, 7.0, and 6.5 servers. Establishing a connection takes a long time, and in most cases, several tries. I frequently receive...
Editor's Note: Send your SQL Server questions to Richard Waymire, Microsoft's group program manager for SQL Server management tools, at questions@sqlmag.com...
Microsoft hasn't done a very good job of helping customers use its products and technologyeffectively, but it's not for lack of trying. The company spends immense amounts of money and timeproviding an overwhelming amount of information that's...
Before you install Microsoft SQL Server 7.0, you should already have installed Windows 2000 Server, Win2K Advanced Server, or Windows NT Server 4.0 with Service Pack 4 (SP4) or later, as well as Microsoft Internet Explorer (IE) 4.0 SP1 or later...
For me, seeing is believing when it comes to SQL Server performance issues. During the past few years, I've tried a lot of tips that have yielded amazing results, whereas other tips have offered barely a whisper of performance gains in real-world...
Congratulations to Ken Haley, development manager at SPECTRUM Human Resource Systems in Denver, Colorado, and Ewen Stewart, Software Architect at Active Media Australia in Melbourne. Ken won first prize of $100 for the best solution to the August...