if you are tired of the limit of editing and selecting rows in Management studio this is how you can change it. from tools menu select options and this is how you can change it.
know that loading a lot of rows affects the client machine memory to say the least not to mention locking rows in case of editing.
