Script to completely Disable and Remove CDC

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

Do “random” Query Hints affect statistics in the Execution Plan?

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?