by David | Sep 18, 2013 | Database, Debugging, Performance, Statistics
This is no work of mine but I wanted to highlight it since it´s such a good thing to utilise when optimizing your database and queries. SELECT SUBSTRING(qt.text, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(qt.text) ELSE...
by David | Sep 9, 2013 | Database, Statistics
When retrieving data for statistical usage in SQL it´s often useful to group the data to some kind of time interval. Easiest and most used is probably simple grouping by date: SELECT cast(Timestamp as date), COUNT(*) FROM MyTable GROUP BY cast(Timestamp as date)...
by David | May 30, 2013 | Database, Development, Statistics
When extracting timed statistics from SQL you usually want these stats grouped by some kind of time and more often than not this time unit is days. I used to do this unnecessarily complicated by converting the dates to varchars in formats I didn’t even want and...
by David | Mar 8, 2013 | Database, Performance
In our environment we´ve got a heavily loaded SQL Server as a trunk in the system. Most systems look like this and sooner or later you will probably want to troubleshoot bottlenecks in this database. From a nice fellow at Microsoft we got handed the scripts from Jimmy...
by David | Feb 12, 2013 | Database, Debugging
The other day I stumbled upon a tool i´ve been long searching for: Sql Server Managment Studio Boost Its got a lot of features but the one I´d like to highlight is the long wanted “save binary data” -function. Its simple as hell and even got a few presetup...