Hello folks, I believe most of us are having problems with stuburn CDC and would like to get rid of it someday somehow! Well, say no more! Usually after a srestore, CDC gets stuck and doesn’t behave properly but disabling using the old fashioned way doesn’t work either. So here’s a complete script how to… Continue reading Script to completely Disable and Remove CDC
Let’s face it, we all have multiple humongous procs that take ages to execute, and are merging a bunch of tables with a bunch of temp tables. When it works, it’s all wine and roses, but what if it doesn’t work? It always work until it does not 😦 So, here’s the scenario, you have… Continue reading When Hash Match on Merge takes FOREVER!
So, there is this rumor that using a query hint affects the statistics that SQL Server uses to determine the execution plan, so we are told to ignore it. Well, ain’t that just great. Lets test it! So we did our setup. Lets test it on a simple select. 2373 gives us the memory allocation, and… Continue reading Do “random” Query Hints affect statistics in the Execution Plan?