.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

A *.map files gets corrupted from time to time

Posted By:      Posted Date: October 26, 2010    Points: 0   Category :Sql Server


   we have the problem with SSAS,  a *.map files gets corrupted from time to time. Anyone seen this problem with SSAS 2008 ? After reprocessing the partition problem are gone till next time and probably with another *.map file. There is no messages regarding disk system in the Server EventLog, so I guess this problem is with SSAS. We are processing dimensions and adding new data to partitions on regular basis. We do not encounter any errors during dimension or partition processing. The following error is encountered only when selecting data from given partition. The corruption occurs with no visible pattern. Every time it is a map file for a different cube, different partition and different dimension. Most of the time archive partitions’ map files are getting corrupted; no data is added to them during daily processing. Reprocessing corrupted partition solves the problem, but another file is getting corrupted after approximately a week. We tried to do full reprocess to Analysis Database, but corruption still occurs. Currently both of our servers encounter similar errors. 

Error message when you try to execute query:
 #Error File system error: The following file is corrupted: Physical file: \\?\F:\SSAS_DATA\analysis.0.db\....\1200.Campaign.ID

View Complete Post

More Related Resource Links

Toolbox: Save Coding Time, Manage Compressed Files, and More


Save Coding Time, Manage Compressed Files, and More

Scott Mitchell

MSDN Magazine January 2007

adding sqlserver database files in the time of project deployeement

hi all,        how can i add sql server 2005 database files in the time of a windows application project deployment i have designed a project in Visual Studio 2005 using vb.net language and i want add sql server 2005 database file to it. i am connecting to sql server database by the connection string not using any any dataset or anything else. so how can i add database file ... please replay... 

wsp files taking alot of time to deploy

In order to integrate SSRS 2008 with MOSS 2007, we added a server as a WFE on the farm. this wfe has SSRS 2008 configured. but after that the wsp files, though not giving any error... are taking more than 30 minutes to deploy and retract... the configuration of the farm is simple too. 2 front end, 1 search and 1 database. i have tried restarting the timer service and turning the timer service off on the wfe2 (where SSRS 2008 is also present).... any ideas?
Adnan Shamim

How to create and copy files into a subdirectory at run time.


Good Day,


I have a folder on my server say:


in that folder there is 4 folders






in the pics folder is jpg's that are the buttons for a web page, the web page is in the MasterArt folder and is named default.aspx


upon a user creating an account, i have my program create a folder under a subfolder named ARTIST

I got that part but now what I need to learn how to do is to have at run time, when a new user creates an account, that my program creates a subdirectory under the ARTIST subdirectory and then I copy the default.aspx from the MasterArt folder into their folder, then copy the folders and contents of the 4 subfolders (pics, videos, music, other) so that they now have the direcotries and its contents.


Example: I create a user account and my artist name is Kevin

a subdirectory is created called Kevin, the folder Kevin should now have the default.aspx page, and 4 sub folders, pics, videos, music, and other.


How do I do this? I thanks in advance for any help!



How to minimize time when creating 2005 merge replication with very large data files and log files?


Dear all,

We're using window server 2003 sp1 + sql ent 2005 sp2 with merge replication between 2 servers. Since 1 of server sql is down, we need to create merge replication again. However, our data file size is 60Gb and log size is 40 GB and when we create merge replication it may need more than 10 hours to finish which is unacceptable since when creating replication the online db normal service operation may be affected. Is there any other way that can reduce the replication creation time within 5 hours to finish? Thanks a lot.


P.S: we are using full recovery model and plan to change to simple recovery model. Any help?




create one-time backup files


(using SQL 2008)

Here is my situation.  I have administrative rights to a particular database, but not the entire server.  The server admin makes a new backup every night for all the databases. 

At certain points in time, I would also like to save a backup file of my database, but of course don't want to alter the existing backup schedule.  Is this possible?

Round off time to the nearest minute

How would you round this up to the nearest minute? There isn't a built in function to do this so you have to use a little bit of maths to get there. There are 60 seconds in a minute. We already have 38 seconds on the clock. So we need to add on 60 - 38 = 22 more seconds.

Performance Tests: Precise Run Time Measurements with System.Diagnostics.Stopwatch

Everybody who does performance optimization stumbles sooner or later over the Stopwatch class in the System.Diagnostics namespace. And everybody has noticed that the measurements of the same function on the same computer can differ 25% -30% in run time. This article shows how single threaded test programs must be designed to get an accuracy of 0.1% - 0.2% out of the Stopwatch class. With this accuracy, algorithms can be tested and compared.

Date and Time Functions in SQLSERVER

Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

1 DATEPART Function
2 DATENAME Function
3 DAY, MONTH, and YEAR Functions
5 DATEADD Functions
6 DATEDIFF Function
7 More SQL Server Functions

Data Types - Date and Time in SqlServer

Date and time values can be stored with either the DATETIME or SMALLDATETIME data type. The difference between the two is that SMALLDATETIME supports a smaller range of dates and does not give the same level of precision when accounting for time. The DATETIME data type can hold values from January 1st of 1753 to December 31st of 9999. The time is stored to the 1 three hundredths of a second and each value takes up 8 bytes of storage. The SMALLDATETIME data type can hold values between January 1st 1900 and June 6th of 2079. The time is tracked to the minute and each value takes up 4 bytes of storage. The majority of business applications can live happily with SMALLDATETIME, however, if you are in an environment where each second matters or you need to make estimates to the distant future (or past) then you have to resort to DATETIME. If you fail to specify the time when inserting a value into a DATETIME or SMALLDATETIME column, a default of midnight is used. If you fail to specify the date portion the default of January 1, 1900 is used.

How to programmatically add controls to Windows forms at run time by using Visual C#

Create a Windows Forms Application
Start Visual Studio .NET or Visual Studio 2005 or a later version, and create a new Visual C# Windows Application project named WinControls. Form1 is added to the project by default.
Double-click Form1 to create and view the Form1_Load event procedure.
Add private instance variables to the Form1 class to work with common Windows controls. The Form1 class starts as follows:

.NET 4 Web Application Startup Time

I was chatting with Jonathan Hawkins and some of the folks on the ASP.NET team about performance and Jonathan mentioned the startup time for large ASP.NET applications is improved on .NET 4. There are some improvements in the CLR and in ASP.NET itself that helped. If you have a giant app, you should do some tests.

Built-in Functions - Date and Time Functions

Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

Essential SQL Server Date, Time and DateTime Functions

The essential date and time functions that every SQL Server database should have to ensure that you can easily manipulate dates and times without the need for any formatting considerations at all.

Date/Time Conversions Using SQL Server

There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another option is to use the built-in functions SQL Server provides to format the date string for you.

Date and Time Data Types and Functions

The following sections in this topic provide an overview of all Transact-SQL date and time data types and functions. For information and examples that are common to date and time data types and functions

The Free Barcode Creator produces barcode images one at a time, and allows easy saving to a file or

The Free Barcode Creator produces barcode images one at a time, and allows easy saving to a file or pasting into an application. 2D versions are also available:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend