Skip to content
  • About
  • Blog
    • Learn SQL Server
    • Tools and Scripts
    • Life and Me
  • Current Projects
  • LinkedIn
  • Twitter
  • Google Plus
  • GitHub
  • TechNet

Eitan Blumin's Blog

Data Professional and SQL Server DBA

Category: T-SQL

Let SQL Server Write Code for You

Many times I happen to find myself in a situation where, as a DBA, I need to write some long and cumbersome code (usually for maintenance purposes). For example: Write a script to copy a bunch of tables from one database to another. Import the tables from one database to another database. Rebuild a bunch… Read More Let SQL Server Write Code for You

October 28, 2018November 7, 2018 Eitan BluminLeave a comment

Efficiently UPDATE and DELETE using TOP and ORDER BY

Since SQL Server 2005, Microsoft had a nice addition to the common DML statements, UPDATE and DELETE, by allowing the use of the TOP keyword. Well, we’re now in the year 2018 and SQL Server 2019 is just around the corner, and yet unfortunately for many of us, SQL Server still doesn’t support the use… Read More Efficiently UPDATE and DELETE using TOP and ORDER BY

October 28, 2018November 7, 2018 Eitan BluminLeave a comment

Remove the IDENTITY property from an existing column

How to remove the IDENTITY property from an existing column using T-SQL (without changing the order of the columns or moving the data into a new table) Recently I had a scenario at a client where I needed to remove the IDENTITY property of a column in an existing table. The two common methods to… Read More Remove the IDENTITY property from an existing column

October 28, 2018November 6, 2018 Eitan BluminLeave a comment

Enter your email address to follow this blog and receive notifications of new posts by email.

Archive

  • January 2019 (2)
  • November 2018 (6)
  • October 2018 (14)

RSS

RSS Feed RSS - Posts

RSS Feed RSS - Comments

Categories

Life SQL Server Database Engine SQL Server Performance T-SQL Tools and Scripts

Tags

AlwaysOn Backup Collations Constraints Dynamic SQL HADR Identity Indexes Jobs MaxDOP Mirroring Monitoring Parallelism Performance Restore Security Service Broker SQL Injection SSRS Triggers TSQL webinar Zabbix
Powered by WordPress.com.