This is nothing new or revolutionary, but is important nonetheless for those maintaining large-scale SQL Server databases. For years I’ve used the sysindexes system table to find out how many rows are in a large table. The reason for this is to prevent »
The load balancer I wrote last year never made it into full production. While it was still in Q&A we hit our deadline and we stopped new development as we hit our “busy season”. At MaxPreps, once the fall season starts and football is in full swing our »
I’ve started investigating the SQL CLR and decided as my first article to tie in a bit to my article on using SQL parameters in ad hoc queries. This time I’m touching on an advanced topic of sql parameters - how to pass an array as a parameter. This takes »
As I look around the net at different articles and tutorials I’m surprised at how many use Dynamic SQL for samples. Even after the many warnings about SQL injection attacks. But there are other issues besides security. One of which is performance - dynamic »
I have been working on a “load balancing” application for OLAP applications and one or two of my previous posts touch on some things I’ve learned in the process. But now that I’ve got a working beta version I’ve decided to write my first “formal” article »
SQL Profiler has been aptly referred to as the “poor man’s load tester”. 3 months ago I captured trace logs spanning 1 week. My intent was over the summer (our companies “off-season”) to use the trace logs to stress test the database to determine the »