In the Microsoft SQL Server 2000 Resource Kit, I read about a procedure that checks all databases for options that you should avoid. I understand why I should avoid options such as offline, DBO-use only, statistics off, truncate log on checkpoint...
In his keynote address at Comdex earlier this week, Bill Gates announced that a Unisys 32-way ES7000 server running Windows Datacenter Server Limited Edition and SQL Server 2000 Enterprise Edition set a new record for Windows performance on the...
A few months ago, I discussed the pending release of a new Microsoft business intelligence (BI) tool called Data Analyzer, which the company officially launched on November 1. I'd like to revisit Data Analyzer and focus on its features and—more...
Configuring IIS and SQL Server 2000 to use Windows logon information is easy...
table.downloadBox {
width: 100%;
border: solid 1px #666;
border-collapse: collapse;
}
table.downloadBox th {
background: #276C9F;
padding: 3px;
color: #fff;
font-size: 14px;
text-align: center;
}
...
From time to time, I've discussed the problem of drowning in a sea of information. Reading and digesting all the technical content that interests you and is readily available on the Web or in print is impossible. So, where do you start? Sometimes...
Microsoft has posted a new article that details a SQL Server 2000 Service Pack 1 (SP1) bug. The article explains that executing a SELECT statement that has a nested query on a table that contains a computed column might generate the following...