The ARRAYSIZE parameter controls the number of rows that can be returned from disk in a single network transfer. If you set ARRAYSIZE correctly, you can substantially reduce the number of network pack...
Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace, once you get past the learning curve it’s probably the way to go. If you are operating in the ...
Workspaces in Toad Data Modeler can be used for splitting Entity Relationship Diagrams (ERD) to smaller parts.In case your model is large, it is always recommended to use workspaces to limit the amoun...
