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

14,301 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,656 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,016 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)

5,921 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,182 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

6,825 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

2,894 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,833 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,019 reads

SQL Server Storage best practices

• by romanhorolskiy

• Forrards Group Database Blog

Server storage is one of the most important things for SQL Server performance. Chances to utilize a lot of RAM and...

2015-07-09

2,253 reads