Imagine that you’re in a retail business that sells products with a variety of options. For example, you’re in the golf-club business, and your customers can order clubs that have different shafts (e.g., steel, graphite, or titanium) and different...
In "Analyze Disk Utilization," August 2001, I introduced an analysis application that lets you explore the contents of your hard disk. The August MDX Puzzle, which was related to this application, challenged you to write an MDX query that returns...
In my June 28 commentary, I asked you to tell me about the most significant things you learned about SQL Server at the Microsoft TechEd 2001 conference. I also promised to share my thoughts. Interestingly, most people who responded focused on a...
How to write secure SQL Server–based applications
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;
}
...
Tips and tricks for keeping your indexes in shape