SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry

I just read a very interesting post by Pinal Dave on 3 new DMVs in Denali.

Interesting.

In his post Pinal is asking the audience to help decipher the purpose of the DMVs. So here is my answer:

There is almost nothing new in this case, except for the fact that the information is available through DMVs.

In the

Continue reading […] SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry […]

 

SSIS package ignores the decimal points value

Background: I am importing data from a csv file to SQL Server. Some of the columns in the csv file are obviously of the decimal data type and look like 123,12.

Problem: I wrote a SSIS package to import the data, everything imports without error, but the data in the table does not contain anything but

Continue reading […] SSIS package ignores the decimal points value […]

 

Upgrading the edition of SQL Server

Today I realized that I had a clustered instance of a SQL Server 2008 R2, which was installed as a Standard edition.

The databases which were about to be moved to that instance were residing on a Enterprise edition test environment, and I know for a fact that they were utilizing some of the Enterprise features.

By

Continue reading […] Upgrading the edition of SQL Server […]