Geeks With Blogs


Brian Biales because blogging is just the easiest way to remember things SQL Server
What happened to Intellisense in Microsoft SQL Management Server 2012? They broke it…
I was very happy with Intellisense in SQL Management Studio 2008, it worked great. So I was very surprised to have so many issues with it when I installed the 2012 version. First of all, it seems to take forever for it to load/cache database objects that used to be available almost instantly. With the 2012 version I can open a new query window and start typing and I don’t expect any help right away. Sometimes it takes minutes before I get any help. And my databases are not very large or complicated. ......

Posted On Monday, February 11, 2013 10:04 AM

How to nest transactions nicely - "begin transaction" vs "save transaction" and SQL Server
Do you write stored procedures that might be used by others? And those others may or may not have already started a transaction? And your SP does several things, but if any of them fail, you have to undo them all and return with a code indicating it failed? Well, I have written such code, and it wasn’t working right until I finally figured out how to handle the case when we are already in a transaction, as well as the case where the caller did not start a transaction. When a problem occurred, my ......

Posted On Thursday, March 15, 2012 4:27 PM

Copyright © Brian Biales | Powered by: