Some of my queries behave differently in SQL Server 2000 than in 7.0, and the SQL Server 7.0 behavior seems to be wrong. For example, in SQL Server 7.0, the query...
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;
}
...
Extend the example in this month's article to populate an ALL OTHER BRAND member that's a sibling to each group of brands in the Product dimension. This month's column shows how to sum all the suppressed values into one ALL OTHER BRAND level by...
The SQL Server .NET data provider that's included in Visual Studio .NET introduces fundamental changes to the data-access mechanisms that you're accustomed to in OLE DB and ADO. The best place to begin learning about these changes is probably in...
If you try to comment out the GO keyword inside a batch run, you might not get the results you expect. For example, imagine that the following batch is part of a larger script and you need to comment it out during a testing phase...
How does Microsoft recommend defragmenting SQL Server data files at the OS file-system level? Do I need to add data-file defragmentation to my regular database maintenance, or does SQL Server avoid file fragmentation by reserving contiguous data...