Thought provoking and helpful articles
from the Gooroo community.


  1. Another interesting trick with APPLY operator

  2. SQL Server - How to extract Storage related Meta Data for Monitoring and Automation

    1. How much Disk Space is my Database currently using on Disk and what is the real Data Volume in the Database files?2. How close is the Data Volume to the Storage Limits?The following article will show you how to extract all relevant information using T-SQL for automation - step by step.If you simply need a quick and dirty solution without going through the details feel free to jump the code block labelled PUTTING IT ALL TOGETHER at the very end of this article.The first table we want to look...
  3. Microsoft Business Intelligence approaches


  5. Initiating the Git

  6. How to remove HTML tag using SQL?

    If you have your data with tags like < div>,< span> , < br> , etc. You can use the function below to remove this characters from your string. Blog.The function removes all content between the characteres < , > and also that characteres too.The HTMLString is the input for the function below, the column ClearString is the output for the function below.I hope that will help you.Cheers!
  7. MS SQL: Google Maps API

  8. Http Patterns: Progress

  9. Data localization in DB

    Once we faced with the problem of data localization in our DB. Data was distributed on several tables. And we neede to choose a method accoring to requirements:We chose between next ways:For every table storing localizable data we introduce new additional table with localizable fields. Like this:In table Entity there is a description of some object, including default localization (our requirement number 2). CultureId is default language for the object.Table EntityLocalized stores all localizable...
  10. HTTP Patterns : Factory

  11. Edit DRAFT Edit

    • updated