When it is necessary to provide reports on activity occurring on the server, it pays to do a little prep work. Be Prepared. It is not an easy task to be able to go back in time and report on data that isn’t captured. The little prep work that one may need to do is well worth the effort in the end.
What if we could create a numbers table without IO? What if we could perform several different kinds of queries without IO? Itzik Ben Gan proposed a cascading CTE solution that does this sort of thing. This article shows that method in use to help improve certain IO conditions.
This month Rob Farley is hosting TSQL-Tuesday #3. The topic is Relationships and he has left it wide open for interpretation so long as it can be tied to the theme and SQL Server. At […]
The puzzling problem I encountered in the article was a fun little job that kept giving different results than running the same code from SSMS. Check it out!