Tracing without SQL Profiler As a SQL Server DBA you’ll eventually find yourself trying to troubleshoot a performance issue that leads to you needing to capture the activity occurring on the SQL server itself. For many of us that means launching SQL Profiler and creating a trace to run against the server. When dealing with(…)
The weather is unseasonably warm here in the Midwest and when that first bit of Spring hits we traditionally open the windows and let the fresh breeze tame the stale winter air that’s been locked in our homes the past 6 months. We try on our swimsuits. We cringe at the amount of muffin-topiness that(…)
Just add another one on there somewhere Bubba… wherever you can find room. Default Behavior By default, new databases are created with the following basic file settings: Data File: 2 MB 1 MB unrestricted growth Log File 1Mb 10% unrestricted growth Just exactly why is this bad? It will assuredly increase the frequency at which files(…)