Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
I have a table that holds about 60 million rows. The primary key is an integer column that I maintain by using a NextID table. Because no columns in the table are subject to a range search, I chose a clustered index to maximize the performance of...
Editor's Note: Send your SQL Server questions to Richard Waymire, Microsoft's group program manager for SQL Server management tools, at [email protected]...
With the imminent release of Windows .NET Server, we'll soon see deployment of applications built on the Microsoft .NET Framework. For DBAs and developers, the .NET Framework ushers in the next generation of Microsoft's data-access technology: ADO...
My company's two offices, one in Arizona and the other in Nebraska, are connected by DSL. They both have SQL Server 2000 running on Windows 2000 Server, and the Nebraska database is replicated to the Arizona server. We need to add a couple of...