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 »
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 »