I stumbled across something really cool when I was reading through the BOL entry on sp_trace_setevent*, which gives a list of all events and columns available to trace. This is, by the way, an extremely useful entry to have bookmarked. There are two events I hadn’t really noticed before: number 39, Deprecated, and 125, Deprecation […]
Category: Uncategorized
Remix! Optimized: Query by Hour, Day, Week, or Month
I originally posted this on 11/16/09. I repost here for the joy of TSQL Tuesday, and to add a very important change to the original solution. Here’s the accompanying video – same material, different format. The video doesn’t include the change, by the way. A solution is ever so much more elegant if you know the […]
Highly Amusing Index Frag Anecdote
I can’t believe I haven’t told this story from SQLPASS yet… and by the way, here’s Paul Randal’s blog on this same event/topic. One of the few sessions I managed to attend was a really cool Grant Fritchey (blog, twitter) session on DMVs. He was talking about the DMV that includes index fragmentation data (sys.dm_db_index_usage_stats) […]