I have a CLR function thet returns IEnumberable (a table) and it has a FillRow function. I am returning 10,000 integers from this function. Is there any way that I can preallocate the resulting table or give SQL server hint as to how many rows my function will return? It makes me ...
We are experiencing OutOfMemoryException on our Production web server(s) when requests been made for certain PDF document download(s). Production web server(s) (we have 2 such servers load balanced in
why do the gadgets (outside its gadget bar) move around on the screen each diffrent boot up. or switch its place (inside the gadget bar) from top to bottom? or is this a image of my imagenation!!!!!!!!
I was wondering what the performance of a filtering operation on a dataset could be? For small set of data, it's ok, but what if I filter, let's say, 50 M rows? I'm asking because I was wondering if it could be faster to filter data in
One of our customers experiences a big delay on the start of our WinForms application. By adding additional tracing I identified that there are actually two places where delay occurs. The first delay is exactly 30 seconds. It happens after the method