SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: August 2011

Creating Facebook page for blog

Few weeks ago I released my SSMS productivity add-in and it has already almost 200 downloads. Responses are quite warm and I am very glad. Many users are also waiting for SQL Server 2005/2008 support (2008 R2 is only supported version now) and I will release it soon. I received… Read more

2 comments, 713 reads

Posted in SQL Treeo on 29 August 2011

How to write data from user-defined function

Writing data from within user-defined function is not permitted. You cannot use any INSERT/UPDATE/DELETE/MERGE statement because they’re “side-effecting” for SQL Server. My colleague recently needed to log something from within function so we were searching for solution how to do that with least work. There is one option to call… Read more

0 comments, 1,111 reads

Posted in SQL Treeo on 28 August 2011

Great new analytical functions in SQL Server 2011 “Denali”

SQL Server 2011 “Denali” is quite rich for new functions which have really good practical use in T-SQL. I’ve read about another new functions in Denali’s Books Online. I am missing those functions, I will write about, really for years. They’re filled under “Analytical function” and they are close to… Read more

0 comments, 591 reads

Posted in SQL Treeo on 14 August 2011

Download free SSMS Add-In to create custom folders for database objects

I’ve just finished promised SSMS add-in which enables creating of custom folders directly in SSMS Object Explorer. Idea for add-in came from fact that I was dealing with hundreds of SQL objects and was fed up of browsing for correct one in SSMS standard folders. I tried also many “quick… Read more

1 comments, 2,467 reads

Posted in SQL Treeo on 8 August 2011

SQL Server 2011 “Denali”: Get T-SQL query metadata without executing it

SQL Server 2011 “Denali” introduces couple of new procedures which enable you to read query metadata without executing it. Previous versions of SQL Server support reading metadata from system catalog but it is possible only for fixed objects. With following new procedures you can do similar thing but for dynamic… Read more

0 comments, 886 reads

Posted in SQL Treeo on 3 August 2011

Awesome new features in SQL Server 2011 “Denali”: IIF and CHOOSE functions

SQL Server 2011 “Denali” introduces two new features for flow control which may help you to keep your T-SQL cleaner than in previous versions. It is IIF and CHOOSE. These two function are very simple but it’s good to know they’re there.

IIF Function
Any developer should be aware of… Read more

2 comments, 557 reads

Posted in SQL Treeo on 2 August 2011