DaniWeb IT Discussion Community

Blogs (http://www.daniweb.com/blogs/)
-   Member Blogs (http://www.daniweb.com/blogs/blogs.php)
-   -   derekholmes's Blog (http://www.daniweb.com/blogs/blog250090.html)
-   -   -   SQL Studio 2005 Row Count (http://www.daniweb.com/blogs/entry1899.html)

derekholmes derekholmes's Blog
Dec 17th, 2007, 3:13 pm
Gripe about Microsoft Sql Server Management Studio

I just wasted a day because of sql 2005. I just updated (i know late) but can't believe how buggy it still is.

I had set my 'set rowcount' option under to 100 hoping that it would limit the rows i was viewing in the results. I don't like how it will load the whole table by default when viewing data. (which i still haven't figured out how to do)

Anyways it limited the results of temp tables i wasn't even viewing, just storing. I didn't notice until a few weeks later when working with a bigger table and half of my data was missing.