I have been using SQL Server for about 8 years now. When compared to my peers (read: coworkers) I would classify myself as a SQL Server guru. When compared to many I meet on sites like SQLServerCentral.com where there seem to be those I would classify »
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 »
I can’t believe I never thought of doing things this way before. It’s so much better than concatenating strings and converting back and forth between varchar, int and datetime. I’d like to thank Marc for posting this jewel. Here’s the link to the original »
Ever have to work on a database with a large number of views and you needed to search the content of the objects? Well, here’s a query which will allow you to search inside your view objects: DECLARE @search VARCHAR(1000) SET @search = '[text]' SELECT »
Frustrated by the inability to script SQL Server 2005 objects with BOTH a CREATE and DROP statement? Generally, I write all my scripts with both statements and then save them and include them in source control, so this hasn’t really been a problem for »
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 »