Checking for BLOBs that were created in the Primary Filegroup by default. To move them was a manual process and is a different topic from the crux of this one. Since the initial report to find the BLOBs, I have evolved it somewhat to try and find the size of each object, as well as to report on the usage related with each.
Have you ever done anything that made you feel like a dunderhead? Maybe a little bone-headed, thick, numb-skullish? Here is my grin and bear it oops post about a recent post I wrote. I somehow […]
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!