Geeks With Blogs

News


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: GeeksWithBlogs.net