Skip to content

Igor Micev

My blog about SQL Server

Menu

Primary menu

  • Blog
  • About Me

Tag Archives: functions

Using Time Zones in SQL Server

Posted on August 18, 2017 by Igor Micev — 2 Comments ↓

The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be run in different time zones. Services have to consider the time zones. Applications’ users nowadays, which are around the globe Continue reading Using Time Zones in SQL Server→

Posted in .NET, Programming | Tagged C#, CLR, functions | 2 Replies

RegEx in SQL Server for replacing text

Posted on August 1, 2017 by Igor Micev — No Comments ↓

In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in SQL Server using regex, and now I’m showing how to use it for replacing text in SQL Server. The two Continue reading RegEx in SQL Server for replacing text→

Posted in .NET, Programming, T-SQL | Tagged C#, functions, Regex | Leave a reply

RegEx in SQL Server for searching text

Posted on July 24, 2017 by Igor Micev — 4 Comments ↓

As a database developer or DBA, or even software developer, you must have met up with the difficulties of finding some strings/sub-strings in the text columns. In such situations, we usually make two or more queries in order to cover Continue reading RegEx in SQL Server for searching text→

Posted in .NET, Programming, T-SQL | Tagged C#, functions, Regex | 4 Replies

T-SQL for UDFs

Posted on January 15, 2016 by Igor Micev — No Comments ↓

SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for our purposes. Such one, for example, is the function that returns the number of the days in a month. Before Continue reading T-SQL for UDFs→

Posted in T-SQL | Tagged EOMONTH, functions | Leave a reply

Primary Sidebar Widget Area

Recent Posts

  • Useful T-SQL queries and scripts to work in SQL Server
  • How to Write a Better T-SQL Code
  • Some New Cool Features in SSMS

Categories

  • .NET (3)
  • Configuration (6)
  • Database design (5)
  • Features (4)
  • Installation (4)
  • Maintenance (7)
  • Optimization (5)
  • Programming (5)
  • Scripts (4)
  • SQL Server (2)
  • SSMS (6)
  • T-SQL (13)
  • Technology (2)
  • Uncategorized (6)

Tags

C# clone CLR code-refactoring compression configuration constraints cpu CXPACKET dates EOMONTH extents foreign keys fragmentation functions hints and tips indexes JASON jobs jokes licensing master rebuild maxdop MCT mixed_page_allocation MVP powershell primary key query Regex reports report server sample databases script snapshot SQL Azure sql server ports stored procedures system databases tempdb temp tables

Subscribe via Email

Subscribe via Email

  • Twitter
  • Google Plus
  • Linkedin
  • RSS Feed
Copyright © 2022 Igor Micev. All Rights Reserved.
Theme: Catch Box by Catch Themes
Scroll Up