What does an Index mean to a Query

This post is about the importance of a right index to a query. The following simple query was considered.

SELECT
[GroupBy1].[A1] AS...

What does an Index mean to a Query

This post is about the importance of a right index to a query. The following simple query was considered. [crayon-5e81b52eda1f0195410103/] Even simple, this query was causing troubles on our production...

What does an Index mean to a Query

This post is about the importance of a right index to a query. The following simple query was considered. [crayon-5e96566159ca8644006533/] Even simple, this query was causing troubles on our production...

Connect to SQL Azure database from SSMS

In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have...

Connect to SQL Azure database from SSMS

In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you...

Connect to SQL Azure database from SSMS

In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you...

Changing SQL Server name

This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that:...

Changing SQL Server name

This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that:...

Changing SQL Server name

This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that: You simply forgot to change the name of your...

Changing SQL Server name

This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that: You simply forgot to change the name of your...