---

Filter by type:

• All
• Blog Posts

System databases maintenance in SQL Server

• by romanhorolskiy

• Forrards Group Database Blog

Let’s talk about maintenance  of system databases in MS SQL Server. There are a few differences from user databases.
At first let`s remember...

2015-08-12

1,843 reads

Single instance vs. multiple instances of SQL Server on a server

• by romanhorolskiy

• Forrards Group Database Blog

Let`s consider a situation when you need to build a server with SQL Server used by multiple client applications. Here...

2015-08-03

15,106 reads

Forgot sa password for your SQL Server?

• by romanhorolskiy

• Forrards Group Database Blog

It may happen so that you don`t know the password of sa user for SQL Server you inherited from somebody....

2015-07-31 (first published: 2015-07-23)

4,706 reads

Migration of a large enterprise from SQL Server 2000 to 2014. Real life case.

• by romanhorolskiy

• Forrards Group Database Blog

This is a first article in a series of articles about real life database and IT infrastructure migration project which...

2015-07-31

3,277 reads

Consequences of wrong database autogrowth settings

• by romanhorolskiy

• Forrards Group Database Blog

In this article we`re going to address the question about autogrowth settings of the database. To be more precise we`re...

2015-07-30 (first published: 2015-07-21)

6,773 reads

Boost your OLTP database performance with SQL Server 2014 in-memory tables

• by romanhorolskiy

• Forrards Group Database Blog

Today we can already say with certainty that the most striking innovation in the MS SQL 2014 is the In-MemoryOLTP. In-Memory...

2015-07-24

1,185 reads

How to close all active database connections in one shot?

• by romanhorolskiy

• Forrards Group Database Blog

While trying to restore SQL Server database or do any other actions which require exclusive database access you may face...

2015-07-20

7,506 reads

SQL Server: utilize partitioning to purge large tables

• by romanhorolskiy

• Forrards Group Database Blog

Sooner or later every DBA needs to purge old data from database tables. And it often happens that such tables...

2015-07-17

3,017 reads

Paging in SQL Server 2012

• by romanhorolskiy

• Forrards Group Database Blog

Paging is one of the most highly required features during application development process. Microsoft has introduced various features since the...

2015-07-16 (first published: 2015-07-13)

2,838 reads

Creating Clustered Index on a Table Variable column in MS SQL Server

• by romanhorolskiy

• Forrards Group Database Blog

If you need to create an index in order to improve performance of the queries running against table variable (@temptable)...

2015-07-10

3,736 reads

Filter by type:

• All
• Blog Posts