I just read a very interesting post by Pinal Dave on 3 new DMVs in Denali.
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.
Continue reading […] SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry […]
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 […]
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.
Continue reading […] Upgrading the edition of SQL Server […]